public void SaveNote(TaskNote taskNote)
{
var sql = @"
if exists(select * from TaskNote where TaskNoteID = @TaskNoteID)
begin
update TaskNote set
Text = @Text
, TaskID = @TaskID
, CreateDate = @CreateDate
, CreatedBy = @CreatedBy
where TaskNoteID = @TaskNoteID
end
else
begin
insert into TaskNote(
Text
, TaskID
, CreateDate
, CreatedBy
)values(
@Text
, @TaskID
, @CreateDate
, @CreatedBy
);
select scope_identity() as 'TaskNoteID'
end
";
using (var cmd = new SqlCommand(sql))
{
cmd.Parameters.Add("@TaskNoteID", SqlDbType.Int).Value = taskNote.TaskNoteID;
cmd.Parameters.Add("@Text", SqlDbType.VarChar, 1000).Value = taskNote.Text;
cmd.Parameters.Add("@TaskID", SqlDbType.Int).Value = ValueOrNull(taskNote.TaskID);
cmd.Parameters.Add("@CreateDate", SqlDbType.DateTime).Value = taskNote.CreateDate;
cmd.Parameters.Add("@CreatedBy", SqlDbType.Int).Value = taskNote.CreatedBy;
var id = _simpleTasks.ExecuteScalar<int>(cmd);
if (taskNote.TaskNoteID == 0)
{
taskNote.TaskNoteID = id;
}
}
}
public ActionResult SaveNote(TaskNote note)
{
note.CreatedBy = CurrentMember.MemberID;
_service.SaveNote(note);
return RedirectToAction("Edit", new { id = note.TaskID });
}
public void SaveNote(TaskNote taskNote)
{
taskNote.CreateDate = DateTime.Now;
_projectRepo.SaveNote(taskNote);
}
