private void btnAdd_Click(object sender, EventArgs e)
{
String cusID = this.txtCusID.Text;
String cusName = this.txtCusName.Text;
String cusAddr = this.txtCusAddr.Text;
String cusGender = this.cbGender.SelectedItem.ToString();
String cusPhone = this.txtCusPhone.Text;
if (isValid(cusID, cusName, cusAddr, cusPhone))
{
DTO_CCustomer customer = new DTO_CCustomer(cusID, cusName, cusAddr, cusPhone, cusGender);
new BUS_CCustomer().addCustomer(customer);
this.loadCusList();
}
}
public void pr_ThemKH(DTO_CCustomer C)
{
try
{
SqlCommand cmd = new SqlCommand("pr_ThemKH", DAL_CDBConnect.myconn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@MsKH", System.Data.SqlDbType.Char, 10).Value = C.MsKH;
cmd.Parameters.Add("@TENKH", System.Data.SqlDbType.NVarChar, 30).Value = C.TENKH;
cmd.Parameters.Add("@PHAI", System.Data.SqlDbType.NVarChar, 50).Value = C.PHAI;
cmd.Parameters.Add("@DIACHI", System.Data.SqlDbType.NVarChar, 100).Value = C.DIACHI;
cmd.Parameters.Add("@DIENTHOAI", System.Data.SqlDbType.VarChar, 10).Value = C.DIENTHOAI;
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
}
catch (Exception X)
{
MessageBox.Show(X.Message.ToString());
}
}
public bool addCustomer(DTO_CCustomer customer)
{
try
{
SqlCommand command = new SqlCommand("pr_ThemKH", DAL_CDBConnect.myconn);
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.Add("@MsKH", System.Data.SqlDbType.Char, 10).Value = customer.CusID;
command.Parameters.Add("@TENKH", System.Data.SqlDbType.NVarChar, 30).Value = customer.CusName;
command.Parameters.Add("@PHAI", System.Data.SqlDbType.NChar, 10).Value = customer.CusGender;
command.Parameters.Add("@DIACHI", System.Data.SqlDbType.NVarChar, 50).Value = customer.CusAddr;
command.Parameters.Add("@DIENTHOAI", System.Data.SqlDbType.VarChar, 10).Value = customer.CusPhone;
bool success = command.ExecuteNonQuery() >= 0;
command.Parameters.Clear();
command.Dispose();
return(success);
}catch (SqlException ex)
{
MessageBox.Show(ex.Message.ToString());
return(false);
}
}
public void pr_ThemKH(DTO_CCustomer C)
{
}
public bool addCustomer(DTO_CCustomer customer)
{
return(new DAL_CCustomer().addCustomer(customer));
}
