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(); }