private void btnUpdateBrand_Click(object sender, EventArgs e) { clsBrand brand1 = new clsBrand(); brand1.Name = txtBrandName.Text; brand1.ID = id; clsBrandCollection brand = new clsBrandCollection(); int i = brand.editBrand(brand1); if (i != 0) { MessageBox.Show("Data Updated."); txtBrandName.Clear(); GetBrands(); BrandsName(); btnUpdateBrand.Hide(); btnDeleteBrand.Hide(); btnAddBrand.Show(); txtBrandName.Clear(); } else { MessageBox.Show("Failed to Update Data."); } }
public int deleteBrand(clsBrand brand) { SqlCommand cmd = new SqlCommand("sproc_tblBrand_Delete", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@id", brand.ID); con.Open(); int i = cmd.ExecuteNonQuery(); con.Close(); return(i); }
private void btnAddBrand_Click(object sender, EventArgs e) { clsBrand brand1 = new clsBrand(); brand1.Name = txtBrandName.Text; clsBrandCollection brand = new clsBrandCollection(); int i = brand.setBrand(brand1); if (i != 0) { MessageBox.Show("Data Saved"); txtBrandName.Clear(); GetBrands(); BrandsName(); } else { MessageBox.Show("Failed to Inert Data."); } }