public User Details(int id)
{
using (var db = new FlusBankEntities())
{
return(db.Users.Where(us => us.Id == id).FirstOrDefault());
}
}
public List <Transaction> TransactionsList()
{
using (var db = new FlusBankEntities())
{
return(db.Transactions.ToList());
}
}
public List <User> UserList()
{
using (var db = new FlusBankEntities())
{
return(db.Users.ToList());
}
}
public async Task Create(BanksOperation BankOperation)
{
using (var db = new FlusBankEntities())
{
int countOp = db.BanksOperations.Where(op => op.Name == BankOperation.Name).Count();
if (countOp == 0)
{
int id = 0;
while (BankOperation.Id == 0)
{
var currentId = db.BanksOperations.Where(op => op.Id == id).FirstOrDefault();
if (currentId == null)
{
BankOperation.Id = id;
}
id = Utilities.Utilities.generateIndex(id);
}
db.BanksOperations.Add(BankOperation);
await db.SaveChangesAsync();
}
else
{
throw new Exception("La operación ya existe");
}
}
}
public List <BanksOperation> BanksOperationsList()
{
using (var db = new FlusBankEntities())
{
return(db.BanksOperations.ToList());
}
}
public BanksOperation Details(int id)
{
using (var db = new FlusBankEntities())
{
return(db.BanksOperations.Where(op => op.Id == id).FirstOrDefault());
}
}
public BankAccount Details(int id)
{
using (var db = new FlusBankEntities())
{
return(db.BankAccounts.Where(acc => acc.Id == id).FirstOrDefault());
}
}
public User Login(string DNI, string Password)
{
using (var db = new FlusBankEntities())
{
var User = (from d in db.Users
where d.DNI == DNI.Trim()
select d).FirstOrDefault();
if (User == null)
{
throw new Exception("El identificador no existe");
}
Password = Utilities.Utilities.setKeySHA1(Password.Trim());
User = (from d in db.Users
where d.DNI == DNI.Trim() && d.PasswordHash == Password
select d).FirstOrDefault();
if (User == null)
{
throw new Exception("Contraseña incorrecta");
}
return(User);
}
}
public List <BankAccount> BankAccountList()
{
using (var db = new FlusBankEntities())
{
return(db.BankAccounts.ToList());
}
}
public long GetExpenses(string code)
{
List <Transaction> list = GetAccountTransactions(code);
using (var db = new FlusBankEntities())
{
int accountId = (from account in db.BankAccounts
where account.Code.ToString() == code
select account.Id).FirstOrDefault();
long expenses = 0;
foreach (Transaction transaction in list)
{
if (transaction.BankAccointId == accountId)
{
expenses += Convert.ToInt64(transaction.Amount);
}
else
{
continue;
}
}
return(expenses);
}
}
public async Task Create(User user)
{
using (var db = new FlusBankEntities())
{
db.Users.Add(user);
await db.SaveChangesAsync();
}
}
public User GetUser(string iden)
{
using (var db = new FlusBankEntities())
{
var user = db.Users.Where(usr => usr.DNI == iden).FirstOrDefault();
return(user);
}
}
public async Task Edit(BankAccount account)
{
using (var db = new FlusBankEntities())
{
var oldAccount = db.BankAccounts.Where(acc => acc.Id == account.Id).FirstOrDefault();
oldAccount.CurrencyId = account.CurrencyId;
await db.SaveChangesAsync();
}
}
public int GetRol(string Dni)
{
using (var db = new FlusBankEntities())
{
return((from d in db.Users
where d.DNI == Dni
select d.Rol).FirstOrDefault());
}
}
private string GetAccountCode(string account)
{
using (var db = new FlusBankEntities())
{
return((from acc in db.BankAccounts
where acc.Id.ToString() == account
select acc.Code).FirstOrDefault());
}
}
public async Task Delete(int id)
{
using (var db = new FlusBankEntities())
{
var removeOperation = db.BanksOperations.Where(op => op.Id == id).FirstOrDefault();
db.BanksOperations.Remove(removeOperation);
await db.SaveChangesAsync();
}
}
public BankAccount GetAccount(int id)
{
using (var db = new FlusBankEntities())
{
return((from account in db.BankAccounts
where account.Id == id
select account).FirstOrDefault());
}
}
//public List<BankAccount> GetBanksAccounts(List<ICollection<BankAccount>> accounts)
//{
// List<BankAccount> listAccount = new List<BankAccount>();
// foreach(var account in accounts.ToList())
// {
// var code = account.Select(db => db.Code).FirstOrDefault();
// var aux = code.Substring(code.Length - 4, 4);
// }
// return listAccount;
//}
public User GetUser(int UserId)
{
using (var db = new FlusBankEntities())
{
return((from user in db.Users
where user.Id == UserId
select user).FirstOrDefault());
}
}
public List <ICollection <BankAccount> > GetBanksUserAccounts(string identity)
{
using (var db = new FlusBankEntities())
{
return((from userFilter in db.Users
where userFilter.DNI == identity
select userFilter.BankAccounts).ToList());
}
}
public async Task Edit(BanksOperation operationEdit)
{
using (var db = new FlusBankEntities())
{
var oldOperation = db.BanksOperations.Where(op => op.Id == operationEdit.Id).FirstOrDefault();
oldOperation.Description = operationEdit.Description;
await db.SaveChangesAsync();
}
}
public async Task Delete(int id)
{
using (var db = new FlusBankEntities())
{
var account = db.BankAccounts.Where(acc => acc.Id == id).FirstOrDefault();
db.BankAccounts.Remove(account);
await db.SaveChangesAsync();
}
}
public Transaction Details(int id)
{
using (var db = new FlusBankEntities())
{
var dbPull = db.Transactions.Where(tr => tr.Id == id).FirstOrDefault();
var nameOperation = db.BanksOperations.Where(op => op.Id == dbPull.BankOperationId).FirstOrDefault();
var codeAccount = db.BankAccounts.Where(op => op.Id == dbPull.BankAccointId).FirstOrDefault();
dbPull.OperationName = nameOperation.Name;
dbPull.IBAN = codeAccount.Code;
return(dbPull);
}
}
public bool ExistsAccount(int id)
{
using (var db = new FlusBankEntities())
{
var account = db.BankAccounts.Where(acc => acc.Id == id).FirstOrDefault();
if (account == null)
{
return(false);
}
return(true);
}
}
public bool ValidateCode(string code)
{
using (var db = new FlusBankEntities())
{
var userCode = db.BankAccounts.Where(acc => acc.Code == code);
if (userCode.Count() > 0)
{
return(false);
}
return(true);
}
}
public bool ComprobateIdentify(string dni)
{
using (var db = new FlusBankEntities())
{
var userDni = db.Users.Where(usr => usr.DNI == dni);
if (userDni.Count() > 0)
{
return(true);
}
return(false);
}
}
public List <BankAccount> Searcher(string identity)
{
using (var db = new FlusBankEntities())
{
int idUser = (from user in db.Users
where user.DNI == identity
select user.Id).FirstOrDefault();
return((from account in db.BankAccounts
where account.UserId == idUser
select account).ToList());
}
}
public List <Transaction> GetAccountTransactions(string code)
{
using (var db = new FlusBankEntities())
{
var id = (from idAccount in db.BankAccounts
where idAccount.Code == code
select idAccount.Id).FirstOrDefault();
return((from transactions in db.Transactions
where transactions.Addressee == code || transactions.BankAccointId == id
select transactions).ToList());
}
}
public async Task Create(BankAccount account)
{
using (var db = new FlusBankEntities())
{
var userPropierty = (from user in db.Users
where user.DNI == account.User.DNI
select user).FirstOrDefault();
userPropierty.BankAccounts.Add(account);
account.User = null;
db.BankAccounts.Add(account);
await db.SaveChangesAsync();
}
}
public void ComprobateAccountWithAddress(string address)
{
using (var db = new FlusBankEntities())
{
var query = (from account in db.BankAccounts
where account.Code == address
select account.Id).FirstOrDefault();
if (query == 0)
{
throw new Exception("La cuenta destino no existe");
}
}
}
public bool Exist(int id)
{
using (var db = new FlusBankEntities())
{
var Operation = (from oper in db.BanksOperations
where oper.Id == id
select oper).FirstOrDefault();
if (Operation == null)
{
return(false);
}
return(true);
}
}
