Exemple #1
0
 public static bool AddCustomer(Customer a)
 {
     string sql = "sp_InsertCustomer";            
     SqlParameter CusName = new SqlParameter("@CusName", a.CusName);
     SqlParameter CusAddress = new SqlParameter("@CusAddress", a.CusAddress);
     SqlParameter CusPhone = new SqlParameter("@CusPhone", a.CusPhone);
     return DataProvider.ExecuteNonQuery(sql, System.Data.CommandType.StoredProcedure, CusName, CusAddress, CusPhone);
 }
Exemple #2
0
 public static Customer GetbyCustomerName(string name)
 {
     string sql = "sp_GetCustomer";
     SqlParameter Name = new SqlParameter("@CustomerName", name);
     SqlDataReader dr = DataProvider.ExecuteQueryWithDataReader(sql, CommandType.StoredProcedure, Name);
     if (dr.HasRows)
     {
         dr.Read();
         Customer a = new Customer();
         a.CusID = dr.GetInt32(0);
         a.CusName = dr.GetString(1);
         a.CusAddress = dr.GetString(2);
         a.CusPhone = dr.GetString(3);
         return a;
     }
     else
         return null;
 }
Exemple #3
0
 public static bool UpdateCustomer(Customer a)
 {
     return CustomerData.UpdateCustomer(a);
 }
Exemple #4
0
 public static bool AddCustomer(Customer a)
 {
     return CustomerData.AddCustomer(a);
 }
 private void btnOK_Click(object sender, RoutedEventArgs e)
 {
     if (isValid())
     {
         if (isUpdate)
         {
             lblName.Content = "Update Customer";
             try
             {
                 Customer cus = new Customer();
                 cus.CusID = CusID;
                 cus.CusName = txtName.Text;
                 cus.CusAddress = txtAddress.Text;
                 cus.CusPhone = txtPhoneNo.Text;
                 CustomerBL.UpdateCustomer(cus);
                 System.Windows.Forms.MessageBox.Show("Success");
                 this.Close();
             }
             catch (Exception h)
             {
                 System.Windows.Forms.MessageBox.Show("Error " + h.Message);
             }
         }
         else
         {
             try
             {
                 Customer cus = new Customer();                        
                 cus.CusName = txtName.Text;
                 cus.CusAddress = txtAddress.Text;
                 cus.CusPhone = txtPhoneNo.Text;
                 CustomerBL.AddCustomer(cus);
                 System.Windows.Forms.MessageBox.Show("Success");
                 this.Close();
             }
             catch (Exception h)
             {
                 System.Windows.Forms.MessageBox.Show("Error " + h.Message);
             }
         }
     }
 }