// updatePost
private void updatePost()
{
try {
int id = int.Parse(this.dgvPost.CurrentRow.Cells[0].Value.ToString());
post post = db.posts.SingleOrDefault(p => p.id == id);
post.post_title = tbTitle.Text;
post.post_content = tbContent.Text;
post.post_author = int.Parse(cbbUser.SelectedValue.ToString());
post.date_updated = DateTime.Now;
var cbStatus = 0;
if (cbPublish.Checked)
{
cbStatus = cbStatus == 0 ? 1 : 0;
}
post.status = cbStatus;
db.SaveChanges();
MessageBox.Show("Update Sucessed");
loadPost();
}
catch {
MessageBox.Show("Update Failed");
}
}
//add Post
private void BtnAddPost_Click(object sender, EventArgs e)
{
var cbStatus = 0;
if (cbPublish.Checked)
{
cbStatus = 1;
}
else
{
cbStatus = 0;
}
byte[] images = null;
try {
if (imgsrc.Length > 0)
{
FileStream fs = new FileStream(imgsrc, FileMode.Open, FileAccess.Read);
BinaryReader br = new BinaryReader(fs);
images = br.ReadBytes((int)fs.Length);
}
var newPost = new post {
//post_author = int.Parse(cbbUser.SelectedValue.ToString()),
post_author = LoginInfo.userId,
post_content = tbContent.Text,
post_title = tbTitle.Text,
category = int.Parse(cbbCategory.SelectedValue.ToString()),
status = cbStatus,
date_created = DateTime.Now,
date_updated = DateTime.Now,
img = images
};
db.posts.Add(newPost);
db.SaveChanges();
tbTitle.Clear();
tbContent.Clear();
cbPublish.Checked = false;
picturePost.Image = Properties.Resources.ClickHere;
if (role.Equals("USER") || role == "USER")
{
loadPostByUser(id);
}
else
{
loadPost();
}
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx) {
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = $"{validationErrors.Entry.Entity.ToString()}:{validationError.ErrorMessage}";
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
}
