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 + "'"));
}
