public void UpdateTask(TaskEx task)
{
task.ResolvedDate = (task.Status == "2") ? DateTime.Now : (DateTime?)null;
// Dapper - Update
using (var conn = ConnectionFactory.GetOpenConnection())
{
var dbTask = conn.Query<TaskEx>("SELECT * FROM Tasks where Id = @id", new { id = task.Id }).First();
dbTask.Name = task.Name;
dbTask.CreatedBy = task.CreatedBy;
dbTask.CreatedDate = task.CreatedDate;
dbTask.Resolver = task.Resolver;
dbTask.ResolvedDate = task.ResolvedDate;
dbTask.Status = task.Status;
conn.Execute(@"UPDATE Tasks SET
Name = @Name, CreatedBy = @CreatedBy, CreatedDate = @CreatedDate, Resolver = @Resolver,
ResolvedDate = @ResolvedDate, Status = @Status
WHERE Id = @id;",
new
{
dbTask.Id,
dbTask.Name,
dbTask.CreatedBy,
dbTask.CreatedDate,
dbTask.Resolver,
dbTask.ResolvedDate,
dbTask.Status
});
}
}
public TaskEx AddTask(TaskEx task)
{
task.ResolvedDate = (task.Status == "2") ? DateTime.Now : (DateTime?)null;
// Dapper - Insert
using (var conn = ConnectionFactory.GetOpenConnection())
{
conn.Execute(@"INSERT INTO Tasks(Name, CreatedBy, CreatedDate, Resolver, ResolvedDate, Status)
VALUES (@Name, @CreatedBy, @CreatedDate, @Resolver, @ResolvedDate, @Status);",
new
{
task.Name,
task.CreatedBy,
task.CreatedDate,
task.Resolver,
task.ResolvedDate,
task.Status
});
task.Id = (int)conn.Query(@"SELECT @@IDENTITY AS Id").First().Id;
return task;
}
}