public async Task <data.User> Update(data.ToDoDbContext db, UserUpdate update)
{
try
{
var userToUpdate = await db.Users.FirstOrDefaultAsync(w => w.UserId == update.UserId);
userToUpdate.Email = update.Email;
userToUpdate.FirstName = update.FirstName;
userToUpdate.MobileNumber = update.MobileNumber;
userToUpdate.Surname = update.Surname;
userToUpdate.Title = update.Title;
userToUpdate.UserId = update.UserId;
return(userToUpdate);
}
catch (Exception e)
{
LogFactory.GetLogger().Log(LogLevel.Error, e);
return(null);
}
}
public async Task <data.User> Add(data.ToDoDbContext db, UserAdd add)
{
try
{
var newUser = new data.User();
newUser.Email = add.Email;
newUser.FirstName = add.FirstName;
newUser.MobileNumber = add.MobileNumber;
newUser.Surname = add.Surname;
newUser.Title = add.Title;
// Add references to parent Classes
db.Users.Add(newUser);
return(newUser);
}
catch (Exception e)
{
LogFactory.GetLogger().Log(LogLevel.Error, e);
return(null);
}
}
public async Task <data.Task> Update(data.ToDoDbContext db, TaskUpdate update)
{
try
{
var taskToUpdate = await db.Tasks.FirstOrDefaultAsync(w => w.TaskId == update.TaskId);
taskToUpdate.CompletedDate = update.CompletedDate;
taskToUpdate.DueDate = update.DueDate;
taskToUpdate.Name = update.Name;
taskToUpdate.StartedDate = update.StartedDate;
taskToUpdate.Status = update.Status;
taskToUpdate.TaskId = update.TaskId;
return(taskToUpdate);
}
catch (Exception e)
{
LogFactory.GetLogger().Log(LogLevel.Error, e);
return(null);
}
}
public async Task <data.Task> Add(data.ToDoDbContext db, TaskAdd add)
{
try
{
var newTask = new data.Task();
newTask.CompletedDate = add.CompletedDate;
newTask.DueDate = add.DueDate;
newTask.Name = add.Name;
newTask.StartedDate = add.StartedDate;
newTask.Status = add.Status;
// Add references to parent Classes
var userLookup = await db.Users.FirstOrDefaultAsync(w => w.UserId == add.UserUserId);
if (userLookup != null)
{
newTask.User = userLookup;
}
db.Tasks.Add(newTask);
return(newTask);
}
catch (Exception e)
{
LogFactory.GetLogger().Log(LogLevel.Error, e);
return(null);
}
}
public async Task Delete(data.ToDoDbContext db, UserDelete delete)
{
try
{
var userToDelete = await db.Users.FirstOrDefaultAsync(w => w.UserId == delete.UserId);
db.Users.Remove(userToDelete);
}
catch (Exception e)
{
LogFactory.GetLogger().Log(LogLevel.Error, e);
}
}
// Delete Transaction Code
public async Task Delete(UserDelete delete)
{
try
{
using (var db = new data.ToDoDbContext())
{
await Delete(db, delete);
await db.SaveChangesAsync();
}
}
catch (Exception e)
{
LogFactory.GetLogger().Log(LogLevel.Error, e);
}
}
// Update Transaction Code
public async Task <UserView> Update(UserUpdate update)
{
try
{
using (var db = new data.ToDoDbContext())
{
var result = await Update(db, update);
await db.SaveChangesAsync();
return((UserView)result);
}
}
catch (Exception e)
{
LogFactory.GetLogger().Log(LogLevel.Error, e);
return(null);
}
}
// Add Transaction Code
public async Task <TaskView> Add(TaskAdd add)
{
try
{
using (var db = new data.ToDoDbContext())
{
var result = await Add(db, add);
await db.SaveChangesAsync();
return((TaskView)result);
}
}
catch (Exception e)
{
LogFactory.GetLogger().Log(LogLevel.Error, e);
return(null);
}
}
