public static void Them(DonDatHang dh, List <ChiTietDH> ctdh, string username)
{
var db = new SmartShopConnectionDB();
db.Insert("DonDatHang", "MaDH", dh);
var madh = db.SingleOrDefault <DonDatHang>("SELECT TOP 1 * FROM DonDatHang WHERE Username=@0 ORDER BY MaDH DESC", username);
foreach (var item in ctdh)
{
item.MaDH = madh.MaDH;
db.Insert("ChiTietDH", "MaDH", item);
}
}
public static void PhanQuyen(string us)
{
var db = new SmartShopConnectionDB();
var user = db.SingleOrDefault <viewUser>("SELECT * FROM viewUser where UserName=@0", us);
AspNetUserRole pq = new AspNetUserRole();
pq.RoleId = "12629e90-6c15-424b-abaa-164250682d15";
pq.UserId = user.UserId;
db.Insert("AspNetUserRoles", pq);
}
public static void Them(Loai l)
{
var db = new SmartShopConnectionDB();
db.Insert("Loai", "MaLoai", l);
}
public static void Them(Comment cmt)
{
var db = new SmartShopConnectionDB();
db.Insert(cmt);
}
public static void Them(Product sp)
{
var db = new SmartShopConnectionDB();
db.Insert("Product", "MaSP", sp);
}
public static void Them(Account acc)
{
var db = new SmartShopConnectionDB();
db.Insert("Accounts", "UserName", acc);
}
public static void Them(ChungLoai cl)
{
var db = new SmartShopConnectionDB();
db.Insert(cl);
}
public static void ThemCTDH(ChiTietDH ctdh)
{
var db = new SmartShopConnectionDB();
db.Insert("ChiTietDH", "MaDH", ctdh);
}