private void btn_Add_Click(object sender, EventArgs e)
{
try
{
string tenkh = txt_TenKH.Text;
string nnghiep = txt_NN.Text;
string cvu = txt_CV.Text;
string dchi = txt_DC.Text;
Kh add = new Kh();
add.TenKh = tenkh;
add.NgheNghiep = nnghiep;
add.ChucVu = cvu;
add.DiaChi = dchi;
add.Email = tbxEmail.Text;
db.Khs.InsertOnSubmit(add);
db.SubmitChanges();
KhachHang_Load(sender, e);
Clear();
}
catch
{
MessageBox.Show("Dữ liệu không hợp lệ hoặc đã tồn tại!");
}
}
private void btn_Edit_Click(object sender, EventArgs e)
{
try
{
int makh = Convert.ToInt32(dtgv_KH.SelectedCells[0].OwningRow.Cells["ID"].Value.ToString());
string tenkh = txt_TenKH.Text;
string nnghiep = txt_NN.Text;
string cvu = txt_CV.Text;
string dchi = txt_DC.Text;
Kh edit = db.Khs.Where(p => p.MaKh.Equals(makh)).SingleOrDefault();
if (tenkh != "" && nnghiep != "" && cvu != "" && dchi != "" && tbxEmail.Text != "")
{
edit.TenKh = tenkh;
edit.NgheNghiep = nnghiep;
edit.ChucVu = cvu;
edit.DiaChi = dchi;
edit.Email = tbxEmail.Text;
db.SubmitChanges();
KhachHang_Load(sender, e);
Clear();
}
}
catch
{
MessageBox.Show("Kiểm tra lại thông tin vừa nhập!");
}
}
private void btn_Del_Click(object sender, EventArgs e)
{
Kh kh = new Kh();
int makh = Convert.ToInt32(dtgv_KH.SelectedCells[0].OwningRow.Cells["ID"].Value.ToString());
kh = db.Khs.Where(p => p.MaKh.Equals(makh)).SingleOrDefault();
db.Khs.DeleteOnSubmit(kh);
db.SubmitChanges();
KhachHang_Load(sender, e);
}
private void ThemDangKy()
{
using (var md5Hash = MD5.Create())
{
var kh = new Kh
{
Email = Request.Form["email"].Replace(",", ""),
MatKhau = SecurityHelper.GetMd5Hash(md5Hash, Request.Form["password"].Replace(",", "")),
TenKh = Request.Form["f_Name"].Replace(",", "")
};
KhBus.Insert(kh);
Response.Redirect("/GioHang", false);
}
}
public static void Update(Kh obj)
{
Kh.Update(obj);
}
public static Kh Insert(Kh obj)
{
return(Kh.Insert(obj));
}
public static void Delete(Kh obj)
{
Kh.Delete(obj);
}
