public void DeleteMultiItemByIdPost(int id)
{
using (DbContextTransaction transaction = db.Database.BeginTransaction())
{
try
{
db.COMMENTS.RemoveRange(db.COMMENTS.Where(c => c.ID_POST == id));
int i = db.SaveChanges();
transaction.Commit();
}
catch
{
transaction.Rollback();
}
}
}
public int AddItem(USER User)
{
using (DbContextTransaction transaction = db.Database.BeginTransaction())
{
try
{
User.PASSWORD = MyEndCode.mahoa(User.PASSWORD);
db.USERS.Add(User);
int i = db.SaveChanges();
transaction.Commit();
return(i);
}
catch
{
transaction.Rollback();
return(0);
}
}
}
public int AddItem(CATEGORy Category)
{
using (DbContextTransaction transaction = db.Database.BeginTransaction())
{
try
{
Category.URL_SLUG = ConvertString.ToUrlSlug(Category.NAME);
db.CATEGORIES.Add(Category);
int i = db.SaveChanges();
transaction.Commit();
return(Category.ID);
}
catch
{
transaction.Rollback();
return(0);
}
}
}
public int AddItem(POST Post)
{
using (DbContextTransaction transaction = db.Database.BeginTransaction())
{
try
{
Post.URL_SLUG = ConvertString.ToUrlSlug(Post.TITLE);
Post.DATE_CREATED = DateTime.Now;
db.POSTs.Add(Post);
int i = db.SaveChanges();
transaction.Commit();
return(Post.ID);
}
catch
{
transaction.Rollback();
return(0);
}
}
}
public int Add(ABOUT About)
{
db.ABOUTS.Add(About);
return(db.SaveChanges());
}
public int Add(VOTE Vote)
{
db.VOTEs.Add(Vote);
return(db.SaveChanges());
}
