protected void btnThem_Click(object sender, EventArgs e) { data = new dtKhachHang(); DataTable db = data.DanhSachKhachHang_Import_Temp(); if (db.Rows.Count != 0) { foreach (DataRow dr in db.Rows) { string IDNhomKhachHang = dr["IDNhomKhachHang"].ToString(); string MaKhachHang = dr["MaKhachHang"].ToString(); string TenKhachHang = dr["TenKhachHang"].ToString(); string NgaySinh = dr["NgaySinh"].ToString(); string DiaChi = dr["DiaChi"].ToString(); string CMND = dr["CMND"].ToString(); string DienThoai = dr["DienThoai"].ToString(); string DiemTichLuy = dr["DiemTichLuy"].ToString(); string GhiChu = dr["GhiChu"].ToString(); if (data.KiemTraSDTKhachHang(DienThoai) == 0) { data.ThemKhachHang(Int32.Parse(IDNhomKhachHang), MaKhachHang, TenKhachHang, DateTime.Parse(NgaySinh), CMND, DiaChi, DienThoai, GhiChu); LoadGrid(); } } Response.Redirect("KhachHang.aspx"); } else { Response.Write("<script language='JavaScript'> alert('Dữ liệu trống? Vui lòng kiểm tra lại.'); </script>"); } }
protected void btnThemKhachHang_Click(object sender, EventArgs e) { if (cmbNhomKhachHang.Text != "" && txtTenKhachHang.Text != "" && cmbChietKhau.Text != "") { int IDNhom = Int32.Parse(cmbNhomKhachHang.Value.ToString()); string TenKH = txtTenKhachHang.Text; string SDT = txtSoDienThoai.Text == null ? "" : txtSoDienThoai.Text; string DC = txtDiaChi.Text == null ? "" : txtDiaChi.Text; string IDChietKhau = cmbChietKhau.Value.ToString(); dtKhachHang dtkh = new dtKhachHang(); string MaKh = ""; string Barcode = ""; object ID = dtkh.ThemKhachHang(IDNhom, MaKh, TenKH, DateTime.Now, "", DC, SDT, "", Barcode, "", Session["IDKho"].ToString(), IDChietKhau); if (ID != null) { dtkh = new dtKhachHang(); dtkh.CapNhatMaKhachHang(ID, (Session["IDKho"].ToString() + "." + ID).ToString(), (Session["IDKho"].ToString() + "." + ID).Replace(".", "")); } DanhSachKhachHang(); txtTenKhachHang.Text = ""; cmbNhomKhachHang.Text = ""; txtSoDienThoai.Text = ""; txtDiaChi.Text = ""; cmbChietKhau.Text = ""; HienThiThongBao("Thêm khách hàng thành công !!"); popupThemKhachHang.ShowOnPageLoad = false; return; } else { HienThiThongBao("Vui lòng nhập thông tin đầy đủ (*) !!"); return; } }
protected void gridKhachHang_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { data = new dtKhachHang(); int IDNhomKhachHang = Int32.Parse(e.NewValues["IDNhomKhachHang"].ToString()); string TenKhachHang = e.NewValues["TenKhachHang"].ToString(); DateTime NgaySinh = DateTime.Parse(e.NewValues["NgaySinh"] == null ? DateTime.Today.ToString() : e.NewValues["NgaySinh"].ToString()); string CMND = e.NewValues["CMND"] == null ? "" : e.NewValues["CMND"].ToString(); string DiaChi = e.NewValues["DiaChi"] == null ? "" : e.NewValues["DiaChi"].ToString(); string DienThoai = e.NewValues["DienThoai"] == null ? "" : e.NewValues["DienThoai"].ToString(); string Email = e.NewValues["Email"] == null ? "" : e.NewValues["Email"].ToString(); string MaKh = ""; string Barcode = ""; object ID; string IDChietKhau = "2"; string GhiChu = e.NewValues["GhiChu"] == null ? "" : e.NewValues["GhiChu"].ToString(); if (DienThoai != "") { if (dtKhachHang.KT_SDT_KH(DienThoai.Trim()) != -1) { throw new Exception("Lỗi: Số điện thoại đã tồn tại?"); } else { ID = data.ThemKhachHang(IDNhomKhachHang, MaKh, TenKhachHang, NgaySinh, CMND, DiaChi, DienThoai, Email, Barcode, GhiChu, Session["IDKho"].ToString(), IDChietKhau); if (ID != null) { if (e.NewValues["MaKhachHang"] == null) { data = new dtKhachHang(); data.CapNhatMaKhachHang(ID, (dtSetting.LayMaKho(Session["IDKho"].ToString()) + "." + (Int32.Parse(ID.ToString()) * 0.0001).ToString().Replace(".", "")).ToString(), (Session["IDKho"].ToString() + "." + (Int32.Parse(ID.ToString()) * 0.0001)).Replace(".", "")); dtLichSuTruyCap.ThemLichSu(Session["IDNhanVien"].ToString(), Session["IDNhom"].ToString(), "Khách hàng:" + TenKhachHang, Session["IDKho"].ToString(), "Danh Mục", "Thêm"); } } } } else { ID = data.ThemKhachHang(IDNhomKhachHang, MaKh, TenKhachHang, NgaySinh, CMND, DiaChi, DienThoai, Email, Barcode, GhiChu, Session["IDKho"].ToString(), IDChietKhau); if (ID != null) { if (e.NewValues["MaKhachHang"] == null) { data = new dtKhachHang(); data.CapNhatMaKhachHang(ID, (Session["IDKho"].ToString() + "." + (Int32.Parse(ID.ToString()) * 0.0001).ToString().Replace(".", "")).ToString(), (Session["IDKho"].ToString() + "." + (Int32.Parse(ID.ToString()) * 0.0001)).Replace(".", "")); dtLichSuTruyCap.ThemLichSu(Session["IDNhanVien"].ToString(), Session["IDNhom"].ToString(), "Khách hàng:" + TenKhachHang, Session["IDKho"].ToString(), "Danh Mục", "Thêm"); } } } e.Cancel = true; gridKhachHang.CancelEdit(); LoadGrid(); }
protected void gridKhachHang_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { data = new dtKhachHang(); int IDNhomKhachHang = Int32.Parse(e.NewValues["IDNhomKhachHang"].ToString()); string TenKhachHang = e.NewValues["TenKhachHang"] == null ? "" : e.NewValues["TenKhachHang"].ToString(); DateTime NgaySinh = DateTime.Parse(e.NewValues["NgaySinh"] == null ? "" : e.NewValues["NgaySinh"].ToString()); string CMND = e.NewValues["CMND"] == null ? "" : e.NewValues["CMND"].ToString(); string DiaChi = e.NewValues["DiaChi"] == null ? "" : e.NewValues["DiaChi"].ToString(); string DienThoai = e.NewValues["DienThoai"] == null ? "" : e.NewValues["DienThoai"].ToString(); DateTime date = DateTime.Now; string sDate = date.ToString("MMddyyyy"); int MaKh = 0; Random dr = new Random(); while (MaKh == 0) { int sR = dr.Next(10000, 99999); int kt = data.KiemTraMaKhachHang(sDate + sR); if (kt == 0) { MaKh = sR; } } string GhiChu = e.NewValues["GhiChu"] == null ? "" : e.NewValues["GhiChu"].ToString(); if (data.KiemTraSDTKhachHang(DienThoai) == 0) { data.ThemKhachHang(IDNhomKhachHang, sDate + MaKh, TenKhachHang, NgaySinh, CMND, DiaChi, DienThoai, GhiChu); e.Cancel = true; KhachHangExport.CancelEdit(); LoadGrid(); } else { throw new Exception("Số điện thoại này đã được đăng ký."); } }