public void delete(string ID) { using (DBAccess.DBAccess db = new DBAccess.DBAccess()) { string[,] param = { {"@ID", ID} }; db.ExecuteNonQuery("sprDeleteCustomer", param); } }
public void add(ModelCustomer MC) { using (DBAccess.DBAccess db = new DBAccess.DBAccess()) { string[,] param = { {"@NAME", MC.Name}, {"@ADDRESS", MC.Address} }; db.ExecuteNonQuery("sprInsertCustomer", param); } }
public void update(ModelCustomer MC) { using (DBAccess.DBAccess db = new DBAccess.DBAccess()) { string[,] param = { {"@ID", MC.Id.ToString()}, {"@NAME", MC.Name}, {"@ADDRESS", MC.Address} }; db.ExecuteNonQuery("sprUpdateCustomer", param); } }