public void add(ModelCustomer MC) { if (MC == null) return; DLCustomer DC = new DLCustomer(); DC.add(MC); }
public void update(ModelCustomer MC) { if (MC == null) return; DLCustomer DC = new DLCustomer(); DC.update(MC); }
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 ModelCustomer getCustomerByID(string ID) { using (DBAccess.DBAccess db = new DBAccess.DBAccess()) { string[,] param = { { "@Id", ID } }; using (SqlDataReader rdr = db.ExecuteReader("sprSelectCustomerByID", param)) { ModelCustomer item = new ModelCustomer(); while (rdr.Read()) { item.Id = Convert.ToInt32(rdr["Id"]); item.Name = rdr["Name"].ToString(); item.Address = rdr["Address"].ToString(); } return item; } } }
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); } }
private ModelCustomer GetFieldValuesCustomer() { string ErrMsg = ""; ModelCustomer MC = new ModelCustomer(); try { if (txtID.Text != "") MC.Id = Convert.ToInt32(txtID.Text); MC.Name = txtName.Text; MC.Address = txtAddress.Text; return MC; } catch (Exception ex) { ErrMsg = ex.Message.ToString(); ViewState["WithErrorCustomer"] = true; return null; } finally { MC.Dispose(); } }
private void FillFieldsCustomer(ModelCustomer MC) { txtID.Text = MC.Id.ToString(); txtName.Text = MC.Name; txtAddress.Text = MC.Address; }