public bool getDangkinhantin(string mail)
{
using (var db = new CoffeeHouseDbContext())
{
dknt dk = new dknt();
dk.email = mail;
dk.ngaydk = DateTime.Today;
db.dknts.Add(dk);
db.SaveChanges();
//try
//{
// db.dknts.Add(dk);
// db.SaveChanges();
//}
//catch (DbEntityValidationException dbEx)
//{
// foreach (var validationErrors in dbEx.EntityValidationErrors)
// {
// foreach (var validationError in validationErrors.ValidationErrors)
// {
// System.Console.WriteLine("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage);
// }
// }
//}
return(true);
}
}
public void ThayDoiInfo(infoClientModel info, int makh)
{
using (var ctx = new CoffeeHouseDbContext())
{
khachhang kh = ctx.khachhangs.FirstOrDefault(x => x.makh == makh);
if (kh != null)
{
kh.sodt = info.sodt;
kh.diachi = info.diachi;
ctx.SaveChanges();
}
user u = ctx.users.FirstOrDefault(x => x.id == kh.matk);
if (u != null)
{
u.tentk = info.tenTk;
ctx.SaveChanges();
}
}
// khachhang kh = context.khachhangs.FirstOrDefault(x => x.makh == makh);
//if (kh != null)
//{
// kh.sodt = info.sodt;
// kh.diachi = info.diachi;
// context.SaveChanges();
//}
//user u = context.users.FirstOrDefault(x => x.id == kh.matk);
//if (u != null)
//{
// u.tentk = info.tenTk;
// context.SaveChanges();
//}
}
public List <sanpham> timKiem(string str)
{
using (var ctx = new CoffeeHouseDbContext())
{
return(ctx.sanphams.Where(s => s.tensp.Contains(str) == true).ToList());
}
}
public ActionResult Index(ChangePassModel model)
{
if (ModelState.IsValid)
{
if (new ChangePasswordDao().DoiMatKhau(model))
{
using (var query = new CoffeeHouseDbContext())
{
user u = query.users.FirstOrDefault(x => x.email == model.email);
ViewData["id"] = u.id;
}
ViewBag.annoucement = "Đổi mật khẩu thành công";
model = new ChangePassModel();
}
else
{
ViewBag.announcement = "Đổi mật khẩu không thành công";
ModelState.AddModelError("", "Đổi mật khẩu không thành công");
//ChangePassModel change = new ChangePassModel();
return(View());
//return Json(ViewData["id"]);
}
}
//else
//{
// return ModelState.Values.SelectMany(v => v.Errors);
//}
//return ModelState.IsValid;
return(View());
}
public string getTenLoai(int maLoaiSP)
{
using (var ctx = new CoffeeHouseDbContext())
{
return(ctx.loaisanphams.FirstOrDefault(x => x.maloaisp == maLoaiSP).tenloaisp);
}
}
public List <sanpham> getTuongTu(int maLoaiSP)
{
using (var ctx = new CoffeeHouseDbContext())
{
return(ctx.sanphams.Where(x => x.maloaisp == maLoaiSP).Take(6).ToList());
}
//return context.sanphams.Where(x => x.maloaisp == maLoaiSP).ToList();
}
public static List <sanpham> getSPKM()
{
using (var ctx = new CoffeeHouseDbContext())
{
var query = ctx.sanphams.Where(x => x.giakm != 0).ToList();
return(query);
}
//var query = context.sanphams.Where(x => x.giakm != 0).ToList();
}
public int getMaloaisanpham(int masp)
{
using (var ctx = new CoffeeHouseDbContext())
{
sanpham sp = ctx.sanphams.Where(x => x.masp == masp).FirstOrDefault();
return((int)sp.maloaisp);
}
// sanpham sp = context.sanphams.Where(x => x.masp == masp).FirstOrDefault();
//return (int)sp.maloaisp;
}
public static List <slide> getSlide()
{
using (var ctx = new CoffeeHouseDbContext())
{
var query = ctx.slides.ToList();
return(query);
}
//var query = context.slides.ToList();
//return query;
}
//private CoffeeHouseDbContext context = new CoffeeHouseDbContext();
public sanpham getDetail(int id)
{
using (var ctx = new CoffeeHouseDbContext())
{
sanpham sp = (sanpham)ctx.sanphams.FirstOrDefault(x => x.masp == id);
return(sp);
}
// sanpham sp = (sanpham)context.sanphams.FirstOrDefault(x => x.masp == id);
//return sp;
}
//private static CoffeeHouseDbContext context = new CoffeeHouseDbContext();
public static List <sanpham> getSPMoi()
{
using (var ctx = new CoffeeHouseDbContext())
{
var query = ctx.sanphams.OrderBy(x => x.ngaynhap).ToList();
return(query);
}
//var query = context.sanphams.OrderBy(x => x.ngaynhap).ToList();
//return query;
}
public int postDoimatkhau(string email, string matkhau)
{
using (var db = new CoffeeHouseDbContext())
{
user us = db.users.Where(x => x.email == email).FirstOrDefault();
us.password = matkhau;
db.users.AddOrUpdate(us);
return(db.SaveChanges());
}
}
//private CoffeeHouseDbContext context = new CoffeeHouseDbContext();
public bool DoiMatKhau(ChangePassModel model)
{
using (var ctx = new CoffeeHouseDbContext())
{
string matkhau = Encrypt.MD5Hash(model.reNewPass);
var query = (from u in ctx.users
join kh in ctx.khachhangs
on u.id equals kh.matk
where u.email == model.email && u.password == matkhau
select new
{
idUser = u.id,
idKH = kh.makh,
tenKH = kh.hoten,
email = kh.email
}).FirstOrDefault();
if (query is null)
{
user u = ctx.users.FirstOrDefault(x => x.email == model.email);
u.password = matkhau;
ctx.users.AddOrUpdate(u);
ctx.SaveChanges();
return(true);
}
else
{
return(false);
}
}
// string matkhau = Encrypt.MD5Hash(model.reNewPass);
//var query = (from u in context.users
// join kh in context.khachhangs
// on u.id equals kh.matk
// where u.email == model.email && u.password == matkhau
// select new
// {
// idUser = u.id,
// idKH = kh.makh,
// tenKH = kh.hoten,
// email = kh.email
// }).FirstOrDefault();
//if (query != null)
//{
// user u = context.users.FirstOrDefault(x => x.email == model.email);
// u.password = matkhau;
// context.users.AddOrUpdate(u);
// context.SaveChanges();
// return true;
//}
//else
//{
// return false;
//}
}
public static List <LoginUnit> ClientLogin(string email, string password)
{
using (var ctx = new CoffeeHouseDbContext())
{
var f_password = Encrypt.MD5Hash(password);
var query = (from u in ctx.users
join kh in ctx.khachhangs
on u.id equals kh.matk
where u.email == email && u.password == f_password
select new
{
idUser = u.id,
idKH = kh.makh,
tenKH = kh.hoten,
email = kh.email
}).FirstOrDefault();
LoginUnit loginUnit = new LoginUnit();
if (query != null)
{
loginUnit.idUser = (int)query.idUser;
loginUnit.idKH = (int)query.idKH;
loginUnit.tenKH = query.tenKH;
loginUnit.email = query.email;
}
List <LoginUnit> li = new List <LoginUnit>();
li.Add(loginUnit);
return(li);
}
// var f_password = Encrypt.MD5Hash(password);
//var query = (from u in context.users
// join kh in context.khachhangs
// on u.id equals kh.matk
// where u.email == email && u.password == f_password
// select new
// {
// idUser = u.id,
// idKH = kh.makh,
// tenKH = kh.hoten,
// email = kh.email
// }).FirstOrDefault();
//LoginUnit loginUnit = new LoginUnit();
//if (query != null)
//{
// loginUnit.idUser = (int)query.idUser;
// loginUnit.idKH = (int)query.idKH;
// loginUnit.tenKH = query.tenKH;
// loginUnit.email = query.email;
//}
//List<LoginUnit> li = new List<LoginUnit>();
//li.Add(loginUnit);
//return li;
}
//private CoffeeHouseDbContext context = new CoffeeHouseDbContext();
public bool DangKi(user ur, khachhang kh)
{
using (var ctx = new CoffeeHouseDbContext())
{
var check = ctx.users.Count(x => x.email == ur.email);
if (check == 0)
{
//ur.password = Encrypt.MD5Hash(ur.password);
//context.users.Add(ur);
//context.SaveChanges();
//user u = context.users.FirstOrDefault(s => s.id == ur.id);
//kh.user = u;
//context.khachhangs.Add(kh);
//context.SaveChanges();
ur.password = Encrypt.MD5Hash(ur.password);
ctx.users.Add(ur);
ctx.SaveChanges();
kh.matk = ctx.users.Where(u => u.email == ur.email).Select(u => u.id).First();
ctx.khachhangs.Add(kh);
ctx.SaveChanges();
return(true);
}
else
{
return(false);
}
}
// var check = context.users.Count(x => x.email == ur.email);
//if (check == 0)
//{
// //ur.password = Encrypt.MD5Hash(ur.password);
// //context.users.Add(ur);
// //context.SaveChanges();
// //user u = context.users.FirstOrDefault(s => s.id == ur.id);
// //kh.user = u;
// //context.khachhangs.Add(kh);
// //context.SaveChanges();
// ur.password = Encrypt.MD5Hash(ur.password);
// context.users.Add(ur);
// context.SaveChanges();
// kh.matk = context.users.Where(u => u.email == ur.email).Select(u => u.id).First();
// context.khachhangs.Add(kh);
// context.SaveChanges();
// return true;
//}
//else
// return false;
}
public static List <cartModel> Them1SPVaoCart(int idSP, List <cartModel> li)
{
using (var ctx = new CoffeeHouseDbContext())
{
var query = ctx.sanphams.Where(x => x.masp == idSP).FirstOrDefault();
if (li.FirstOrDefault(x => x.maSP == idSP) != null)
{
cartModel item = li.FirstOrDefault(x => x.maSP == idSP);
int index = li.IndexOf(item);
item.soLuong++;
cartModel.tongTien += item.donGia;
if (index != -1)
{
li[index] = item;
}
return(li);
}
else
{
cartModel cart = new cartModel();
cart.maSP = (int)query.masp;
cart.tenSP = query.tensp;
cart.Hinh = query.hinhanh;
cart.donGiaKM = (int)query.giakm;
cart.donGiaGoc = (int)query.gia;
if (query.giakm != 0)
{
cart.donGia = (int)query.giakm;
}
else
{
cart.donGia = (int)query.gia;
}
cart.soLuong = 1;
cartModel.tongTien += cart.donGia;
cartModel.tongSoHang += 1;
li.Add(cart);
return(li);
}
}
//var query = new CoffeeHouseDbContext().sanphams.Where(x => x.masp == idSP).FirstOrDefault();
}
public List <ItemUnit> getCtdhKhachHang(int id)
{
List <ItemUnit> li = new List <ItemUnit>();
using (var ctx = new CoffeeHouseDbContext())
{
var query = (from dh in ctx.donhangs
join ct in ctx.ctdhs
on dh.madh equals ct.madh
join sp in ctx.sanphams
on ct.masp equals sp.masp
where dh.makh == id
orderby dh.ngaydat descending
select new {
makh = dh.makh,
madh = dh.madh,
tensp = sp.tensp,
hinhsp = sp.hinhanh,
ngaydat = dh.ngaydat,
tonggia = ct.gia * ct.soluong,
soluong = ct.soluong,
masp = ct.masp,
gia = ct.gia
}).ToList();
foreach (var i in query)
{
ItemUnit item = new ItemUnit();
item.soluong = i.soluong;
item.tensp = i.tensp;
item.tonggia = i.tonggia;
item.hinhsp = i.hinhsp;
item.madh = (int)i.madh;
item.masp = (int)i.masp;
item.gia = i.gia;
item.makh = (int)i.makh;
item.ngaydat = (DateTime)i.ngaydat;
li.Add(item);
}
return(li);
}
}
public bool Thanhtoandonhang(int madh)
{
DateTime date = DateTime.Now.Date;
date.ToString("yyyy-MM-dd");
var ctdh = db.ctdhs.Where(x => x.madh == madh);
int mahd;
Model.EF.donhang dh;
using (var context = new CoffeeHouseDbContext())
{
dh = context.donhangs.Where(x => x.madh == madh).FirstOrDefault();
hoadon hd = new hoadon();
hd.makh = (long)dh.makh;
hd.ngaythanhtoan = date;
hd.tongtien = dh.tongtien;
hd.httt = dh.httt;
context.hoadons.Add(hd);
context.SaveChanges();
mahd = (int)hd.mahd;
}
foreach (var ct in ctdh)
{
cthd cthd = new cthd();
cthd.mahd = mahd;
cthd.masp = ct.masp;
cthd.soluong = ct.soluong;
cthd.gia = ct.gia;
db.cthds.Add(cthd);
}
dh.tttt = 1;
db.donhangs.AddOrUpdate(dh);
db.SaveChanges();
return(true);
}
public static List <cartModel> ThemNSPVaoCart(int id, List <cartModel> li, int sl)
{
var query = new CoffeeHouseDbContext().sanphams.Where(x => x.masp == id).FirstOrDefault();
if (li.FirstOrDefault(x => x.maSP == id) != null)
{
cartModel item = li.FirstOrDefault(x => x.maSP == id);
item.soLuong += sl;
cartModel.tongTien += item.donGia * sl;
//return "ok";
return(li);
}
else
{
cartModel cart = new cartModel();
cart.maSP = (int)query.masp;
cart.tenSP = query.tensp;
cart.Hinh = query.hinhanh;
cart.donGiaKM = (int)query.giakm;
cart.donGiaGoc = (int)query.gia;
if (query.giakm != 0)
{
cart.donGia = (int)query.giakm;
}
else
{
cart.donGia = (int)query.gia;
}
cart.soLuong = sl;
cartModel.tongTien += cart.donGia * sl;
cartModel.tongSoHang += sl;
li.Add(cart);
//return "ok";
return(li);
}
}
public infoClientModel LoadInfo(int makh)
{
using (var ctx = new CoffeeHouseDbContext())
{
var query = (from u in ctx.users
join kh in ctx.khachhangs
on u.id equals kh.matk
where kh.makh == makh
select new
{
idUser = u.id,
idKH = kh.makh,
tenKH = kh.hoten,
email = kh.email,
tenTK = u.tentk,
gioiTinh = kh.gioitinh,
diaChi = kh.diachi,
sdt = kh.sodt
}).FirstOrDefault();
infoClientModel info = new infoClientModel();
info.diachi = query.diaChi;
info.email = query.email;
info.gioitinh = query.gioiTinh;
info.hoten = query.tenKH;
info.sodt = query.sdt;
info.tenTk = query.tenTK;
info.idUser = (int)query.idUser;
info.idKH = (int)query.idKH;
return(info);
//ClientInfoUnit clientInfoUnit = new ClientInfoUnit();
//clientInfoUnit.idUser = (int)query.idUser;
//clientInfoUnit.idKH = (int)query.idKH;
//clientInfoUnit.tenKH = query.tenKH;
//clientInfoUnit.gioiTinh = query.gioiTinh;
//clientInfoUnit.diaChi = query.diaChi;
//clientInfoUnit.sdt = query.sdt;
//return clientInfoUnit;
}
// var query = (from u in context.users
// join kh in context.khachhangs
// on u.id equals kh.matk
// where kh.makh == makh
// select new
// {
// idUser = u.id,
// idKH = kh.makh,
// tenKH = kh.hoten,
// email = kh.email,
// tenTK = u.tentk,
// gioiTinh = kh.gioitinh,
// diaChi = kh.diachi,
// sdt = kh.sodt
// }).FirstOrDefault();
//infoClientModel info = new infoClientModel();
//info.diachi = query.diaChi;
//info.email = query.email;
//info.gioitinh = query.gioiTinh;
//info.hoten = query.tenKH;
//info.sodt = query.sdt;
//info.tenTk = query.tenTK;
//info.idUser = (int)query.idUser;
//info.idKH = (int)query.idKH;
//return info;
////ClientInfoUnit clientInfoUnit = new ClientInfoUnit();
////clientInfoUnit.idUser = (int)query.idUser;
////clientInfoUnit.idKH = (int)query.idKH;
////clientInfoUnit.tenKH = query.tenKH;
////clientInfoUnit.gioiTinh = query.gioiTinh;
////clientInfoUnit.diaChi = query.diaChi;
////clientInfoUnit.sdt = query.sdt;
////return clientInfoUnit;
}
//private CoffeeHouseDbContext context = new CoffeeHouseDbContext();
public int ThanhToan(List <cartModel> li, int makh, CheckOutInfoModel info)
{
using (var ctx = new CoffeeHouseDbContext())
{
int madh;
donhang dh = new donhang();
//dh.khachhang = kh;
dh.makh = makh;
dh.ngaydat = DateTime.Today;
dh.tongtien = cartModel.tongTien;
dh.ghichu = info.ghichu;
dh.httt = info.httt;
dh.tttt = 0;
ctx.donhangs.Add(dh);
ctx.SaveChanges();
//ma = dh.madh;
//donhang temp = context.donhangs.Find(dh.madh);
madh = (int)dh.madh;
foreach (var sp in li)
{
ctdh ct = new ctdh();
//ct.madh = ma;
/*ct.donhang = dh;*/
//ct.madh = temp.madh;
ct.madh = madh;
ct.masp = sp.maSP;
ct.soluong = sp.soLuong;
ct.gia = sp.donGia;
ctx.ctdhs.Add(ct);
//context.SaveChanges();
}
//try
//{
// context.SaveChanges();
//}
//catch (Exception exc)
//{
// string message = exc.GetType().FullName + ": " + exc.Message;
//}
cartModel.tongSoHang = 0;
cartModel.tongTien = 0;
return(ctx.SaveChanges());
}
//long ma;
//khachhang kh = context.khachhangs.FirstOrDefault(x => x.makh == makh);
//kh.diachi = info.diaChi;
//kh.email = info.gmail;
//kh.ghichu = info.ghichu;
//kh.gioitinh = info.gioitinh;
//kh.hoten = info.tenKH;
//kh.sodt = info.sdt;
//kh.matk = null;
//context.khachhangs.Add(kh);
//context.SaveChanges();
// int madh;
// donhang dh = new donhang();
// //dh.khachhang = kh;
// dh.makh = makh;
// dh.ngaydat = DateTime.Today;
// dh.tongtien = cartModel.tongTien;
// dh.ghichu = info.ghichu;
// dh.httt = info.httt;
// dh.tttt = 0;
// context.donhangs.Add(dh);
// context.SaveChanges();
// //ma = dh.madh;
// //donhang temp = context.donhangs.Find(dh.madh);
// madh = (int) dh.madh;
// foreach (var sp in li)
// {
// ctdh ct = new ctdh();
// //ct.madh = ma;
// /*ct.donhang = dh;*/
// //ct.madh = temp.madh;
// ct.madh = madh;
// ct.masp = sp.maSP;
// ct.soluong = sp.soLuong;
// ct.gia = sp.donGia;
// context.ctdhs.Add(ct);
// //context.SaveChanges();
// }
// //try
// //{
// // context.SaveChanges();
// //}
// //catch (Exception exc)
// //{
// // string message = exc.GetType().FullName + ": " + exc.Message;
// //}
// cartModel.tongSoHang = 0;
// cartModel.tongTien = 0;
//return context.SaveChanges();
}
public DangnhapDao()
{
db = new CoffeeHouseDbContext();
}
public IntroductDao()
{
context = new CoffeeHouseDbContext();
}
public TrangchuDao()
{
db = new CoffeeHouseDbContext();
}
public ReminderDao()
{
db = new CoffeeHouseDbContext();
}
public KhachhangDao()
{
db = new CoffeeHouseDbContext();
}
public DonhangDao()
{
db = new CoffeeHouseDbContext();
}
public taikhoanDao()
{
db = new CoffeeHouseDbContext();
}
public AjaxDao()
{
db = new CoffeeHouseDbContext();
}
public HoadonDao()
{
db = new CoffeeHouseDbContext();
}
