コード例 #1
0
        public static void Xoa(string id, Product sp)
        {
            var db = new SmartShopConnectionDB();

            db.Execute("DELETE FROM Comment WHERE MaSP=@0", id);
            db.Execute("DELETE FROM Product WHERE MaSP=@0", id);
        }
コード例 #2
0
        public static void Xoa(string us)
        {
            var    db   = new SmartShopConnectionDB();
            var    user = db.SingleOrDefault <viewUser>("SELECT * FROM viewUser where UserName=@0", us);
            string id   = user.UserId;

            db.Execute("DELETE FROM AspNetUserRoles WHERE UserId=@0", id);
            db.Execute("DELETE FROM AspNetUsers WHERE UserName=@0", us);
            db.Execute("DELETE FROM Accounts WHERE UserName=@0", us);
        }
コード例 #3
0
        public static void Xoa(string id, Loai l)
        {
            var db = new SmartShopConnectionDB();

            db.Execute("DELETE FROM Loai WHERE MaLoai=@0", id);
        }
コード例 #4
0
        public static void Xoa(int id)
        {
            var db = new SmartShopConnectionDB();

            db.Execute("DELETE FROM Comment WHERE IDCmt=@0", id);
        }
コード例 #5
0
        public static void Xoa(int id, ChungLoai cl)
        {
            var db = new SmartShopConnectionDB();

            db.Execute("DELETE FROM ChungLoai WHERE MaCL=@0", id);
        }