public static IEnumerable <LoaiSanPham> LDanhSach()
{
using (var db = new WebGiuaKiConnectionDB())
{
return(db.Query <WebGiuaKiConnection.LoaiSanPham>("select * from LoaiSanPham"));
}
}
public static void Updatensx(int id, LoaiSanPham lsp)
{
{
var sql = new WebGiuaKiConnectionDB();
sql.Update(lsp, id);
}
}
public static void DeleteDS(int id)
{
using (var db = new WebGiuaKiConnectionDB())
{
var lsp = db.Single <LoaiSanPham>("select * from LoaiSanPham where MaLoaiSanPham = @0", id);
lsp.TinhTrang = 1;
db.Update("LoaiSanPham", "MaLoaiSanPham", lsp);
}
}
//--------xoa tam thoi san pham--------------------//
public static void xoatamDS(int id)
{
using (var db = new WebGiuaKiConnectionDB())
{
var lsp = db.Single <SanPham>("select * from SanPham where MaSP = @0", id);
lsp.TinhTrang = 1;
db.Update("SanPham", "MaSP", lsp);
}
}
public static LoaiSanPham ChitietAdmin(int id)
{
var db = new WebGiuaKiConnectionDB();
return(db.SingleOrDefault <LoaiSanPham>("select * from LoaiSanPham where MaLoaiSanPham = @0", id));
}
public static IEnumerable <LoaiSanPham> DanhSachAdmin()
{
var db = new WebGiuaKiConnectionDB();
return(db.Query <LoaiSanPham>("select * from LoaiSanPham"));
}
//--Admin
public static void Them(LoaiSanPham sx)
{
var sql = new WebGiuaKiConnectionDB();
sql.Insert(sx);
}
public static SanPham ChiTietAdmin(int id)
{
var db = new WebGiuaKiConnectionDB();
return(db.SingleOrDefault <SanPham>("select *from SanPham where MaSP=@0", id));
}
public static void ThemSP(SanPham sp)
{
var db = new WebGiuaKiConnectionDB();
db.Insert(sp);
}
public static Page <SanPham> DanhSach(int page, int itempage)
{
var db = new WebGiuaKiConnectionDB();
return(db.Page <SanPham>(page, itempage, "select * from SanPham"));
}
public static IEnumerable <SanPham> DanhSach()
{
var db = new WebGiuaKiConnectionDB();
return(db.Query <SanPham>("select * from SanPham where TinhTrang =0"));
}
public static IEnumerable<SanPham> TatCaSanPham(int id)
{
var sql = new WebGiuaKiConnectionDB();
return sql.Query<SanPham>("select * from SanPham where MaLoaiSanPham = @0", id).ToList();
}
public static SanPham ChiTiet(int id)
{
var sql = new WebGiuaKiConnectionDB();
return sql.SingleOrDefault<SanPham>("select * from SanPham where MaSP =@0 ", id);
}
public static IEnumerable<LoaiSanPham> DanhSach()
{
var sql = new WebGiuaKiConnectionDB();
return sql.Query<LoaiSanPham>("select * from LoaiSanPham where TinhTrang = 0");
}
