public bool CapNhatKhachHang(KhachHang_Ent kh_ent)
{
KhachHang kh = db.KhachHangs.Where(n => n.id_khach.Equals(kh_ent.Id_khach)).SingleOrDefault();
if (kh == null)
{
return(false);
}
try
{
kh.ho = kh_ent.Ho;
kh.ten = kh_ent.Ten;
kh.date_of_birth = kh_ent.Date_of_birth;
kh.so_cmnd = kh_ent.So_cmnd;
kh.so_dien_thoai = kh_ent.Sodienthoai;
if (kh_ent.Gioi_tinh == "nam")
{
kh.gioi_tinh = 1;
}
if (kh_ent.Gioi_tinh == "nu")
{
kh.gioi_tinh = 0;
}
kh.quoc_tich = kh_ent.Quoc_tich;
db.SubmitChanges();
}
catch (Exception)
{
return(false);
}
return(true);
}
public KhachHang_Ent GetKhachHang_byCMND(string CMND)
{
KhachHang kh = db.KhachHangs.Where(n => n.so_cmnd.Equals(CMND)).SingleOrDefault();
KhachHang_Ent kh_ent;
if (kh == null)
{
return(null);
}
else
{
kh_ent = new KhachHang_Ent();
kh_ent.Id_khach = kh.id_khach;
kh_ent.Ho = kh.ho.Trim();
kh_ent.Ten = kh.ten.Trim();
kh_ent.Date_of_birth = kh.date_of_birth;
kh_ent.So_cmnd = kh.so_cmnd;
if (kh.gioi_tinh == 0)
{
kh_ent.Gioi_tinh = "Nữ";
}
if (kh.gioi_tinh == 1)
{
kh_ent.Gioi_tinh = "Nam";
}
kh_ent.Sodienthoai = kh.so_dien_thoai;
kh_ent.Quoc_tich = kh.quoc_tich;
}
return(kh_ent);
}
public List <KhachHang_Ent> GetKhachHangs()
{
List <KhachHang_Ent> kh_ents = new List <KhachHang_Ent>();
foreach (KhachHang kh in db.KhachHangs.Select(n => n))
{
KhachHang_Ent kh_ent = new KhachHang_Ent();
kh_ent.Id_khach = kh.id_khach;
kh_ent.Ho = kh.ho.Trim();
kh_ent.Ten = kh.ten.Trim();
kh_ent.Date_of_birth = kh.date_of_birth;
kh_ent.So_cmnd = kh.so_cmnd;
if (kh.gioi_tinh == 1)
{
kh_ent.Gioi_tinh = "Nam";
}
if (kh.gioi_tinh == 0)
{
kh_ent.Gioi_tinh = "Nữ";
}
kh_ent.Sodienthoai = kh.so_dien_thoai;
kh_ent.Quoc_tich = kh.quoc_tich;
kh_ents.Add(kh_ent);
}
return(kh_ents);
}
private void btnTimKiem_Click(object sender, EventArgs e)
{
KhachHang_WCFClient kh_wcf = new KhachHang_WCFClient();
KhachHang_Ent kh_ent = kh_wcf.GetKhachHang_byCMND(txtTimKiem.Text.Trim());
if (kh_ent == null)
{
MessageBox.Show("Kiểm Tra Lại !", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
txtHo.Text = kh_ent.Ho.Trim();
txtTen.Text = kh_ent.Ten.Trim();
txtSDT.Text = kh_ent.Sodienthoai.Trim();
txtCMND.Text = kh_ent.So_cmnd.Trim();
if (kh_ent.Gioi_tinh.Equals("Nam"))
{
cboGioiTinh.Text = "Nam";
}
else
{
cboGioiTinh.Text = "Nữ";
}
txtQuocTich.Text = kh_ent.Quoc_tich.Trim();
}
public List <KhachHang_Ent> TimKiem_KhachHang_by_CMND(string CMND)
{
List <KhachHang_Ent> kh_ents = new List <KhachHang_Ent>();
foreach (KhachHang kh in db.KhachHangs.Where(n => n.so_cmnd.Equals(CMND)))
{
KhachHang_Ent kh_ent = new KhachHang_Ent();
kh_ent.Id_khach = kh.id_khach;
kh_ent.Ho = kh.ho.Trim();
kh_ent.Ten = kh.ten.Trim();
kh_ent.Date_of_birth = kh.date_of_birth;
kh_ent.So_cmnd = kh.so_cmnd;
if (kh.gioi_tinh == 0)
{
kh_ent.Gioi_tinh = "Nữ";
}
if (kh.gioi_tinh == 1)
{
kh_ent.Gioi_tinh = "Nam";
}
kh_ent.Sodienthoai = kh.so_dien_thoai;
kh_ent.Quoc_tich = kh.quoc_tich;
kh_ents.Add(kh_ent);
}
return(kh_ents);
}
private void txtTimKiem_TextChanged(object sender, EventArgs e)
{
KhachHang_WCFClient kh_wcf = new KhachHang_WCFClient();
KhachHang_Ent kh_ent = kh_wcf.GetKhachHang_byCMND(txtTimKiem.Text.Trim());
if (kh_ent == null)
{
ClearTextBox();
return;
}
foreach (var item in kh_wcf.TimKiem_KhachHang_by_CMND(txtTimKiem.Text.Trim()))
{
maKH = item.Id_khach.ToString();
txtHo.Text = item.Ho;
txtTen.Text = item.Ten;
txtCMND.Text = item.So_cmnd;
txtQuocTich.Text = item.Quoc_tich;
if (item.Gioi_tinh.Equals("Nam"))
{
cboGioiTinh.Text = "Nam";
}
else
{
cboGioiTinh.Text = "Nữ";
}
txtSDT.Text = item.Sodienthoai;
dtpNgaySinh.Text = item.Date_of_birth.ToString();
}
}
public frmTextKhachHang(frmQLKhachHang fql, string title, KhachHang_Ent kh)
{
InitializeComponent();
Lb_TitleName = title;
this.Text = "Sửa Khách Hàng";
this.khach = kh;
KieuForm = 2;
this.Size = new Size(664, 389);
frmQLKH = fql;
}
private void Luu_Sua()
{
if (!CheckNull())
{
MessageBox.Show("Chưa Nhập Đủ Thông Tin", "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
else
{
KhachHang_WCFClient kh_wcf = new KhachHang_WCFClient();;
KhachHang_Ent kh = new KhachHang_Ent();
kh.Id_khach = khach.Id_khach;
kh.Ho = txtHo.Text.Trim();
kh.Ten = txtTen.Text.Trim();
kh.So_cmnd = txtCMND.Text.Trim();
kh.Sodienthoai = txtSoDT.Text.Trim();
kh.Quoc_tich = cbx_QuocTich.Text.Trim();
if (cbx_GioiTinh.SelectedIndex == 1)
{
kh.Gioi_tinh = "nam";
}
else
{
kh.Gioi_tinh = "nu";
}
kh.Date_of_birth = dtp_NgaySinh.Value;
if (kh_wcf.CapNhatKhachHang(kh))
{
DialogResult ds = MessageBox.Show("Lưu Thành Công, Tiếp Tục ?", "THÔNG BÁO", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (ds == DialogResult.Yes)
{
return;
}
else
{
this.Close();
}
}
else
{
DialogResult ds = MessageBox.Show("Lưu Thất Bại, Thử Lại ?", "LỖI", MessageBoxButtons.YesNo, MessageBoxIcon.Error);
if (ds == DialogResult.Yes)
{
return;
}
else
{
this.Close();
}
}
}
}
private void btnSuaKH_Click(object sender, EventArgs e)
{
if (dgv_DSKhachHang.SelectedRows.Count == 1)
{
KhachHang_WCFClient kh_wcf = new KhachHang_WCFClient();
KhachHang_Ent kh = kh_wcf.GetKhachHang_byCMND(dgv_DSKhachHang.SelectedRows[0].Cells[4].Value.ToString().Trim());
frmTextKhachHang frm = new frmTextKhachHang(this, "Sửa Khách Hàng", kh);
frm.ShowDialog();
}
else
{
MessageBox.Show("Chọn 1 Nhân Viên Cần Sửa", "", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
return;
}
}
public bool ThemKhachHang(KhachHang_Ent kh_ent)
{
KhachHang KhachHangCMND = db.KhachHangs.Where(n => n.so_cmnd.Equals(kh_ent.So_cmnd)).SingleOrDefault();
if (KhachHangCMND != null)
{
return(false);
}
try
{
KhachHang kh = new KhachHang();
kh.ho = kh_ent.Ho;
kh.ten = kh_ent.Ten;
kh.so_cmnd = kh_ent.So_cmnd;
kh.so_dien_thoai = kh_ent.Sodienthoai;
if (kh_ent.Gioi_tinh == "nam")
{
kh.gioi_tinh = 1;
}
if (kh_ent.Gioi_tinh == "nu")
{
kh.gioi_tinh = 0;
}
kh.quoc_tich = kh_ent.Quoc_tich;
kh.date_of_birth = kh_ent.Date_of_birth;
db.KhachHangs.InsertOnSubmit(kh);
db.SubmitChanges();
}
catch (Exception)
{
return(false);
}
return(true);
}
