public List <OperationDto> All()
{
using (SpendingsEntities context = new SpendingsEntities())
{
List <Operation> operations = context.Operations.ToList();
return(Mapper.Map <List <Operation>, List <OperationDto> >(operations));
}
}
public List <CurrencyDto> All()
{
using (SpendingsEntities context = new SpendingsEntities())
{
List <Currency> fromDb = context.Currencies.ToList();
return(Mapper.Map <List <Currency>, List <CurrencyDto> >(fromDb));
}
}
public void Update(OperationDto item)
{
Operation operation = Mapper.Map <OperationDto, Operation>(item);
using (SpendingsEntities context = new SpendingsEntities())
{
context.Operations.Attach(operation);
context.Entry(operation).State = EntityState.Modified;
context.SaveChanges();
}
}
public int Add(OperationDto item)
{
using (SpendingsEntities context = new SpendingsEntities())
{
Operation toAdd = Mapper.Map <OperationDto, Operation>(item);
context.Operations.Add(toAdd);
context.SaveChanges();
return(toAdd.Id);
}
}
public CurrencyDto Get(int id)
{
using (SpendingsEntities context = new SpendingsEntities())
{
Currency toGet = context.Currencies.FirstOrDefault(d => d.Id == id);
if (toGet == null)
{
return(null);
}
return(Mapper.Map <Currency, CurrencyDto>(toGet));
}
}
public OperationDto Get(int id)
{
using (SpendingsEntities context = new SpendingsEntities())
{
Operation fromDb = context.Operations.FirstOrDefault(d => d.Id == id);
if (fromDb == null)
{
return(null);
}
return(Mapper.Map <Operation, OperationDto>(fromDb));
}
}
public OperationTypeDto Get(int id)
{
using (SpendingsEntities context = new SpendingsEntities())
{
OperationType fromDb = context.OperationTypes.FirstOrDefault(d => d.Id == id);
return(Mapper.Map <OperationType, OperationTypeDto>(fromDb));
//OperationTypeDto toGet = new OperationTypeDto();
//toGet.Name = fromDb.Name;
//toGet.Description = fromDb.Description;
//toGet.IsCredit = fromDb.IsCredit;
//return toGet;
}
}
public int Add(AccountDto item)
{
using (SpendingsEntities context = new SpendingsEntities())
{
//Account toAdd = new Account();
//toAdd.Name = item.Name;
//toAdd.Currency = item.Currency;
Account toAdd = Mapper.Map <AccountDto, Account>(item);
context.Accounts.Add(toAdd);
context.SaveChanges();
return(toAdd.Id);
}
}
public List <AccountDto> Filter(AccountDtoFilter filter)
{
using (SpendingsEntities context = new SpendingsEntities())
{
IQueryable <Account> query = context.Accounts;
if (filter.IdCurrency != null)
{
query = query.Where(d => d.IdCurrency == filter.IdCurrency);
}
List <Account> accounts = query.ToList();
return(Mapper.Map <List <Account>, List <AccountDto> >(accounts));
}
}
public int Add(OperationTypeDto item)
{
using (SpendingsEntities context = new SpendingsEntities())
{
//OperationType toAdd = new OperationType();
//toAdd.Name = item.Name;
//toAdd.Description = item.Description;
//toAdd.IsCredit = item.IsCredit;
OperationType toAdd = Mapper.Map <OperationType>(item);
context.OperationTypes.Add(toAdd);
context.SaveChanges();
return(toAdd.Id);
}
}
public List <OperationDto> Filter(OperationDtoFilter filter)
{
using (SpendingsEntities context = new SpendingsEntities())
{
IQueryable <Operation> query = context.Operations;
if (filter.IdAccount != null)
{
query = query.Where(d => d.IdAccount == filter.IdAccount.Value);
}
if (filter.IdCategory != null)
{
query = query.Where(d => d.IdOperationType == filter.IdCategory.Value);
}
if (filter.IdCurrency != null)
{
query = query.Where(d => d.Account.IdCurrency == filter.IdCurrency);
}
if (filter.AmmountFrom != null)
{
query = query.Where(d => d.Ammount >= filter.AmmountFrom);
}
if (filter.AmmountTo != null)
{
query = query.Where(d => d.Ammount <= filter.AmmountTo);
}
if (filter.DateFrom != null)
{
query = query.Where(d => d.Date >= filter.DateFrom);
}
if (filter.DateTo != null)
{
query = query.Where(d => d.Date <= filter.DateTo);
}
List <Operation> fromDb = query.ToList();
return(Mapper.Map <List <Operation>, List <OperationDto> >(fromDb));
}
}
public bool Delete(int id)
{
using (SpendingsEntities context = new SpendingsEntities())
{
Operation toDelete = context.Operations.FirstOrDefault(d => d.Id == id);
if (toDelete == null)
{
return(false);
}
context.Operations.Remove(toDelete);
context.SaveChanges();
return(true);
}
}
public AccountDto Get(int id)
{
using (SpendingsEntities context = new SpendingsEntities())
{
Account fromDb = context.Accounts.FirstOrDefault(d => d.Id == id);
if (fromDb == null)
{
return(null);
}
return(Mapper.Map <Account, AccountDto>(fromDb));
//AccountDto result = new AccountDto();
//result.Name = fromDb.Name;
//result.Currency = fromDb.Currency;
//result.Id = fromDb.Id;
//return result;
}
}
public List <OperationTypeDto> All()
{
using (SpendingsEntities context = new SpendingsEntities())
{
List <OperationType> fromDb = context.OperationTypes.ToList();
return(Mapper.Map <List <OperationType>, List <OperationTypeDto> >(fromDb));
//List<OperationTypeDto> dtos = new List<OperationTypeDto>();
//foreach (OperationType item in fromDb)
//{
// OperationTypeDto dto = new OperationTypeDto();
// dto.Name = item.Name;
// dto.Description = item.Description;
// dto.IsCredit = item.IsCredit;
// dtos.Add(dto);
//}
//return dtos;
}
}
public List <AccountDto> All()
{
using (SpendingsEntities context = new SpendingsEntities())
{
List <Account> fromDb = context.Accounts.ToList();
return(Mapper.Map <List <Account>, List <AccountDto> >(fromDb));
//List<AccountDto> result = new List<AccountDto>();
//foreach (Account account in fromDb)
//{
// AccountDto dto = new AccountDto();
// dto.Name = account.Name;
// dto.Currency = account.Currency;
// dto.Id = account.Id;
// result.Add(dto);
//}
//return result;
}
}
public void Update(AccountDto item)
{
//map to Account
Account account = Mapper.Map <AccountDto, Account>(item);
using (SpendingsEntities context = new SpendingsEntities())
{
//find in database and attach to the account object
//account.Id select top 1 from Accounts where Id == account.Id
context.Accounts.Attach(account);
//mark entity as modified
context.Entry(account).State = EntityState.Modified;
//mark certain properties as modified
//context.Entry(account).Property(d => d.Currency).IsModified = true;
//context.Entry(account).Property(d => d.Name).IsModified = true;
//save modifications
context.SaveChanges();
}
}
public void Update(OperationTypeDto item)
{
using (SpendingsEntities context = new SpendingsEntities())
{
OperationType OT = Mapper.Map <OperationTypeDto, OperationType>(item);
context.OperationTypes.Attach(OT);
context.Entry(OT).State = System.Data.Entity.EntityState.Modified;
//OperationType fromDb = context.OperationTypes.FirstOrDefault(d => d.Id == item.Id);
//if (fromDb == null)
//{
// return;
//}
//fromDb.Name = item.Name;
//fromDb.Description = item.Description;
//fromDb.IsCredit = item.IsCredit;
context.SaveChanges();
}
}
