public bool Delete(Customers_Buyers_BLL c) { bool isSuccess = false; SqlConnection conn = new SqlConnection(myconnstring); try { String sql = "Delete from Customers_Buyers where buyer_reg_no=@buyer_reg_no"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@buyer_reg_no", c.buyer_reg_no); conn.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { isSuccess = true; } else { isSuccess = false; } } catch (Exception e) { MessageBox.Show(e.Message); } finally { conn.Close(); } return(isSuccess); }
public bool Update(Customers_Buyers_BLL c) { bool isSuccess = false; SqlConnection conn = new SqlConnection(myconnstring); try { String sql = "Update Customers_Buyers set buyer_name=@buyer_name,company_name=@company_name,pincode=@pincode,contact=@contact,address=@address,city=@city, state=@state Where buyer_reg_no=@buyer_reg_no"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@buyer_reg_no", c.buyer_reg_no); cmd.Parameters.AddWithValue("@buyer_name", c.buyer_name); cmd.Parameters.AddWithValue("@company_name", c.company_name); cmd.Parameters.AddWithValue("@city", c.city); cmd.Parameters.AddWithValue("@state", c.state); cmd.Parameters.AddWithValue("@contact", c.contact); cmd.Parameters.AddWithValue("@pincode", c.pincode); cmd.Parameters.AddWithValue("@address", c.address); conn.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { isSuccess = true; } else { isSuccess = false; } } catch (Exception e) { MessageBox.Show(e.Message); } finally { conn.Close(); } return(isSuccess); }