public static string Update(int ID, string Title, string Content, string Image, int Featured, int CategoryID, int Status, string PostSlug, string ModifiedBy, DateTime ModifiedDate)
{
using (var dbe = new inventorymanagementEntities())
{
tbl_Post ui = dbe.tbl_Post.Where(a => a.ID == ID).SingleOrDefault();
if (ui != null)
{
ui.Title = Title;
ui.Content = Content;
ui.Image = Image;
ui.Featured = Featured;
ui.CategoryID = CategoryID;
ui.Status = Status;
ui.ModifiedBy = ModifiedBy;
ui.ModifiedDate = ModifiedDate;
ui.Slug = checkSlug(Slug.ConvertToSlug(PostSlug != "" ? PostSlug : Title), ui.ID);
int kq = dbe.SaveChanges();
return(ui.ID.ToString());
}
else
{
return(null);
}
}
}
public static List <Tag> insert(List <TagModel> tagList, tbl_Account acc)
{
using (var con = new inventorymanagementEntities())
{
var now = DateTime.Now;
var textInfo = new CultureInfo("vi-VN", false).TextInfo;
var tagNew = tagList.Where(x =>
x.slug.StartsWith(String.Format("tag-new-{0:yyyyMMdd}", now))
)
.Select(x => new Tag
{
Name = textInfo.ToLower(x.name.Trim()),
Slug = Slug.ConvertToSlug(x.name.Trim()),
CreatedBy = acc.ID,
CreatedDate = now
})
.ToList();
// Check unique slug
foreach (var tag in tagNew)
{
var tagLast = con.Tags.Where(x => x.Slug.StartsWith(tag.Slug))
.OrderByDescending(o => o.ID)
.FirstOrDefault();
if (tagLast != null)
{
var strIndex = Regex.Match(tagLast.Slug, @"\d+$").Value;
if (!String.IsNullOrEmpty(strIndex))
{
tag.Slug = String.Format("{0}-{1}", tag.Slug, Convert.ToInt32(strIndex) + 1);
}
else
{
tag.Slug = String.Format("{0}-{1}", tag.Slug, 1);
}
}
}
con.Tags.AddRange(tagNew);
con.SaveChanges();
return(tagNew);
}
}