public async Task <IEnumerable <UserModel> > GetAllUsers() { try { using (YacEntities context = new YacEntities()) { List <User> lstUser = await context.User.AsNoTracking().ToListAsync(); List <UserModel> lstUserModel = new List <UserModel>(); foreach (var item in lstUser) { UserModel UserModel = new UserModel() { Id = item.Id, UserName = item.UserName }; lstUserModel.Add(UserModel); } return(lstUserModel); } } catch (Exception ex) { throw new Exception(ex.Message); } }
public void SaveResponse(UserResponseModel userResponse) { try { using (YacEntities context = new YacEntities()) { var dbUserResponse = context.Set <UserResponse>(); dbUserResponse.Add(new UserResponse { IdUser = userResponse.IdUser, DateResponse = userResponse.DateResponse, Response = userResponse.Response }); context.SaveChanges(); } } catch (Exception ex) { throw new Exception(ex.Message); } }
public bool DeleteRegister(int idRegister) { try { using (YacEntities context = new YacEntities()) { var register = new UserResponse { Id = idRegister }; context.UserResponse.Attach(register); context.UserResponse.Remove(register); context.SaveChanges(); } return(true); } catch (Exception ex) { throw new Exception(ex.Message); } }
public IEnumerable <UserResponseModel> GetAllUsersFilter(string userName, int respMin, int respMax) { try { List <UserResponseModel> resultQuery = new List <UserResponseModel>(); using (YacEntities context = new YacEntities()) { if (string.IsNullOrEmpty(userName) && respMin == 0 && respMax == 0) { resultQuery = (from ur in context.UserResponse join u in context.User on ur.IdUser equals u.Id select new UserResponseModel { Id = ur.Id, IdUser = ur.IdUser, UserName = u.UserName, Response = ur.Response, DateResponse = ur.DateResponse }).ToList(); } else if (!string.IsNullOrEmpty(userName) && respMin == 0 && respMax == 0) { resultQuery = (from ur in context.UserResponse join u in context.User on ur.IdUser equals u.Id where u.UserName == userName select new UserResponseModel { Id = ur.Id, IdUser = ur.IdUser, UserName = u.UserName, Response = ur.Response, DateResponse = ur.DateResponse }).ToList(); } else if (string.IsNullOrEmpty(userName) && (respMin > 0 || respMax > 0)) { resultQuery = (from ur in context.UserResponse join u in context.User on ur.IdUser equals u.Id where (ur.Response >= respMin && ur.Response <= respMax) select new UserResponseModel { Id = ur.Id, IdUser = ur.IdUser, UserName = u.UserName, Response = ur.Response, DateResponse = ur.DateResponse }).ToList(); } else if (!string.IsNullOrEmpty(userName) && (respMin > 0 || respMax > 0)) { resultQuery = (from ur in context.UserResponse join u in context.User on ur.IdUser equals u.Id where u.UserName == userName && (ur.Response >= respMin && ur.Response <= respMax) select new UserResponseModel { Id = ur.Id, IdUser = ur.IdUser, UserName = u.UserName, Response = ur.Response, DateResponse = ur.DateResponse }).ToList(); } } return(resultQuery); } catch (Exception ex) { throw new Exception(ex.Message); } }