public bool UpdateUserMstr(USER_MSTR_DTO dto) { try { if (ReferenceEquals(context, null)) { context = new CalfuEntities(); } USER_MSTR userMstr = context.USER_MSTR.Where(x => x.USER_ID.Equals(dto.USER_ID)).SingleOrDefault(); if (!ReferenceEquals(null, userMstr)) { userMstr.USER_NAME = dto.USER_NAME; userMstr.USER_PASS = dto.USER_PASS; userMstr.USER_NICK = dto.USER_NICK; context.SaveChanges(); } context.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public bool DeleteUserMstrRepository(int id) { try { if (ReferenceEquals(context, null)) { context = new CalfuEntities(); } USER_MSTR userMstr = context.USER_MSTR.Where(x => x.USER_ID.Equals(id)).SingleOrDefault(); if (!ReferenceEquals(userMstr, null)) { context.USER_MSTR.Remove(userMstr); return(true); } else { return(false); } } catch (Exception ex) { return(false); } }
public bool LoginByName(string nick, string pass) { try { if (ReferenceEquals(context, null)) { context = new CalfuEntities(); } USER_MSTR userMstr = context.USER_MSTR.Where(x => x.USER_NICK.Equals(nick) && x.USER_PASS.Equals(pass)).FirstOrDefault(); if (ReferenceEquals(userMstr, null)) { return(false); } else { return(true); } } catch (Exception ex) { return(false); } }
public bool CreateUserMstr(USER_MSTR_DTO dto) { try { var _userMstr = new USER_MSTR(); _userMstr.USER_NAME = dto.USER_NAME; _userMstr.USER_PASS = dto.USER_PASS; _userMstr.USER_NICK = dto.USER_NICK; context.USER_MSTR.Add(_userMstr); context.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public bool ExistUserMstrRepository(int id) { if (ReferenceEquals(context, null)) { context = new CalfuEntities(); } USER_MSTR userMstr = context.USER_MSTR.Where(x => x.USER_ID.Equals(id)).SingleOrDefault(); if (!ReferenceEquals(userMstr, null)) { return(true); } else { return(false); } }
public USER_MSTR_DTO GetUserMstrRepository(int id) { try { USER_MSTR_DTO getUserMstrDto = new USER_MSTR_DTO(); _userMstr = context.USER_MSTR.Where(x => x.USER_ID.Equals(id)).FirstOrDefault(); getUserMstrDto.USER_ID = _userMstr.USER_ID; getUserMstrDto.USER_NAME = _userMstr.USER_NAME; getUserMstrDto.USER_PASS = _userMstr.USER_PASS; getUserMstrDto.USER_NICK = _userMstr.USER_NICK; //OBRA_MSTR_DTO getObraMstrDto = context.OBRA_MSTR.Where(x => x.OBRA_ID.Equals(id)).ProjectTo<OBRA_MSTR_DTO>().FirstOrDefault(); return(getUserMstrDto); } catch (Exception ex) { return(null); } }