public void EditBlogRecord(BlogDataModel model)
{
dbContext = new RockstarDBModelDataContext();
BlogTbl oldBlogItem = dbContext.BlogTbls.Where(o => o.Id == model.Id).FirstOrDefault();
BlogFileTbl oldBlogFile = dbContext.BlogFileTbls.Where(f => f.BlogId == model.Id).FirstOrDefault();
DateTime now = DateTime.UtcNow;
DateTime localNow = TimeZoneInfo.ConvertTimeFromUtc(now, TimeZoneInfo.Local);
oldBlogItem.BlogTitle = model.BlogTitle;
oldBlogItem.BlogContent = model.BlogContent;
oldBlogItem.DateCreated = localNow;
if (model.FileContent != null)
{
byte[] firstUploadFile = new byte[model.FileContent.InputStream.Length];
model.FileContent.InputStream.Read(firstUploadFile, 0, firstUploadFile.Length);
oldBlogFile.FileTitle = model.FileContent.FileName;
oldBlogFile.FileData = firstUploadFile;
oldBlogFile.BlogId = oldBlogItem.Id;
}
dbContext.SubmitChanges();
}
public void CreateBlogEntry(BlogDataModel model)
{
dbContext = new RockstarDBModelDataContext();
BlogTbl blogTbl = new BlogTbl();
BlogFileTbl blogFileTbl = new BlogFileTbl();
DateTime now = DateTime.UtcNow;
DateTime localNow = TimeZoneInfo.ConvertTimeFromUtc(now, TimeZoneInfo.Local);
blogTbl.BlogTitle = model.BlogTitle;
blogTbl.BlogContent = model.BlogContent;
blogTbl.DateCreated = localNow;
dbContext.BlogTbls.InsertOnSubmit(blogTbl);
dbContext.SubmitChanges();
if (model.FileContent != null)
{
byte[] firstUploadFile = new byte[model.FileContent.InputStream.Length];
model.FileContent.InputStream.Read(firstUploadFile, 0, firstUploadFile.Length);
blogFileTbl.FileTitle = model.FileContent.FileName;
blogFileTbl.FileData = firstUploadFile;
blogFileTbl.BlogId = blogTbl.Id;
dbContext.BlogFileTbls.InsertOnSubmit(blogFileTbl);
dbContext.SubmitChanges();
}
}
/// <summary>
/// Blog view
/// </summary>
/// <returns></returns>
public ActionResult Blog()
{
ViewBag.Message = "Blog";
BlogService svc = new BlogService();
List<BlogFileTbl> fileTbl = svc.ReadAllBlogFiles();
List<BlogTbl> blogTbl = svc.ReadAllBlogItems();
List<BlogDataModel> blogList = new List<BlogDataModel>();
foreach (BlogTbl blogItem in blogTbl)
{
BlogDataModel model = new BlogDataModel();
foreach (BlogFileTbl fileItem in fileTbl)
{
if (fileItem.BlogId == blogItem.Id)
{
model.FileData = fileItem.FileData.ToArray();
}
}
//Assigning values to blog model
model.BlogTitle = blogItem.BlogTitle;
model.BlogContent = blogItem.BlogContent;
model.DateCreated = (DateTime)blogItem.DateCreated;
blogList.Add(model);
}
return View(blogList);
}
public ActionResult EditBlogEntry(BlogDataModel model)
{
BlogService svc = new BlogService();
svc.EditBlogRecord(model);
return Redirect("/Account/BlogTool?GUID=" + AdminToolsGUID);
}