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); } }