public ActionResult DangNhap(LoginModel model)
{
if (ModelState.IsValid)
{
string strUserName = model.UserName.Trim();
string strPass = Encryptor.MD5Hash(model.Password);
quanchiEntities ctx = new quanchiEntities();
var kh = ctx.QC_KhachHang.Where(x => x.tendangnhap == strUserName && x.matkhau == strPass).FirstOrDefault();
if (kh == null)
{
ModelState.AddModelError("", "Tên đăng nhập hoặc mật khẩu không đúng!");
}
else
{
if (kh.kichhoat == false)
{
ModelState.AddModelError("", "Tài khoản chưa được kích hoạt. Vui lòng kiểm tra email đăng ký của bạn.");
}
else
{
FormsAuthentication.SetAuthCookie(model.UserName.Trim(), false);
Session["tenkhachhang"] = kh.tendaydu;
string url = ConfigurationManager.AppSettings["SiteUrl"];
return(Redirect(url));
}
}
}
return(View(model));
}
public ActionResult HiUser()
{
quanchiEntities ctx = new quanchiEntities();
string username = HttpContext.User.Identity.Name;
var user = ctx.QC_KhachHang.Where(x => x.tendangnhap == username).FirstOrDefault();
if (user != null)
{
return View(user);
}
return View();
}
public PartialViewResult Footer()
{
try
{
quanchiEntities ctx = new quanchiEntities();
var lh = ctx.CSF_ThietLapWebsite.FirstOrDefault();
return PartialView(lh);
}
catch (Exception ex)
{
Logs.WriteLog(ex);
return PartialView();
}
}
public ActionResult DoiMatKhau(string ma, string email)
{
ma = ma.ToLower().Trim();
email = email.ToLower().Trim();
quanchiEntities ctx = new quanchiEntities();
var kh = ctx.QC_KhachHang.Where(x => x.makichhoat == ma && x.email == email).FirstOrDefault();
if (kh == null)
{
string url = ConfigurationManager.AppSettings["SiteUrl"];
return(Redirect(url));
}
else
{
return(View(kh));
}
}
protected void Application_Start()
{
quanchiEntities ctx = new quanchiEntities();
var lh = ctx.CSF_ThietLapWebsite.FirstOrDefault();
Application["tenwebsite"] = lh.tenwebsite;
Application["slogan"] = lh.slogan;
Application["hotline"] = lh.hotline;
Application["hotline_dichvu"] = lh.hotline_dichvu;
Application["hotline_hotro"] = lh.hotline_hotro;
Application["logo"] = lh.logo;
Application["facebook"] = lh.facebook;
Application["email"] = lh.email;
AreaRegistration.RegisterAllAreas();
WebApiConfig.Register(GlobalConfiguration.Configuration);
FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
RouteConfig.RegisterRoutes(RouteTable.Routes);
}
public ActionResult KichHoat(int id, string ma)
{
string message = "";
string cl = "";
quanchiEntities ctx = new quanchiEntities();
var kh = ctx.QC_KhachHang.Where(x => x.id == id && x.makichhoat == ma.Trim()).FirstOrDefault();
if (kh == null)
{
message = "Tài khoản không tồn tại. Vui lòng đăng ký tài khoản mới !";
cl = "error";
}
else
{
if (kh.kichhoat == false)
{
kh.kichhoat = true;
ctx.Entry(kh).State = EntityState.Modified;
int nhom_thanhvienmoi = Convert.ToInt32(ConfigurationManager.AppSettings["NhomThanhVienMoi"].ToString());
QC_KhachHang_Nhom obj = new QC_KhachHang_Nhom();
obj.idkhachhang = id;
obj.idnhom = nhom_thanhvienmoi;
ctx.QC_KhachHang_Nhom.Add(obj);
ctx.SaveChanges();
message = "Tài khoản đã được kích hoạt thành công. Hãy đăng nhập trải nghiệm website của chúng tôi. Xin chân thành cảm ơn!";
cl = "success";
}
else
{
string url = ConfigurationManager.AppSettings["SiteUrl"];
return(Redirect(url));
}
}
ViewBag.MESS = message;
ViewBag.CLASS = cl;
return(View());
}
public ActionResult Index()
{
quanchiEntities ctx = new quanchiEntities();
int nam = DateTime.Now.Year;
int thang = DateTime.Now.Month;
ViewBag.NAM = nam;
ViewBag.THANG = thang;
////
List <decimal> money = new List <decimal>();
decimal tienthang = 0;
var data = ctx.QC_DonHang.Where(x => x.trangthai == true && x.ngaydathang.Year == nam).ToList();
for (int i = 1; i <= 12; i++)
{
tienthang = (decimal)data.Where(x => x.ngaydathang.Month == i).Sum(x => x.thanhtiensaugiam);
money.Add(tienthang);
}
ViewBag.TIENTHEOTHANG = string.Join(",", money.ToArray());
////
var data_lsp = ctx.QC_LoaiThuoc.ToList();
List <string> tenloai = new List <string>();
List <int> soluongsp = new List <int>();
foreach (var item in data_lsp)
{
tenloai.Add(item.ten);
soluongsp.Add(item.QC_Thuoc.Count());
}
ViewBag.TENLOAI = string.Join(",", tenloai.ToArray());
ViewBag.SOLUONGSP = string.Join(",", soluongsp.ToArray());
////
List <string> tensp = new List <string>();
List <int> soluongban = new List <int>();
List <SANPHAMBAN> lsp = new List <SANPHAMBAN>();
var sp = ctx.QC_Thuoc.ToList();
var sp_dh = ctx.QC_Thuoc_DonHang.Where(x => x.QC_DonHang.ngaydathang.Year == nam &&
x.QC_DonHang.trangthai == true);
foreach (var item in sp)
{
var temp = sp_dh.Where(x => x.idthuoc == item.id).ToList();
if (temp != null && temp.Count() > 0)
{
SANPHAMBAN o = new SANPHAMBAN();
o.soluong = (int)temp.Sum(x => x.soluong);
o.ten = item.ten;
lsp.Add(o);
}
}
lsp = lsp.OrderBy(x => x.soluong).ToList();
ViewBag.TENSP = string.Join(",", lsp.Select(x => x.ten));
ViewBag.SOLUONGBAN = string.Join(",", lsp.Select(x => x.soluong));
//thong ke theo khach hang
List <KHACHHANGMUA> lkh = new List <KHACHHANGMUA>();
var datakh = ctx.QC_DonHang.Where(x => x.trangthai == true).GroupBy(x => x.idkhachhang).ToList();
var khs = ctx.QC_KhachHang.Where(x => x.kichhoat == true).ToList();
foreach (var item in datakh)
{
KHACHHANGMUA obj = new KHACHHANGMUA();
var kh = khs.FirstOrDefault(x => x.id == item.Key);
obj.ten = kh.tendaydu + " (" + kh.tendangnhap + ")";
obj.tien = (decimal)data.Where(x => x.idkhachhang == item.Key).Sum(x => x.thanhtiensaugiam);
lkh.Add(obj);
}
lkh = lkh.OrderByDescending(x => x.tien).ToList();
ViewBag.TENKH = string.Join(",", lkh.Select(x => x.ten));
ViewBag.TIENMUA = string.Join(",", lkh.Select(x => x.tien));
//thong tin chung
ViewBag.SODONHANG = ctx.QC_DonHang.Where(x => x.trangthai == true).Count();
ViewBag.DHCHUAXULY = ctx.QC_DonHang.Where(x => x.trangthai == false).Count();
ViewBag.SOTHANHVIEN = ctx.QC_KhachHang.Where(x => x.kichhoat == true).Count();
ViewBag.SODONHANGTHANG = ctx.QC_DonHang.Where(x => x.trangthai == true && x.ngaydathang.Year == nam && x.ngaydathang.Month == thang).Count();
return(View());
}
