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