public ActionResult newPost(tPost post)
{
if (Request.Files.Count > 0)
{
var file = Request.Files[0];
byte[] bytes;
using (var binaryReader = new BinaryReader(file.InputStream))
{
bytes = binaryReader.ReadBytes(file.ContentLength);
}
post.FileImg = bytes;
}
retryId:
string postID = new Utilities().GenerateCoupon(5);
if (db.tPosts.Any(a => a.PostId == postID))
{
goto retryId;
}
post.DateCreated = DateTime.Now;
post.DateUpdated = DateTime.Now;
post.PostId = postID;
var newPost = db.tPosts.Add(post);
db.SaveChanges();
var newPostObj = db.tPosts.Where(w => w.PostId == newPost.PostId).Select(s => new
{
s.DateCreated,
s.DateUpdated,
s.Description,
s.PostId,
s.Title,
s.UserId,
HasFile = db.tPosts.Any(a => a.PostId == s.PostId && s.FileImg != null) ? true : false,
Name = db.tBusinessEntities.FirstOrDefault(f => f.UserId == s.UserId).BusinessEntityName,
JobTitle = db.tJobs.FirstOrDefault(f => f.JobId == s.JobId).JobTitle,
Comments = db.tComments.Where(w => w.PostId == s.PostId).Select(ss => new
{
ss.CommentId,
ss.DateCreated,
ss.DateUpdated,
ss.Comment,
ss.PostId,
ss.UserId,
Name = db.tBusinessEntities.Any(b => b.UserId == ss.UserId) ? db.tBusinessEntities.FirstOrDefault(f => f.UserId == ss.UserId).BusinessEntityName : db.tPersonInfoes.Where(p => p.UserId == ss.UserId).Select(sss => new { Name = sss.Firstname + " " + (sss.Middlename != null ? sss.Middlename.Substring(0, 1) : "") + sss.Lastname }).FirstOrDefault().Name,
UserType = db.tBusinessEntities.Any(b => b.UserId == ss.UserId) ? 1 : 0
})
}).FirstOrDefault();
context.Clients.All.newPost(newPostObj);
return(Json(1, JsonRequestBehavior.AllowGet));
}
public ActionResult edit(int?id)
{
if (id == null)
{
return(View("list"));
}
else
{
tPost x = db.tPost.FirstOrDefault(m => m.fId == id);
return(View(x));
}
}
public ActionResult delete(int?id)
{
if (id == null)
{
return(View("list"));
}
else
{
tPost x = db.tPost.FirstOrDefault(m => m.fId == id);
db.tPost.Remove(x);
db.SaveChanges();
return(RedirectToAction("list"));
}
}
public ActionResult edit(tPost x)
{
tPost y = db.tPost.FirstOrDefault(m => m.fId == x.fId);
if (y == null)
{
return(View("list"));
}
else
{
y.fMemberId = x.fMemberId;
y.fCommunityId = x.fCommunityId;
y.fContent = x.fContent;
y.fPostTime = x.fPostTime;
y.fImgPaths = x.fImgPaths;
db.SaveChanges();
return(RedirectToAction("list"));
}
}
public ActionResult create(tPost x)
{
db.tPost.Add(x);
db.SaveChanges();
return(RedirectToAction("list"));
}
