public async Task <bool> Put(long id, JObject json) { try { _invillaContext = new InvillaContext(); var model = JsonConvert.DeserializeObject <LoanViewModel>(json.ToString()); if (model.LoanDateEnd == null) { return(false); } var loanDB = _invillaContext.Loans.Select(x => x).Where(x => x.Id == id).FirstOrDefault(); loanDB.LoanDateEnd = model.LoanDateEnd; var gameDB = _invillaContext.Games.Select(x => x).Where(x => x.Id == loanDB.IdGames).FirstOrDefault(); gameDB.Loaned = false; _invillaContext.Update(gameDB); _invillaContext.Update(loanDB); _invillaContext.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public async Task <LoginViewModel> Post(JObject json) { _invillaContext = new InvillaContext(); try { var model = JsonConvert.DeserializeObject <LoginViewModel>(json.ToString()); model.RegistrationDate = DateTime.Now; model.Password = CryptoConfig.EncryptPassword(model.Password); var Users = new LoginsEntity { FullName = model.FullName, RegistrationDate = model.RegistrationDate, Password = model.Password, IdRole = 1 }; _invillaContext.Add(Users); _invillaContext.SaveChanges(); return(model); } catch (Exception ex) { return(new LoginViewModel { }); } }
/// <summary> /// Persiste os dados da requisição /// </summary> /// <param name="json">Json do Controller</param> /// <returns>Modelo WeatherForeCast</returns> public async Task <FriendsViewModel> Post(JObject json) { _invillaContext = new InvillaContext(); try { var modelo = JsonConvert.DeserializeObject <FriendsViewModel>(json.ToString()); modelo.RegistrationDate = DateTime.Now; var friends = new FriendsEntity { Age = modelo.Age, FullName = modelo.FullName, RegistrationDate = modelo.RegistrationDate }; _invillaContext.Add(friends); _invillaContext.SaveChanges(); return(modelo); } catch (Exception ex) { return(new FriendsViewModel { }); } }
public async Task <bool> Put(long id, JObject json) { try { var model = JsonConvert.DeserializeObject <FriendsViewModel>(json.ToString()); using (_invillaContext = new InvillaContext()) { if (model.Id == null) { return(false); } var friendDB = _invillaContext.Friends.Select(x => x).Where(x => x.Id == id).FirstOrDefault(); friendDB.FullName = model.FullName; _invillaContext.Update(friendDB); _invillaContext.SaveChanges(); return(true); } } catch (Exception ex) { return(false); } }
public async Task <bool> Delete(long id) { try { _invillaContext = new InvillaContext(); _serviceLoans = new ServiceLoans(); if (id == null || await _serviceLoans.GetLoanFriendById(id)) { return(false); } var loginDB = _invillaContext.Logins.Select(x => x).Where(x => x.Id == id).FirstOrDefault(); var roleDB = _invillaContext.Roles.Select(x => x).Where(x => x.Id == loginDB.IdRole).FirstOrDefault(); if (roleDB != null) { return(false); } _invillaContext.Remove(loginDB); _invillaContext.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public async Task <bool> Put(long id, JObject json) { try { var model = JsonConvert.DeserializeObject <RoleViewModel>(json.ToString()); using (_invillaContext = new InvillaContext()) { if (model.Id == null) { return(false); } var roleDB = _invillaContext.Roles.Select(x => x).Where(x => x.Id == id).FirstOrDefault(); roleDB.Role = model.Role; roleDB.RegistrationDate = DateTime.Now; _invillaContext.Update(roleDB); _invillaContext.SaveChanges(); return(true); } } catch (Exception ex) { return(false); } }
public async Task <RoleViewModel> Post(JObject json) { _invillaContext = new InvillaContext(); try { var model = JsonConvert.DeserializeObject <RoleViewModel>(json.ToString()); model.RegistrationDate = DateTime.Now; var role = new RolesEntity { Role = model.Role, RegistrationDate = model.RegistrationDate }; _invillaContext.Add(role); _invillaContext.SaveChanges(); return(model); } catch (Exception ex) { return(new RoleViewModel { }); } }
public async Task <bool> Delete(long id) { try { _invillaContext = new InvillaContext(); if (id == null) { return(false); } var loanDB = _invillaContext.Loans.Select(x => x).Where(x => x.Id == id).FirstOrDefault(); var gameDB = _invillaContext.Games.Select(x => x).Where(x => x.Id == loanDB.IdGames).FirstOrDefault(); gameDB.Loaned = false; _invillaContext.Remove(loanDB); _invillaContext.Update(gameDB); _invillaContext.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public async Task <IEnumerable <GamesViewModel> > Get() { _invillaContext = new InvillaContext(); var lista = _invillaContext.Games.Select(x => new GamesViewModel() { FullGameName = x.FullGameName, Id = x.Id } ).ToList(); return(lista); }
public async Task <IEnumerable <RoleViewModel> > Get() { _invillaContext = new InvillaContext(); var lista = _invillaContext.Roles.Select(x => new RoleViewModel() { Id = x.Id, Role = x.Role, } ).ToList(); return(lista); }
public async Task <IEnumerable <LoginViewModel> > Get() { _invillaContext = new InvillaContext(); var lista = _invillaContext.Logins.Select(x => new LoginViewModel() { Id = x.Id, FullName = x.FullName } ).ToList(); return(lista); }
public async Task <object> GetRoleById(long id) { try { _invillaContext = new InvillaContext(); var roleDB = _invillaContext.Roles.Select(x => x).Where(x => x.Id == id).FirstOrDefault(); return(roleDB); } catch (Exception ex) { return(false); } }
public async Task <IEnumerable <FriendsViewModel> > Get() { _invillaContext = new InvillaContext(); var lista = _invillaContext.Friends.Select(x => new FriendsViewModel() { Id = x.Id, FullName = x.FullName, Age = x.Age } ).ToList(); return(lista); }
public async Task <IEnumerable <LoanViewModel> > Get() { _invillaContext = new InvillaContext(); var lista = _invillaContext.Loans.Select(x => new LoanViewModel() { Friend = _invillaContext.Friends.Where(y => y.Id == x.Friend.Id).FirstOrDefault().FullName, Game = _invillaContext.Games.Where(y => y.Id == x.Game.Id).FirstOrDefault().FullGameName, Id = x.Id, LoanDateBegin = x.LoanDateBegin, LoanDateEnd = x.LoanDateEnd } ).ToList(); return(lista); }
public async Task <bool> GetLoanGameById(long id) { try { _invillaContext = new InvillaContext(); var lista = _invillaContext.Loans.Where(x => x.IdGames == id).ToList(); if (lista.Count > 0) { return(true); } return(false); } catch (Exception ex) { return(false); } }
public async Task <bool> Renew(long id) { try { _invillaContext = new InvillaContext(); if (id == null) { return(false); } var loanDB = _invillaContext.Loans.Select(x => x).Where(x => x.Id == id).FirstOrDefault(); loanDB.LoanDateBegin = DateTime.Now; _invillaContext.Update(loanDB); _invillaContext.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public async Task <bool> Delete(long id) { try { _invillaContext = new InvillaContext(); _serviceLoans = new ServiceLoans(); if (id == null || await _serviceLoans.GetLoanGameById(id)) { return(false); } var gameDB = _invillaContext.Games.Select(x => x).Where(x => x.Id == id).FirstOrDefault(); _invillaContext.Remove(gameDB); _invillaContext.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public async Task <bool> GetLoginByName(JObject json) { try { _invillaContext = new InvillaContext(); var model = JsonConvert.DeserializeObject <LoginViewModel>(json.ToString()); var loginDB = _invillaContext.Logins.Where(x => x.FullName == model.FullName).FirstOrDefault(); var roleDB = _invillaContext.Roles.Where(x => x.Id == model.IdRole).FirstOrDefault(); var role = (string.IsNullOrEmpty(roleDB.Role)) ? "admin" : roleDB.Role; model.Password = CryptoConfig.EncryptPassword(model.Password); if (model.FullName == loginDB.FullName && model.Password == loginDB.Password) { var claims = new List <Claim>() { new Claim("UserLoan", model.FullName), new Claim("Password", model.Password), new Claim("Role", role) }; var token = JwtTokenUtils.GenerateInvillaUserToken(claims); loginDB.Token = token; _invillaContext.Update(loginDB); _invillaContext.SaveChanges(); return(true); } return(false); } catch (Exception ex) { return(false); } }
public async Task <bool> Delete(long id) { try { _invillaContext = new InvillaContext(); var roleDB = _invillaContext.Roles.Select(x => x).Where(x => x.Id == id).FirstOrDefault(); var loginDB = _invillaContext.Logins.Select(x => x).Where(x => x.IdRole == id).FirstOrDefault(); if (loginDB != null) { return(false); } _invillaContext.Remove(roleDB); _invillaContext.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public async Task <bool> Post(LoanViewModel model) { _invillaContext = new InvillaContext(); try { foreach (var game in model.IdGame) { if (await GetLoanGameById((long)game)) { return(false); } var loans = new LoansEntity { IdFriend = (long)model.IdFriend.FirstOrDefault(), IdGames = (long)game, LoanDateBegin = (DateTime)model.LoanDateBegin }; //Set Game Loaned var gameDB = _invillaContext.Games.Select(x => x).Where(x => x.Id == game).FirstOrDefault(); gameDB.Loaned = true; _invillaContext.Update(gameDB); _invillaContext.Add(loans); _invillaContext.SaveChanges(); } return(true); } catch (Exception ex) { return(false); } }