public bool Edit(int userId, UserViewModel user) { try { if (userId != user.UserId) { return(false); } using (var context = new TrainingDbEntities()) { var userTb = _mapper.Map <UsersTbl>(user); context.Entry(userTb).State = EntityState.Modified; try { context.SaveChanges(); } catch (Exception ex) { throw new ApplicationException("Error in UserService/Edit - SaveChanges Operation:", ex); } return(true); } } catch (Exception ex) { throw new ApplicationException("Error in UserService/Edit:", ex); } }
public UserViewModel GetUser(int userId) { try { using (var context = new TrainingDbEntities()) { var userRes = context.UsersTbls.Find(userId); if (userRes == null) { return(null); } var user = _mapper.Map <UserViewModel>(userRes); return(user); } } catch (Exception ex) { throw new ApplicationException("Error in UserService/GetUser:", ex); } }
public UserViewModel Create(UserViewModel user) { try { using (var context = new TrainingDbEntities()) { var p = context.UsersTbls.OrderByDescending(c => c.UserId).FirstOrDefault(); var newId = (p?.UserId ?? 0) + 1; //apply new id user.UserId = newId; var newUUser = _mapper.Map <UsersTbl>(user); context.UsersTbls.Add(newUUser); context.SaveChanges(); } return(user); } catch (Exception ex) { throw new ApplicationException("Error in UserService/Create:", ex); } }
public List <UserViewModel> GetUsersList() { try { List <UsersTbl> list; using (var context = new TrainingDbEntities()) { list = context.UsersTbls.ToList(); } if (list.Any()) { var usersList = _mapper.Map <IEnumerable <UserViewModel> >(list).ToList(); return(usersList); } return(null); } catch (Exception ex) { throw new ApplicationException("Error in UserService/GetUsersList:", ex); } }
public UserViewModel Delete(int userId) { try { using (var context = new TrainingDbEntities()) { var userToDelete = context.UsersTbls.Find(userId); if (userToDelete == null) { return(null); } context.UsersTbls.Remove(userToDelete); context.SaveChanges(); var user = _mapper.Map <UserViewModel>(userToDelete); return(user); } } catch (Exception ex) { throw new ApplicationException("Error in UserService/Delete:", ex); } }