public long NewDiary(NewDiaryModel diary)
{
SqlConnection con = new SqlConnection(cs);
con.Open();
string query = @"INSERT INTO [Diary].[dbo].[Diary Entries] (
[Status]
,[Category]
,[Title]
,[Body]
,[Hidden]
) output INSERTED.AutoId
VALUES(@status,@category,@title,@body,@hidden)";
SqlCommand command = new SqlCommand(query, con);
command.Parameters.Add(new SqlParameter("@status", diary.SelectedStatus));
command.Parameters.Add(new SqlParameter("@category", diary.SelectedCategory));
command.Parameters.Add(new SqlParameter("@title", diary.Title));
command.Parameters.Add(new SqlParameter("@body", diary.Body));
command.Parameters.Add(new SqlParameter("@hidden", diary.Hidden));
Int64 Id = (Int64)command.ExecuteScalar();
con.Close();
return(Id);
}
public int UpDateDiary(NewDiaryModel model)
{
SqlConnection con = new SqlConnection(cs);
con.Open();
string query = @"[Status] = @status
,[Category] = @category
,[Title] = @title
,[Body] = @body
,[Hidden] = @hidden
,[Modified Date] = @modifieddate";
SqlCommand command = new SqlCommand(query, con);
command.Parameters.Add(new SqlParameter("@status", model.SelectedStatus));
command.Parameters.Add(new SqlParameter("@category", model.SelectedCategory));
command.Parameters.Add(new SqlParameter("@title", model.Title));
command.Parameters.Add(new SqlParameter("@body", model.Body));
command.Parameters.Add(new SqlParameter("@hidden", model.Hidden));
command.Parameters.Add(new SqlParameter("@modifieddate", DateTime.Now));
int rowcount = (int)command.ExecuteNonQuery();
con.Close();
return(rowcount);
}
public ActionResult New(NewDiaryViewModel model)
{
NewDiaryModel diary = model.NewDiary;
if (diary != null)
{
long id = m_diaryUtil.NewDiary(diary);
m_diaryUtil.NewDiaryAttachmentsHelper(model.NewDiary.Files, id);
}
TempData["Message"] = "Diary created";
return(RedirectToAction("List"));
}
