public ActionResult Create(tbl_KhachHang khachHang)
{
bool result = false;
using (HutechMartDbContext db = new HutechMartDbContext())
{
using (var trans = db.Database.BeginTransaction())
{
try
{
khachHang.ngaytao = DatetimeLocation.GetDate();
khachHang.tinhtrang = true;
db.tbl_KhachHang.Add(khachHang);
db.SaveChanges();
trans.Commit();
result = true;
}
catch
{
trans.Rollback();
}
}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
//xu ly thanh toan
public ActionResult XLTT()
{
if (Session["KH"] == null)
{
return(RedirectToAction("DangNhap", "KhachHang"));
}
else
{
tbl_HoaDon hd = new tbl_HoaDon();
hd.NgayTao = DateTime.Now;
tbl_KhachHang kh = (tbl_KhachHang)Session["KH"];
hd.MaKH = kh.MaKhachHang;
mk.tbl_HoaDons.InsertOnSubmit(hd);
mk.SubmitChanges();
tbl_ChiTietHD ct;
List <GioHang> GH = LayGioHang();
foreach (var i in GH)
{
ct = new tbl_ChiTietHD();
ct.MaHD = hd.MaHoaDon;
ct.MaSP = i.Masp;
ct.SoLuong = i.SL;
mk.tbl_ChiTietHDs.InsertOnSubmit(ct);
mk.SubmitChanges();
}
}
return(RedirectToAction("Index", "Home"));
}
public ActionResult LuuDonHang(FormCollection c)
{
string ngaygiao = c["txtDate"];
GioHang gio = Session["gh"] as GioHang;
tbl_KhachHang khach = Session["kh"] as tbl_KhachHang;
tbl_HoaDon hd = new tbl_HoaDon();
hd.NgayHoaDon = DateTime.Now;
hd.MaKH = khach.MaKhachHang;
hd.NgayGiao = DateTime.Parse(ngaygiao);
data.tbl_HoaDons.InsertOnSubmit(hd);
data.SubmitChanges();
//Lưu nhiều dòng vào bảng chi tiết đơn hàng
foreach (CartItem item in gio.dsSP)
{
tbl_ChiTiet ct = new tbl_ChiTiet();
ct.MaHD = hd.MaHoaDon;
ct.MaSP = item.iMaSach;
ct.SoLuong = item.iSoluong;
data.tbl_ChiTiets.InsertOnSubmit(ct);
data.SubmitChanges();
}
Session["gh"] = null;
return(View());
}
// GET: HistoryDetail
public ActionResult HistoryDetail(string id)
{
if (Session["User"] == null)
{
Response.Redirect("/Login/Login");
}
bool isNumeric = true;
foreach (char c in id)
{
if (!Char.IsNumber(c))
{
isNumeric = false;
break;
}
}
if (isNumeric == false)
{
Response.Redirect("/History/History");
}
tbl_KhachHang kh = (tbl_KhachHang)Session["User"];
Code code = new Code();
List <tbl_ChiTietHoaDon> cthd = code.Get_ChiTietHoaDon(int.Parse(id));
return(View(cthd));
}
// GET: History
public ActionResult History()
{
if (Session["User"] == null)
{
Response.Redirect("/Login/Login");
}
tbl_KhachHang kh = (tbl_KhachHang)Session["User"];
Code code = new Code();
List <tbl_HoaDon> hd = code.Get_HoaDon(kh.MaKhachHang);
return(View(hd));
}
public ActionResult XacNhanDonHang()
{
tbl_KhachHang khach = Session["kh"] as tbl_KhachHang;
if (khach == null)
{
return(RedirectToAction("DangNhap", "Home"));
}
//Da Dang Nhap
ViewBag.k = khach;
GioHang gio = Session["gh"] as GioHang;
return(View(gio));
}
public JsonResult JSPageHistory(FormCollection data)
{
if (Session["User"] == null)
{
Response.Redirect("/Login/Login");
}
JsonResult js = new JsonResult();
int sotrang = int.Parse(data["sotrang"]);
tbl_KhachHang kh = (tbl_KhachHang)Session["User"];
Code code = new Code();
List <tbl_HoaDon> hd = code.Get_HoaDon(kh.MaKhachHang);
string context = "";
int dem = 0;
foreach (tbl_HoaDon item in hd)
{
dem++;
if (dem >= sotrang * 8 - 8 && dem <= sotrang * 8)
{
string sdt = "0" + item.SDT;
context += "<tr><th class='text-center' scope='col'>" + item.NguoiNhan + "</th><th class='text-center' scope='col'>" + item.DiaChiNhan + "</th>";
context += "<th class='text-center' scope='col'>" + sdt + "</th><th class='text-center' scope='col'>" + item.NgayLap + "</th>";
if (item.TrangThaiThanhToan == 1)
{
context += "<th class='text-center' scope='col'>Đã thanh toán</th>";
}
else
{
context += "<th class='text-center' scope='col'>Chưa thanh toán</th>";
}
if (item.MaTrangThaiDonHang == 1)
{
context += "<th class='text-center' scope='col'>Đã nhận hàng</th>";
}
else
{
context += "<th class='text-center' scope='col'>Đã đặt</th>";
}
context += "<th class='text-center' scope='col'>" + item.TongTien.ToString("#,##0").Replace(",", ".") + "VNĐ</th>";
context += "<th><a href='/HistoryDetail/HistoryDetail/" + item.MaHoaDon + "' class='btn btn-primary'>Xem chi tiết</a></th></tr>";
}
}
js.Data = new
{
context = context
};
return(Json(js, JsonRequestBehavior.AllowGet));
}
private void btnXoa_Click(object sender, EventArgs e)
{
if (dgvKH.SelectedRows.Count > 0)
{
if (XtraMessageBox.Show("Bạn có muốn xóa không ? ", "Thông Báo",
MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
string makh = txtMaKH.Text;
tbl_KhachHang kh = db.tbl_KhachHang.Find(makh);
db.tbl_KhachHang.Remove(kh);
db.SaveChanges();
HienThiDSKhachHang();
setNull();
}
}
else
{
XtraMessageBox.Show("Vui lòng chọn dòng cần xóa");
}
}
public ActionResult XL_DangKy(FormCollection col, tbl_KhachHang kh)
{
kh = mk.tbl_KhachHangs.FirstOrDefault(x => x.SoDienThoai == col["Txt_SDT"]);
if (kh == null)
{
kh = new tbl_KhachHang();
kh.TenKhachHang = col["Txt_Ten"];
kh.SoDienThoai = col["Txt_SDT"];
kh.DiaChi = col["Txt_DC"];
kh.MatKhau = col["Txt_MK"];
kh.GioiTinh = col["rad_GT"];
mk.tbl_KhachHangs.InsertOnSubmit(kh);
mk.SubmitChanges();
return(RedirectToAction("DN"));
}
else
{
return(RedirectToAction("DangKy", new { sdt = col["Txt_SDT"].ToString() }));
}
}
public ActionResult CustomerLogin(CustomerLoginViewModel model)
{
tbl_KhachHang UserLogin = new tbl_KhachHang();
if (Request.HttpMethod == "POST")
{
try
{
if (dB.tbl_KhachHang.Any(d => d.UserName == model.UserName))
{
if (model.Password == dB.tbl_KhachHang.Where(d => d.UserName == model.UserName).FirstOrDefault().Password)
{
if (model.RememberMe)
{
Response.Cookies["CustomerLogin"].Value = model.UserName;
}
UserLogin = dB.tbl_KhachHang.Where(d => d.UserName == model.UserName).FirstOrDefault();
Session["CustomerLogin"] = model.UserName;
CustomerLoginStatus.IsLogin = true;
CustomerLoginStatus.CustomerUser = model.UserName;
CustomerLoginStatus.CustomerUserId = UserLogin.Id;
CustomerLoginStatus.CustomerName = UserLogin.FullName;
return(RedirectToAction("Index", "Home"));
}
else
{
model.LoginError = "*Mật khẩu không chính xác";
}
}
else
{
model.LoginError = "*Tài khoản không chính xác";
}
}
catch
{
model.LoginError = "*Lỗi không xác định";
}
}
return(View(model));
}
public ActionResult DN(FormCollection col, tbl_KhachHang kh)
{
kh = mk.tbl_KhachHangs.FirstOrDefault(x => x.SoDienThoai == col["Txt_ID"] && x.MatKhau == col["Txt_MK"]);
if (kh == null)
{
if (mk.tbl_KhachHangs.FirstOrDefault(x => x.SoDienThoai == col["Txt_ID"]) == null)
{
ViewData["ID"] = "Sai tên số điện thoại";
}
if (mk.tbl_KhachHangs.FirstOrDefault(x => x.SoDienThoai == col["Txt_MK"]) == null)
{
ViewData["MK"] = "Sai mật khẩu";
}
return(View());
}
else
{
Session["KH"] = kh;
return(RedirectToAction("Index", "Home"));
}
}
public ActionResult Update(tbl_KhachHang khachHang)
{
bool result = false;
using (HutechMartDbContext db = new HutechMartDbContext())
{
using (var trans = db.Database.BeginTransaction())
{
try
{
var _khachHang = db.tbl_KhachHang.Find(khachHang.id);
_khachHang.id_phanloai = khachHang.id_phanloai;
_khachHang.tenkhachhang = khachHang.tenkhachhang;
_khachHang.gioitinh = khachHang.gioitinh;
_khachHang.ngaysinh = khachHang.ngaysinh;
_khachHang.sochungminh = khachHang.sochungminh;
_khachHang.sodienthoai = khachHang.sodienthoai;
_khachHang.diachi_tentinh = khachHang.diachi_tentinh;
_khachHang.diachi_tenquan = khachHang.diachi_tenquan;
_khachHang.diachi_tenphuong = khachHang.diachi_tenphuong;
_khachHang.diachi_sonha = khachHang.diachi_sonha;
_khachHang.email = khachHang.email;
_khachHang.facebook = khachHang.facebook;
_khachHang.ghichu = khachHang.ghichu;
_khachHang.id_nguoicapnhat = khachHang.id_nguoicapnhat;
_khachHang.ngaycapnhat = DatetimeLocation.GetDate();
db.SaveChanges();
trans.Commit();
result = true;
}
catch
{
trans.Rollback();
}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
protected void Page_Load(object sender, EventArgs e)
{
remenu.DataSource = NhomHangService.NhomHang_GetByTop("", " Active='True'", "");
remenu.DataBind();
tbl_KhachHang kh = new tbl_KhachHang();
GoogleConnect.ClientId = "520808312902-5al7h79mvjmk9jil2du85jenb6stla5q.apps.googleusercontent.com";
GoogleConnect.ClientSecret = "QF8LkNiAPNTvAvbJJvQqTR9E";
GoogleConnect.RedirectUri = Request.Url.AbsoluteUri.Split('?')[0];
if (!string.IsNullOrEmpty(Request.QueryString["code"]))
{
string code = Request.QueryString["code"];
string json = GoogleConnect.Fetch("me", code);
GoogleProfile profile = new JavaScriptSerializer().Deserialize <GoogleProfile>(json);
Session["TenDangNhap"] = profile.Id;
Session["display_name"] = profile.DisplayName;
Session["email"] = profile.Emails.Find(email => email.Type == "account").Value;
kh.TaiKhoan = profile.Id;
kh.Email = profile.Emails.Find(email => email.Type == "account").Value.ToString();
kh.tenKH = profile.DisplayName;
var a = from i in db.tbl_KhachHangs where i.TaiKhoan == profile.Id select i;
if (a.Count() <= 0)
{
db.tbl_KhachHangs.InsertOnSubmit(kh);
db.SubmitChanges();
}
Response.Redirect("TrangChu.aspx");
}
if (Request.QueryString["error"] == "access_denied")
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", "alert('Access denied.')", true);
}
}
public ActionResult CustomerRegister(CustomerRegisterViewModel model)
{
if (Request.HttpMethod == "POST")
{
if (!string.IsNullOrEmpty(model.Password) && !string.IsNullOrEmpty(model.ConfirmPassword) && (model.Password == model.ConfirmPassword))
{
if (!dB.tbl_KhachHang.Any(d => d.UserName == model.UserName))
{
tbl_KhachHang addKhachHang = new tbl_KhachHang();
addKhachHang.FullName = model.FullName;
addKhachHang.UserName = model.UserName;
addKhachHang.Password = model.Password;
addKhachHang.PhoneNumber = model.PhoneNumber;
addKhachHang.DiaChi = model.DiaChi;
dB.tbl_KhachHang.Add(addKhachHang);
dB.SaveChanges();
//redirect to Login
CustomerLoginViewModel login = new CustomerLoginViewModel();
login.UserName = model.UserName;
login.Password = model.Password;
return(RedirectToAction("CustomerLogin", "Account", login));
}
else
{
model.Error = "Tài khoản đã tồn tại";
}
}
else
{
return(View());
}
}
return(View(model));
}
//xem thong tin KH
public ActionResult TTKH(int ma)
{
tbl_KhachHang kh = mk.tbl_KhachHangs.FirstOrDefault(x => x.MaKhachHang == ma);
return(View(kh));
}
public JsonResult JSDangKi(FormCollection data)
{
if (data["rtk"] == null)
{
Response.Redirect("/Home/Index");
}
Code code = new Code();
string tk = data["rtk"];
string mk = data["rmk"];
string rmk = data["remk"];
string email = data["remail"];
string ten = data["rten"];
JsonResult js = new JsonResult();
if (String.IsNullOrEmpty(tk) || String.IsNullOrEmpty(mk) || String.IsNullOrEmpty(rmk) || String.IsNullOrEmpty(email))
{
js.Data = new
{
status = "ERR"
};
}
else
{
if (mk != rmk)
{
js.Data = new
{
status = "ERMK"
};
}
else
{
var RexPW = new Regex(@"^(?=.*\d)(?=.*[A-Z])(?=.*\W).{8,32}$");
var RexUID = new Regex(@"^[a-z_][a-z0-9_\.\s]{8,32}$");
var RexEmail = new Regex(@"^[a-z][a-z0-9_\.]{4,31}@[a-z0-9]{2,}(\.[a-z0-9]{2,4}){1,2}$");
if (!RexPW.IsMatch(mk))
{
js.Data = new
{
status = "ER"
};
}
else if (!RexUID.IsMatch(tk))
{
js.Data = new
{
status = "ER"
};
}
else if (!RexEmail.IsMatch(email))
{
js.Data = new
{
status = "ER"
};
}
else if (ten.Length < 2)
{
js.Data = new
{
status = "ER"
};
}
else
{
if (code.Get_KhachHang(tk) != null)
{
js.Data = new
{
status = "ERTK"
};
}
else
{
tbl_KhachHang kh = new tbl_KhachHang();
kh.TaiKhoan = tk;
kh.MatKhau = Encryptor.MD5Hash(mk);
kh.Email = email;
kh.Ten = ten;
code.AddObject(kh);
code.Save();
js.Data = new
{
status = "OK"
};
}
}
}
}
return(Json(js, JsonRequestBehavior.AllowGet));
}
private void btnLuu_Click(object sender, EventArgs e)
{
try
{
string makh = txtMaKH.Text;
string tenkh = txtTenKH.Text;
string gioitinh;
if (rdbNam.Checked == true)
{
gioitinh = "Nam";
}
else
{
gioitinh = "Nữ";
}
string diachi = txtDiaChi.Text;
string cmnd = txtCMND.Text;
string sdt = txtSDT.Text;
if (Flag == true)
{
if (db.tbl_KhachHang.SqlQuery("select * from tbl_KhachHang").Where(m => m.MaKhachHang.Contains(txtMaKH.Text)).Count() > 0)
{
XtraMessageBox.Show("Mã khách hàng nhập sai hoặc bị trùng", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
if (txtTenKH.Text == "" || txtDiaChi.Text == "" || txtCMND.Text == "" || txtSDT.Text == "")
{
XtraMessageBox.Show("Vui lòng nhập đầy đủ thông tin!");
}
else
{
tbl_KhachHang kh = new tbl_KhachHang();
kh.MaKhachHang = makh;
kh.HoTenKhach = tenkh;
kh.GioiTinh = gioitinh;
kh.DiaChi = diachi;
kh.CMND = cmnd;
kh.SDT = sdt;
db.tbl_KhachHang.Add(kh);
db.SaveChanges();
HienThiDSKhachHang();
XtraMessageBox.Show("Thêm khách hàng thành công!", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
setNull();
setButton(true);
setKhoa(true);
}
}
}
else
{
tbl_KhachHang kh = db.tbl_KhachHang.Where(m => m.MaKhachHang == makh).FirstOrDefault();
kh.HoTenKhach = tenkh;
kh.GioiTinh = gioitinh;
kh.DiaChi = diachi;
kh.CMND = cmnd;
kh.SDT = sdt;
if (kh == null)
{
XtraMessageBox.Show("Khách hàng không tồn tại!", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
db.Entry(kh).State = EntityState.Modified;
db.SaveChanges();
HienThiDSKhachHang();
XtraMessageBox.Show("Cập nhật thành công!", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
setNull();
setButton(true);
setKhoa(true);
}
}
}
catch { }
}
public JsonResult JSPayCheck(FormCollection form)
{
JsonResult js = new JsonResult();
bool isNumeric = true;
string finame = form["finame"];
string miname = form["miname"];
string laname = form["laname"];
string add1 = form["add1"];
string add2 = form["add2"];
string country = form["country"];
string state = form["state"];
string city = form["city"];
string phone = form["phone"];
if (string.IsNullOrEmpty(finame) || string.IsNullOrEmpty(laname) || string.IsNullOrEmpty(add1) || string.IsNullOrEmpty(country) || string.IsNullOrEmpty(state) || string.IsNullOrEmpty(city) || string.IsNullOrEmpty(phone))
{
js.Data = new
{
status = "EMPTY"
};
}
else
{
foreach (char c in phone)
{
if (!Char.IsNumber(c))
{
isNumeric = false;
break;
}
}
if (isNumeric == false)
{
js.Data = new
{
status = "ERRPHONE"
};
}
else
{
if (phone.Length != 10)
{
js.Data = new
{
status = "ERRPHONE"
};
}
else
{
string address = add1 + " " + add2 + " " + state + " " + city + " " + country;
string name = finame + " " + miname + " " + laname;
if (Session["Cart"] == null)
{
Response.Redirect("/Product/Product/1");
}
Code code = new Code();
List <CartItem> giohang = Session["Cart"] as List <CartItem>;
if (giohang.Count() == 0)
{
Response.Redirect("/Product/Product/1");
}
bool status = true;
foreach (CartItem item in giohang)
{
if (item.SoLuong > code.Get_ThietBi().FirstOrDefault(m => m.MaThietBi == item.SanPhamID).SoLuong)
{
status = false;
item.SoLuong = code.Get_ThietBi().FirstOrDefault(m => m.MaThietBi == item.SanPhamID).SoLuong;
}
}
if (status == true)
{
if (Session["User"] == null)
{
Response.Redirect("/Login/Login");
}
else
{
tbl_KhachHang u = (tbl_KhachHang)Session["User"];
tbl_HoaDon hd = new tbl_HoaDon();
hd.MaKhachHang = u.MaKhachHang;
hd.NgayLap = DateTime.Now.Day + "/" + DateTime.Now.Month + "/" + DateTime.Now.Year;
hd.MaTrangThaiDonHang = 2;
hd.DiaChiNhan = address;
hd.NguoiNhan = name;
hd.SDT = int.Parse(phone);
hd.TongTien = giohang.Sum(m => m.ThanhTien);
hd.TrangThaiThanhToan = 2;
code.AddObject(hd);
foreach (CartItem item in giohang)
{
tbl_ChiTietHoaDon cthd = new tbl_ChiTietHoaDon();
cthd.MaHoaDon = hd.MaHoaDon;
cthd.MaThietBi = item.SanPhamID;
cthd.SoLuong = item.SoLuong;
cthd.ThanhTien = item.ThanhTien;
cthd.DonGia = item.DonGia;
code.AddObject(cthd);
code.Save();
tbl_ThietBi tb = code.Get_ThietBi().FirstOrDefault(m => m.MaThietBi == item.SanPhamID);
tb.SoLuong = tb.SoLuong - item.SoLuong;
code.Save();
}
code.Save();
Session.Remove("Cart");
js.Data = new
{
status = "OK"
};
}
}
else
{
js.Data = new
{
status = "ER"
};
}
}
}
}
return(Json(js, JsonRequestBehavior.AllowGet));
}
