private void button1_Click(object sender, EventArgs e)
 {
     EKHACHHANG ek = new EKHACHHANG();
     ek.MAKH = txtsdt.Text.Trim();
     ek.TENK = txttenk.Text.Trim();
     ek.GIOITINH = rdNam.Checked ? "Nam" : "Nữ";
     ek.SDT = txtsdt.Text.Trim();
     ek.DIACHI = txtdc.Text.Trim();
     DataTable dt = BKHACHHANG.SelectAll(txtsdt.Text.Trim());
     if (dt == null || dt.Rows.Count == 0)
     {
         BKHACHHANG.Insert(ek);
     }
     else { BKHACHHANG.Update(ek); }
     //hoa don
     EHOADON ehd = new EHOADON();
     ehd.SOHOADON = txtshd.Text.Trim();
     ehd.NGAYHOADON = dtngay.Value.Day.ToString() + "/" + dtngay.Value.Month.ToString() + "/" + dtngay.Value.Year.ToString();
     ehd.MAKH = txtsdt.Text.Trim();
     ehd.NHANVIEN = txtnv.Text.Trim();
     ehd.GHICHU = txtghichu.Text.Trim();
     if (!isHD)
     {
         BHOADON.Insert(ehd);
         isHD = true;
     }
     else { BHOADON.Update(ehd); }
     button1.Text = "Sửa hóa đơn";
     grbcthd.Enabled = true;
 }
 //---------------------------------------------------------------------------------------------------------//
 public static void Insert(EKHACHHANG OKHACHHANG)
 {
     SqlParameter[] pr = new SqlParameter[5];
     pr[0] = new SqlParameter(@"MAKH", OKHACHHANG.MAKH);
     pr[1] = new SqlParameter(@"TENK", OKHACHHANG.TENK);
     pr[2] = new SqlParameter(@"GIOITINH", OKHACHHANG.GIOITINH);
     pr[3] = new SqlParameter(@"SDT", OKHACHHANG.SDT);
     pr[4] = new SqlParameter(@"DIACHI", OKHACHHANG.DIACHI);
     DataAccseL.ExecuteNonQuery(CommandType.StoredProcedure, "KHACHHANG_Insert", pr);
 }
        public EKHACHHANG(string vMAKH)
        {
            EKHACHHANG OKHACHHANG = BKHACHHANG.SelectByID(vMAKH);

            this.MAKH     = OKHACHHANG.MAKH;
            this.TENK     = OKHACHHANG.TENK;
            this.GIOITINH = OKHACHHANG.GIOITINH;
            this.SDT      = OKHACHHANG.SDT;
            this.DIACHI   = OKHACHHANG.DIACHI;
        }
 private void btnSua_Click(object sender, EventArgs e)
 {
     EKHACHHANG ek = new EKHACHHANG();
     ek.MAKH = txtsdt.Text.Trim();
     ek.TENK = txttenk.Text.Trim();
     ek.GIOITINH = rdNam.Checked ? "Nam" : "Nữ";
     ek.SDT = txtsdt.Text.Trim();
     ek.DIACHI = txtdc.Text.Trim();
     BKHACHHANG.Update(ek);
     FormKhachhang_Load(sender, e);
 }
 private void btnThem_Click(object sender, EventArgs e)
 {
     for (int i = 0 ; i < dgvData.Rows.Count-1; i++)
     {
         if (txtsdt.Text.Trim()==dgvData.Rows[i].Cells[0].Value.ToString())
         {
             MessageBox.Show("Khách hàng đã tồn tại, vui lồng nhấn nút sửa để cập nhật thông tin","Cảnh báo",MessageBoxButtons.OK,MessageBoxIcon.Error);
             return;
         }
     }
     EKHACHHANG ek = new EKHACHHANG();
     ek.MAKH = txtsdt.Text.Trim();
     ek.TENK = txttenk.Text.Trim();
     ek.GIOITINH = rdNam.Checked ? "Nam" : "Nữ";
     ek.SDT = txtsdt.Text.Trim();
     ek.DIACHI = txtdc.Text.Trim();
     BKHACHHANG.Insert(ek);
     FormKhachhang_Load(sender, e);
 }
 //---------------------------------------------------------------------------------------------------------//
 private static EKHACHHANG GetOneKHACHHANG(IDataReader idr)
 {
     EKHACHHANG OKHACHHANG = new EKHACHHANG();
     if (idr["MAKH"] != DBNull.Value)
         OKHACHHANG.MAKH = (string)idr["MAKH"];
     if (idr["TENK"] != DBNull.Value)
         OKHACHHANG.TENK = (string)idr["TENK"];
     if (idr["GIOITINH"] != DBNull.Value)
         OKHACHHANG.GIOITINH = (string)idr["GIOITINH"];
     if (idr["SDT"] != DBNull.Value)
         OKHACHHANG.SDT = (string)idr["SDT"];
     if (idr["DIACHI"] != DBNull.Value)
         OKHACHHANG.DIACHI = (string)idr["DIACHI"];
     return OKHACHHANG;
 }
 public static EKHACHHANG SelectByID(string MAKH)
 {
     EKHACHHANG OKHACHHANG = new EKHACHHANG();
     SqlParameter[] pr = new SqlParameter[1];
     pr[0] = new SqlParameter(@"MAKH", MAKH);
     IDataReader idr = DataAccseL.ExecuteReader(CommandType.StoredProcedure, "KHACHHANG_SelectByID", pr);
     if (idr.Read())
         OKHACHHANG = GetOneKHACHHANG(idr);
     idr.Close();
     idr.Dispose();
     return OKHACHHANG;
 }
 public static void Update(EKHACHHANG OKHACHHANG)
 {
     SqlParameter[] pr = new SqlParameter[5];
     pr[0] = new SqlParameter(@"MAKH", OKHACHHANG.MAKH);
     pr[1] = new SqlParameter(@"TENK", OKHACHHANG.TENK);
     pr[2] = new SqlParameter(@"GIOITINH", OKHACHHANG.GIOITINH);
     pr[3] = new SqlParameter(@"SDT", OKHACHHANG.SDT);
     pr[4] = new SqlParameter(@"DIACHI", OKHACHHANG.DIACHI);
     SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, "KHACHHANG_Update", pr);
 }