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 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ý."); } }