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