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