public bool Delete(List <int> ids) { //try //{ using (FinanceEntities context = factory.CreateContext()) { //context.Cashflows.Delete(e=>ids.Contains(e.CashflowId)); foreach (var id in ids) { var ef = new Cashflow() { CashflowId = id }; context.Entry(ef).State = EntityState.Deleted; } // deletes are cascaded to CashflowBankAccount context.SaveChanges(); } //} //catch (DbEntityValidationException e) //{ // CommonRepository.HandleDbEntityValidationException(e); //} return(true); }
public bool Delete(Core.Entities.BankAccount entity) { var ef = mapper.Map <BankAccount>(entity); using (FinanceEntities context = factory.CreateContext()) { context.Entry(ef).State = EntityState.Deleted; context.SaveChanges(); } return(true); }
public bool Update(Core.Entities.BankAccount entity) { var ef = mapper.Map <BankAccount>(entity); using (FinanceEntities context = factory.CreateContext()) { context.Entry(ef).State = EntityState.Modified; context.SaveChanges(); } //read back columns which may have changed entity.RecordUpdatedDateTime = ef.RecordUpdatedDateTime; return(true); }
public bool Delete(Core.Entities.BalanceDate entity) { var ef = mapper.Map <BalanceDate>(entity); //need to delete children to prevent EF FK error ef.BalanceDateBankAccounts.Clear(); using (FinanceEntities context = factory.CreateContext()) { context.Entry(ef).State = EntityState.Deleted; // deletes are cascaded to BalanceBankAccount context.SaveChanges(); } return(true); }
public bool Delete(List <int> ids) { using (FinanceEntities context = factory.CreateContext()) { foreach (var id in ids) { var ef = new BankAccount() { BankAccountId = id }; context.Entry(ef).State = EntityState.Deleted; } context.SaveChanges(); } return(true); }
public int Add(Core.Entities.BankAccount entity) { int id = 0; var ef = mapper.Map <BankAccount>(entity); using (FinanceEntities context = factory.CreateContext()) { context.Entry(ef).State = EntityState.Added; context.SaveChanges(); } //read back columns which may have changed entity.BankAccountId = ef.BankAccountId; entity.RecordCreatedDateTime = ef.RecordCreatedDateTime; entity.RecordUpdatedDateTime = ef.RecordUpdatedDateTime; id = ef.BankAccountId; return(id); }
public int Add(Core.Entities.Cashflow entity) { int id = 0; //try //{ var ef = mapper.Map <Cashflow>(entity); using (FinanceEntities context = factory.CreateContext()) { context.Entry(ef).State = EntityState.Added; context.SaveChanges(); } //read back columns which may have changed entity.CashflowId = ef.CashflowId; entity.RecordCreatedDateTime = ef.RecordCreatedDateTime; entity.RecordUpdatedDateTime = ef.RecordUpdatedDateTime; int i = 0; foreach (var cba in ef.CashflowBankAccounts) { if (entity.CashflowBankAccounts.Count <= i) { break; } var e = entity.CashflowBankAccounts[i]; e.CashflowBankAccountId = cba.CashflowBankAccountId; e.RecordCreatedDateTime = cba.RecordCreatedDateTime; i++; } id = ef.CashflowId; //} //catch (DbEntityValidationException e) //{ // CommonRepository.HandleDbEntityValidationException(e); //} return(id); }
public bool Delete(Core.Entities.Cashflow entity) { //try //{ var ef = mapper.Map <Cashflow>(entity); ef.CashflowBankAccounts.Clear(); using (FinanceEntities context = factory.CreateContext()) { context.Entry(ef).State = EntityState.Deleted; // deletes are cascaded to CashflowBankAccount context.SaveChanges(); } //} //catch (DbEntityValidationException e) //{ // CommonRepository.HandleDbEntityValidationException(e); //} return(true); }
public int Add(Core.Entities.BalanceDate entity) { int id = 0; var ef = mapper.Map <BalanceDate>(entity); using (FinanceEntities context = factory.CreateContext()) { context.Entry(ef).State = EntityState.Added; context.SaveChanges(); } //read back columns which may have changed entity.BalanceDateId = ef.BalanceDateId; entity.RecordCreatedDateTime = ef.RecordCreatedDateTime; //entity.RecordUpdatedDateTime = ef.RecordUpdatedDateTime; int i = 0; foreach (var cba in ef.BalanceDateBankAccounts) { if (entity.BalanceDateBankAccounts.Count <= i) { break; } var e = entity.BalanceDateBankAccounts[i]; e.BalanceDateBankAccountId = cba.BalanceDateBankAccountId; e.RecordCreatedDateTime = cba.RecordCreatedDateTime; i++; } id = ef.BalanceDateId; return(id); }
public bool Update(Core.Entities.Cashflow entity) { //throw new Exception("testing"); //try //{ var ef = mapper.Map <Cashflow>(entity); using (FinanceEntities context = factory.CreateContext()) { // read in children var cbas = from b in context.CashflowBankAccounts where b.CashflowId == ef.CashflowId select b; foreach (var cba in cbas) { if (ef.CashflowBankAccounts.Count(a => a.CashflowBankAccountId == cba.CashflowBankAccountId) == 0) { context.Entry(cba).State = EntityState.Deleted; } else { context.Entry(cba).State = EntityState.Detached; } } foreach (var cba in ef.CashflowBankAccounts) { if (cba.CashflowBankAccountId > 0) { context.Entry(cba).State = EntityState.Modified; } else { context.Entry(cba).State = EntityState.Added; } } context.Entry(ef).State = EntityState.Modified; var s = ShowEntityStates(context); context.SaveChanges(); } //read back data which may have changed entity.RecordUpdatedDateTime = ef.RecordUpdatedDateTime; int i = 0; foreach (var cba in ef.CashflowBankAccounts) { if (entity.CashflowBankAccounts.Count <= i) { break; } var e = entity.CashflowBankAccounts[i]; if (e.CashflowBankAccountId == 0) { e.CashflowBankAccountId = cba.CashflowBankAccountId; e.RecordCreatedDateTime = cba.RecordCreatedDateTime; } i++; } //} //catch (DbEntityValidationException e) //{ // CommonRepository.HandleDbEntityValidationException(e); //} return(true); }
public bool Update(Core.Entities.BalanceDate entity) { var ef = mapper.Map <BalanceDate>(entity); using (FinanceEntities context = factory.CreateContext()) { // read in children var cbas = from b in context.BalanceDateBankAccounts where b.BalanceDateId == ef.BalanceDateId select b; foreach (var cba in cbas) { if (ef.BalanceDateBankAccounts.Count(a => a.BalanceDateBankAccountId == cba.BalanceDateBankAccountId) == 0) { context.Entry(cba).State = EntityState.Deleted; } else { context.Entry(cba).State = EntityState.Detached; } } foreach (var cba in ef.BalanceDateBankAccounts) { if (cba.BalanceDateBankAccountId > 0) { context.Entry(cba).State = EntityState.Modified; } else { context.Entry(cba).State = EntityState.Added; } } context.Entry(ef).State = EntityState.Modified; var s = ShowEntityStates(context); context.SaveChanges(); } //read back data which may have changed //entity.RecordUpdatedDateTime = ef.RecordUpdatedDateTime; int i = 0; foreach (var cba in ef.BalanceDateBankAccounts) { if (entity.BalanceDateBankAccounts.Count <= i) { break; } var e = entity.BalanceDateBankAccounts[i]; e.BalanceDateBankAccountId = cba.BalanceDateBankAccountId; e.RecordCreatedDateTime = cba.RecordCreatedDateTime; i++; } return(true); }