using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace Supermarket { public partial class CategoriesForm : Form { public CategoriesForm() { InitializeComponent(); } private void ProductButton3_Click(object sender, EventArgs e) { this.Hide(); ProductForm log = new ProductForm(); log.Show(); } private void CategoryButton3_Click(object sender, EventArgs e) { this.Hide(); CategoriesForm log = new CategoriesForm(); log.Show(); } private void SellerButton3_Click(object sender, EventArgs e) { this.Hide(); SellerForm log = new SellerForm(); log.Show(); } private void populate() { Con.Open(); string query = "SELECT * FROM CategoryData"; SqlDataAdapter sda = new SqlDataAdapter(query, Con); SqlCommandBuilder builder = new SqlCommandBuilder(sda); var ds = new DataSet(); sda.Fill(ds); CategoryDatagrid.DataSource = ds.Tables[0]; Con.Close(); } SqlConnection Con = new SqlConnection(@"[Your Data Location]"); private void AddButton3_Click(object sender, EventArgs e) { try { Con.Open(); string query = "INSERT INTO CategoryData VALUES(" + CategoryId.Text + ", '" + CategoryName.Text+ "', '" + CategoryDescription.Text+ "')"; SqlCommand cmd = new SqlCommand(query, Con); cmd.ExecuteNonQuery(); MessageBox.Show("Category Added Successfully"); Con.Close(); populate(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } private void EditButton3_Click(object sender, EventArgs e) { try { Con.Open(); string query = "UPDATE CategoryData SET CategoryName='" + CategoryName.Text+ "', CategoryDescription='" + CategoryDescription.Text+ "' WHERE CategoryId='" + CategoryId.Text+ "'"; SqlCommand cmd = new SqlCommand(query, Con); cmd.ExecuteNonQuery(); MessageBox.Show("Category Updated Successfully"); Con.Close(); populate(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } private void DeleteButton3_Click(object sender, EventArgs e) { try { Con.Open(); string query = "DELETE FROM CategoryData WHERE CategoryId = " + CategoryId.Text+ ""; SqlCommand cmd = new SqlCommand(query, Con); cmd.ExecuteNonQuery(); MessageBox.Show("Category Deleted Successfully"); Con.Close(); populate(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } private void CategoryDatagrid_CellContentClick(object sender, DataGridViewCellEventArgs e) { CategoryId.Text = CategoryDatagrid.SelectedRows[0].Cells[0].Value.ToString(); CategoryName.Text = CategoryDatagrid.SelectedRows[0].Cells[1].Value.ToString(); CategoryDescription.Text = CategoryDatagrid.SelectedRows[0].Cells[2].Value.ToString(); } private void panel5_Paint(object sender, PaintEventArgs e) { populate(); } private void Logout3_Click(object sender, EventArgs e) { this.Hide(); Login log = new Login(); log.Show(); } private void outbutton3_Click(object sender, EventArgs e) { Application.Exit(); } } }