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); }