private void btnSuaKH_Click(object sender, EventArgs e)
{
KhachHang_DTO khDTO = new KhachHang_DTO();
khDTO.MaKhachHang = txtMaKH.Text;
khDTO.TenKhachHang = txtTenKH.Text;
khDTO.DiaChi = txtDiaChi.Text;
khDTO.NgaySinh = Convert.ToDateTime(dtpNgaySinh.Text);
khDTO.SDT = txtDienThoai.Text;
khDTO.CMND = txtCMND.Text;
if (rdbNam.Checked)
{
khDTO.GioiTinh = "Nam";
}
else
{
khDTO.GioiTinh = "Nữ";
}
khDTO.QuocTich = cmbQuocTich.Text;
if (KhachHang_BLL.SuaKhachHang(khDTO) > 0)
{
XtraMessageBox.Show("Sửa thành công", "Thông báo");
LoadDuLieuKhachHang();
}
else
{
XtraMessageBox.Show("Sửa thất bại", "Thông báo");
}
}
public Boolean ThemKH(KhachHang_DTO kh)
{
string sql = "INSERT INTO KhachHang VALUES(N'" + kh.IDKhachHang + "', N'" + kh.Ho + "', N'" + kh.Ten
+ "', N'" + kh.GioiTinh + "', '" + kh.SDT + "', '" + kh.Email + "', N'" + kh.DiaChi + "', N'" + kh.QuocTich + "')";
return(new ExecuteDB().ExecuteData(sql));
}
private void toolStripSửa_Click(object sender, EventArgs e)
{
try
{
DataGridViewRow r = datagridviewKH.SelectedRows[0];
KhachHang_DTO kh = new KhachHang_DTO();
kh.MaKH = (int)r.Cells["MaKH"].Value;
kh.TenKh = r.Cells["TenKh"].Value.ToString();
kh.DiaChi = r.Cells["DiaChi"].Value.ToString();
kh.SDT = r.Cells["SDT"].Value.ToString();
kh.NgaySinh = r.Cells["NgaySinh"].Value.ToString();
M_KhachHangEdit form = new M_KhachHangEdit(kh);
form.Text = "CHỈNH SỬA THÔNG TIN KHÁCH HÀNG";
DialogResult dr = form.ShowDialog();
if (dr == DialogResult.OK)
{
loaddatagridview(this.kh.SelectTop(0));
}
}
catch (Exception)
{
//MessageBox.Show(e.ToString() + "\nNếu chưa chọn dòng nào hãy chọn 1 dòng");
}
}
public static void Sua(KhachHang_DTO kh)
{
SqlConnection conn = DataAccess.ketNoi();
string sqlUpdate = "UPDATE KHACHHANG SET TenKH=@TenKH, DiaChi=@DiaChi, SDTKH=@SDTKH WHERE MaKH = @MaKH";
SqlCommand cmd = new SqlCommand(sqlUpdate, conn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@TenKH", SqlDbType.NVarChar, 50);
cmd.Parameters.Add("@DiaChi", SqlDbType.NVarChar, 100);
cmd.Parameters.Add("@SDTKH", SqlDbType.VarChar, 11);
cmd.Parameters.Add("@MaKH", SqlDbType.VarChar, 11);
cmd.Parameters["@TenKH"].Value = kh.TenKH;
cmd.Parameters["@DiaChi"].Value = kh.DiaChi;
cmd.Parameters["@SDTKH"].Value = kh.SDTKH;
cmd.Parameters["@MaKH"].Value = kh.MaKH;
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
cmd.ExecuteNonQuery();
conn.Close();
}
public M_KhachHangEdit(KhachHang_DTO kh) // edit
{
khachhang = kh;
InitializeComponent();
EditorAdd = 0;
txtMaKhachHang.ReadOnly = true;
}
private void btnThemKM_Click(object sender, EventArgs e)
{
if (txtTenKH.Text == "")
{
MessageBox.Show("Bạn phải nhập tên khách hàng", "thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
int sdt = Convert.ToInt32(txtSDT.Text);
string tenkh = txtTenKH.Text;
KhachHang_DTO kh = new KhachHang_DTO(tenkh, sdt);
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(baseAddress);
//HTTP POST
var postTask = client.PostAsJsonAsync <KhachHang_DTO>("KhachHang", kh);
postTask.Wait();
var result = postTask.Result;
if (result.IsSuccessStatusCode)
{
MessageBox.Show("Thêm khách hàng thành công", "Thông báo", MessageBoxButtons.OK);
}
else
{
MessageBox.Show("Thêm khách hàng không thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
Load();
}
}
public static void Them(KhachHang_DTO kh)
{
SqlConnection conn = DataAccess.ketNoi();
string sqlInsert = "INSERT INTO KHACHHANG VALUES(@MaKH,@TenKH,@DiaChi,@SDTKH,@DiemTL)";
SqlCommand cmd = new SqlCommand(sqlInsert, conn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@MaKH", SqlDbType.VarChar, 10);
cmd.Parameters.Add("@TenKH", SqlDbType.NVarChar, 50);
cmd.Parameters.Add("@DiaChi", SqlDbType.NVarChar, 100);
cmd.Parameters.Add("@SDTKH", SqlDbType.VarChar, 11);
cmd.Parameters.Add("@DiemTL", SqlDbType.VarChar, 11);
cmd.Parameters["@MaKH"].Value = kh.MaKH;
cmd.Parameters["@TenKH"].Value = kh.TenKH;
cmd.Parameters["@DiaChi"].Value = kh.DiaChi;
cmd.Parameters["@SDTKH"].Value = kh.SDTKH;
cmd.Parameters["@DiemTL"].Value = kh.DiemTL;
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
cmd.ExecuteNonQuery();
conn.Close();
}
public static List <KhachHang_DTO> takeCustomers()
{
string sQuery = @"select *from KhachHang";
conn = DataProvider.Connect();
DataTable dt = DataProvider.dataSQuery(sQuery, conn);
if (dt.Rows.Count == 0)
{
return(null);
}
List <KhachHang_DTO> Cus = new List <KhachHang_DTO>();
for (int i = 0; i < dt.Rows.Count; i++)
{
KhachHang_DTO K = new KhachHang_DTO();
K.MaKH = dt.Rows[i]["MaKH"].ToString();
K.TenKH = dt.Rows[i]["TenKH"].ToString();
K.Cmnd = int.Parse(dt.Rows[i]["CMND"].ToString());
K.QuocTich = dt.Rows[i]["QuocTich"].ToString();
K.GioiTinh = dt.Rows[i]["GioiTinh"].ToString();
K.NgaySinh = DateTime.Parse(dt.Rows[i]["NgaySinh"].ToString());
K.Sdt = int.Parse(dt.Rows[i]["SDT"].ToString());
K.MaPhong = dt.Rows[i]["MaPhong"].ToString();
Cus.Add(K);
}
DataProvider.DongKetNoi(conn);
return(Cus);
}
public static List <KhachHang_DTO> takeCustomerFIdPhong(string id)
{
string sQuery = @"select k.* from Phong p , KhachHang K where p.MaPhong = k.MaPhong and p.MaPhong = '" + id + "' ";
//where p.MaPhong = k.MaPhong AND p.MaPhong = 'P003'
conn = DataProvider.Connect();
DataTable dt = DataProvider.dataSQuery(sQuery, conn);
if (dt.Rows.Count == 0)
{
return(null);
}
List <KhachHang_DTO> Cus = new List <KhachHang_DTO>();
for (int i = 0; i < dt.Rows.Count; i++)
{
KhachHang_DTO K = new KhachHang_DTO();
K.MaKH = dt.Rows[i]["MaKH"].ToString();
K.TenKH = dt.Rows[i]["TenKH"].ToString();
K.Cmnd = int.Parse(dt.Rows[i]["CMND"].ToString());
K.QuocTich = dt.Rows[i]["QuocTich"].ToString();
K.GioiTinh = dt.Rows[i]["GioiTinh"].ToString();
K.NgaySinh = DateTime.Parse(dt.Rows[i]["NgaySinh"].ToString());
K.Sdt = int.Parse(dt.Rows[i]["SDT"].ToString());
// K.MaPhong = dt.Rows[i]["MaPhong"].ToString();
Cus.Add(K);
}
return(Cus);
// DataProvider.DongKetNoi(conn);
}
public bool Update(KhachHang_DTO kh)
{
try
{
con.Open();
string SQL = string.Format("UPDATE KHACHHANG SET HOTEN =N'" + kh.HOTEN + "', MAHANGXE =" + kh.MAHANGXE + ", SODT ='" + kh.SODT + "', BIENSO ='" + kh.BIENSO
+ "', DIACHI ='" + kh.DIACHI + "', SOKM= '" + kh.SOKM + "', SOKHUNG ='" + kh.SOKHUNG + "' WHERE MAKH = " + kh.MAKH);
SqlCommand cmd = new SqlCommand(SQL, con);
if (cmd.ExecuteNonQuery() > 0)
{
return(true);
}
}
catch (Exception e)
{ }
finally
{
con.Close();
}
return(false);
}
public bool Insert(KhachHang_DTO kh)
{
try
{
con.Open();
string SQL = "Insert into KHACHHANG values(N'"
+ kh.HOTEN + "'," + kh.MAHANGXE + ",'" + kh.SODT + "','" + kh.BIENSO
+ "',N'" + kh.DIACHI + "','" + kh.SOKM + "','" + kh.SOKHUNG + "');";
SqlCommand cmd = new SqlCommand(SQL, con);
if (cmd.ExecuteNonQuery() > 0)
{
return(true);
}
}
catch (Exception e)
{ }
finally
{
con.Close();
}
return(false);
}
public bool CheckTonTai(KhachHang_DTO kh)
{
try
{
con.Open();
string SQL = string.Format("SELECT COUNT(BIENSO) FROM KHACHHANG WHERE BIENSO ='"
+ kh.BIENSO + "'");
SqlCommand cmd = new SqlCommand(SQL, con);
int count = (int)cmd.ExecuteScalar();
if (count == 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception e)
{ }
finally
{
con.Close();
}
return(false);
}
public static int ThemKhachHang(KhachHang_DTO khDTO)
{
string strTruyVan = string.Format("INSERT INTO KhachHang(MaKH,TenKH,NgaySinh,GioiTinh,CMND,DiaChi,SDT,QuocTich) VALUES('{0}',N'{1}','{2}',N'{3}','{4}',N'{5}','{6}','{7}')", khDTO.MaKhachHang, khDTO.TenKhachHang, khDTO.NgaySinh, khDTO.GioiTinh, khDTO.CMND, khDTO.DiaChi, khDTO.SDT, khDTO.QuocTich);
int count = DataProvider.ExecuteNonQuery(strTruyVan);
return(count);
}
private void timKiemMaHD_Click(object sender, EventArgs e)
{
if (cbBMaHoaDon.SelectedItem != null)
{
if (hdb_BUS.CheckMaHDB(cbBMaHoaDon.Text))
{
lvCTHDB.Items.Clear();
HoaDonBan_DTO hoaDonBan = (HoaDonBan_DTO)cbBMaHoaDon.SelectedItem;
hiemThiThongTinHoaDon(hoaDonBan);
KhachHang_DTO khachHang = (KhachHang_DTO)cbBMaKH.SelectedItem;
hiemThiThongTinKhachHang(khachHang);
NhanVien_DTO nhanVien = (NhanVien_DTO)cbBMaNV.SelectedItem;
tenNhanVien(nhanVien);
lsCTHDB = cTHDB_BUS.LayDanhSachTheoMa(cbBMaHoaDon.Text);
foreach (ChiTietHoaDonBan_DTO ctHDB in lsCTHDB)
{
ListViewItem lvi = new ListViewItem(ctHDB.MaHH);
lvi.SubItems.Add(ctHDB.TenHH);
lvi.SubItems.Add(ctHDB.SoLuong.ToString());
lvi.SubItems.Add(ctHDB.DonGia.ToString());
lvi.SubItems.Add(ctHDB.ThanhTien.ToString());
lvCTHDB.Items.Add(lvi);
}
txtTongTien.Text = cTHDB_BUS.TongTienHoaDon(txtMaHD.Text);
}
else
{
MessageBox.Show("Không Tìm Thấy !");
}
}
}
