public static IEnumerable <MobileShopConnection.v_GioHang> DanhSach(string MaTaiKhoan) { using (var db = new MobileShopConnectionDB()) { return(db.Query <v_GioHang>("select * from v_GioHang where MaTaiKhoan=@0", MaTaiKhoan)); } }
public static void KhoiPhuc(int id) { var db = new MobileShopConnectionDB(); var rs = Sql.Builder.Append("Exec KhoiPhucLoaiSP @0", id); db.Execute(rs); }
public static LoaiSP ChiTietViewModel(int?id) { using (var db = new MobileShopConnectionDB()) { return(db.Query <MobileShopConnection.LoaiSP>("select * from LoaiSP where MaLoai = @0", id).FirstOrDefault()); } }
public static IEnumerable <BinhLuan> DanhSach(String MaSP) { using (var sql = new MobileShopConnectionDB()) { return(sql.Query <BinhLuan>(" select * from BinhLuan where MaSP = @0 ORDER BY Ngay DESC", MaSP)); } }
public static void Xoa(int id) { var db = new MobileShopConnectionDB(); var rs = Sql.Builder.Append("Exec XoaHangSP @0", id); db.Execute(rs); }
public static int TongTien(string mataikhoan) { using (var sql = new MobileShopConnectionDB()) { return(sql.Query <int>("select sum(TongTien) from GioHang where MaTaiKhoan = '" + mataikhoan + "'").FirstOrDefault()); } }
public static IEnumerable <GioHang> DanhSach(string mataikhoan) { using (var sql = new MobileShopConnectionDB()) { return(sql.Query <GioHang>("select * from GioHang where MaTaiKhoan = '" + mataikhoan + "'")); } }
public static void Them(string masanpham, string mataikhoan, int gia, int soluong, string tensanpham) { using (var sql = new MobileShopConnectionDB()) { var x = sql.Query <GioHang>("select * from GioHang Where MaTaiKhoan = '" + mataikhoan + "'and MaSP ='" + masanpham + "'").ToList(); if (x.Count() > 0) { //update so luong int a = (int)x.ElementAt(0).SoLuong + soluong; CapNhat(masanpham, mataikhoan, gia, a, tensanpham); } else { GioHang giohang = new GioHang() { MaSP = masanpham, MaTaiKhoan = mataikhoan, Gia = gia, SoLuong = soluong, TenSP = tensanpham, TongTien = gia * soluong }; sql.Insert(giohang); } } }
public static void Xoa(string masanpham, string mataikhoan) { using (var sql = new MobileShopConnectionDB()) { var a = sql.Query <GioHang>("select * from GioHang Where MaTaiKhoan = '" + mataikhoan + "'and MaSP ='" + masanpham + "'").FirstOrDefault(); sql.Delete(a); } }
public static void Them(string MaSP, string MaTaiKhoan, string TenTaiKhoan, string NoiDung) { using (var sql = new MobileShopConnectionDB()) { BinhLuan binhLuan = new BinhLuan(); binhLuan.MaSP = MaSP; binhLuan.MaTaiKhoan = MaTaiKhoan; binhLuan.NoiDung = NoiDung; sql.Execute("INSERT INTO [dbo].[BinhLuan]([MaSP],[MaTaiKhoan],[TenTaiKhoan],[NoiDung]) VALUES (@0,@1,@2,@3)", MaSP, MaTaiKhoan, TenTaiKhoan, NoiDung); } }
public static void Them(int MaSanPham, string MaTaiKhoan) { using (var db = new MobileShopConnectionDB()) { GioHang gh = new GioHang() { MaSanPham = MaSanPham, MaTaiKhoan = MaTaiKhoan, SoLuong = 1 }; db.Insert(gh); } }
public static IEnumerable <SanPham> Search(string searchString)//, int page, int pageSize ) { //var db = new MobileShopConnectionDB(); //IQueryable<SanPham> model = db.SanPhams; ////IObs<SanPham> model = db.Query<SanPham>("select * from SanPham where TenSP Like '%" + searchString + "%'").ToList(); ////var text = db.Query<SanPham>("select * from SanPham where TenSP Like '%" + searchString + "%'"); //if (!string.IsNullOrEmpty(searchString)) //{ // model = model.Where(x => x.TenSP.Contains(searchString) || x.MoTa.Contains(searchString)).OrderByDescending(x => x.MaSP); // //text = text.Where(s => s.TenSP.Contains(searchString)).ToList(); //} //return model.ToPagedList(page, pageSize); var db = new MobileShopConnectionDB(); return(db.Query <SanPham>("Select * From SanPham Where TenSP like '%" + searchString + "%' or Ram like '%" + searchString + "%' or Gia like '%" + searchString + "%' or SoLuongBan like '%" + searchString + "%' or HeDieuHanh like '%" + searchString + "%' or BoNhoTrong like '%" + searchString + "%' or CameraTruoc like '%" + searchString + "%' or CameraSau like '%" + searchString + "%' or TheNho like '%" + searchString + "%'")); }
public static void CapNhat(string masanpham, string mataikhoan, int gia, int soluong, string tensanpham) { using (var sql = new MobileShopConnectionDB()) { GioHang giohang = new GioHang() { MaSP = masanpham, MaTaiKhoan = mataikhoan, Gia = gia, SoLuong = soluong, TenSP = tensanpham, TongTien = gia * soluong }; var tamp = sql.Query <GioHang>("select id from GioHang Where MaTaiKhoan = '" + mataikhoan + "'and MaSP ='" + masanpham + "'").FirstOrDefault(); sql.Update(giohang, tamp.Id); } }
public ActionResult Edit(int id, SanPham sp) { var db = new MobileShopConnectionDB(); var rs = db.SingleOrDefault <MobileShopConnection.SanPham>("select HinhAnh from sanpham where MaSP=@0", id); if (HttpContext.Request.Files.Count > 0) { var hpf = HttpContext.Request.Files[0]; if (hpf.ContentLength > 0) { string fileName = Guid.NewGuid().ToString(); string fullPathWithFileName = "/ShopOnline/img/" + fileName + ".jpg"; hpf.SaveAs(Server.MapPath(fullPathWithFileName)); sp.HinhAnh = fileName + ".jpg"; } else { sp.HinhAnh = rs.HinhAnh; } } SanPhamBus.Sua(sp); return(RedirectToAction("Index")); }
public static void UpdateNSX(String id, NhaSanXuat NSX) { var sql = new MobileShopConnectionDB(); sql.Update(NSX, id); }
public static IEnumerable <BinhLuan> DanhSach(int id) { var db = new MobileShopConnectionDB(); return(db.Query <BinhLuan>("select * from BinhLuan where TinhTrang != 1 and MaSanPham=@0 order by ThoiGian desc", id)); }
public static void ThemBinhLuan(BinhLuan bl) { var db = new MobileShopConnectionDB(); db.Insert(bl); }
public static IEnumerable <NhaSanXuat> DanhSach() { var sql = new MobileShopConnectionDB(); return(sql.Query <NhaSanXuat>("select * from NhaSanXuat where TinhTrang = 0")); }
public static void Sua(MobileShopConnection.LoaiSP LoaiSP) { var db = new MobileShopConnectionDB(); db.Update(LoaiSP); }
public static void CapNhat(int SoLuong, int MaSanPham, string MaTaiKhoan) { using (var db = new MobileShopConnectionDB()) { db.Execute("Update GioHang set SoLuong=@0 where MaSanPham=@1 and MaTaiKhoan=@2", SoLuong, MaSanPham, MaTaiKhoan); } }
public static IEnumerable <SanPham> ChiTietNSX(String id) { var sql = new MobileShopConnectionDB(); return(sql.Query <SanPham>("select * from SanPham where MaNhaSX = '" + id + "'")); }
public static SanPham LoadAvartaImg(String id) { var sql = new MobileShopConnectionDB(); return(sql.SingleOrDefault <SanPham>("select * from SanPham where MaSP = @0", id)); }
//admin //them public static IEnumerable <NhaSanXuat> DanhSanhNSXAdmin() { var sql = new MobileShopConnectionDB(); return(sql.Query <NhaSanXuat>("select * from NhaSanXuat ")); }
public static void SuaSanPham(string id, MobileShopConnection.SanPham sp) { var db = new MobileShopConnectionDB(); db.Update <SanPham>("SET TenSP=@0, MoTa=@1, MaNhaSX=@2, Gia=@3, HeDieuHanh=@4, HinhChinh=@5, ManHinh=@6, RAM=@7, CameraSau=@8, CameraTruoc=@9, MaLoaiSP=@10, BoNhoTrong=@11, TinhTrang=@12 where MaSanPham=@13", sp.TenSP, sp.MoTa, sp.MaNhaSX, sp.Gia, sp.HeDieuHanh, sp.HinhChinh, sp.ManHinh, sp.RAM, sp.CameraSau, sp.CameraTruoc, sp.MaLoaiSP, sp.BoNhoTrong, sp.TinhTrang, id); }
public static void XoaTamSanPham(string id) { var db = new MobileShopConnectionDB(); db.Update <SanPham>("SET TinhTrang=1 where MaSP=@0", id); }
public static void ThemSP(SanPham sp) { var sql = new MobileShopConnectionDB(); sql.Insert(sp); }
public static IEnumerable <SanPham> DanhSachSP() { var sql = new MobileShopConnectionDB(); return(sql.Query <SanPham>("select * from SanPham ")); }
public static IEnumerable <SanPham> DanhSachTOP10() { var sql = new MobileShopConnectionDB(); return(sql.Query <SanPham>(" SELECT TOP 10 * FROM SanPham WHERE TinhTrang = 0 ORDER BY SoLuongBan DESC")); }
public static void ThemNSX(NhaSanXuat NSX) { var sql = new MobileShopConnectionDB(); sql.Insert(NSX); }
//edit public static NhaSanXuat EditNSX(String id) { var sql = new MobileShopConnectionDB(); return(sql.SingleOrDefault <NhaSanXuat>("select * from NhaSanXuat where MaNhaSX = '" + id + "'")); }