public string EditBudgetItemList(List <BudgetListItem> CurrentBudgetItems, Guid CustomerId) { try { var Context = new Central(); Guid BudgetId = GetBudgetId(CustomerId); foreach (var x in CurrentBudgetItems) { Guid BudgListItemId = Guid.Parse(x.BudgetListItemId); if (HasBudgetItemId(BudgetId, BudgListItemId)) { var ListItemToUpdate = (from b in Context.BudgetItems where b.BudgetItemId == BudgListItemId && b.BudgetId == BudgetId select b).FirstOrDefault(); if (ListItemToUpdate.BudgetItemType == 1) { ListItemToUpdate.BudgetItemName = x.BudgetListItemName; } ListItemToUpdate.BudgetItemAmount = x.BudgetListItemAmount; ListItemToUpdate.BudgetItemFrequency = x.BudgetListItemFrequency; ListItemToUpdate.UpdateDate = DateTime.Now; Context.Entry(ListItemToUpdate).State = System.Data.Entity.EntityState.Modified; } } Context.SaveChanges(); string Status = "Success"; return(Status); } catch (Exception e) { return(e.ToString()); } }
//Save User Employers public Boolean SaveUserEmployers(UserEmployerLists MyUserEmployers, Guid WizardId, Central Context) { try { if (MyUserEmployers.ExistingEmployers != null) { foreach (var x in MyUserEmployers.ExistingEmployers) { var EmployerInstanceToUpdate = (from b in Context.WizardEmployers where b.EmployerId == x.UserEmployerId select b).FirstOrDefault(); if (EmployerInstanceToUpdate.EmployerName != x.UserEmployerName) { EmployerInstanceToUpdate.EmployerName = x.UserEmployerName; EmployerInstanceToUpdate.UpdatedDate = DateTime.Now; Context.Entry(EmployerInstanceToUpdate).State = System.Data.Entity.EntityState.Modified; } } } if (MyUserEmployers.NewEmployers != null) { foreach (var x in MyUserEmployers.NewEmployers) { if (x.UserEmployerName != null) { WizardEmployer MyWizardEmployer = new WizardEmployer(); MyWizardEmployer.EmployerId = Guid.NewGuid(); MyWizardEmployer.WizardId = WizardId; MyWizardEmployer.EmployerName = x.UserEmployerName; MyWizardEmployer.EmployerType = x.UserEmployerType; MyWizardEmployer.EmployerUser = x.UserEmployerUser; MyWizardEmployer.CreationDate = DateTime.Now; MyWizardEmployer.UpdatedDate = DateTime.Now; Context.WizardEmployers.Add(MyWizardEmployer); } } } Context.SaveChanges(); return(true); } catch (Exception e) { Console.WriteLine(e.ToString()); return(false); } }
public string RemoveSplitTransaction(RemoveSplitTransaction SplitToEdit) { try { Guid CustomerId = Guid.Parse(User.Identity.GetUserId()); Guid TransactionItemId = Guid.Parse(SplitToEdit.TransactionId); var Context = new Central(); var TEdit = (from b in Context.TransactionItems where b.CustomerId == CustomerId && b.TransactionItemId == TransactionItemId select b).FirstOrDefault(); TEdit.TransactionItemType = 1; Context.Entry(TEdit).State = System.Data.Entity.EntityState.Modified; Context.SaveChanges(); return("Success"); } catch (Exception e) { return(e.ToString()); } }
public string AddTransactionSplits(Guid CustomerId, List <UserTransaction> SplitsToAdd) { try { var Context = new Central(); foreach (var x in SplitsToAdd) { if (x.TransactionAmount != 0) { TransactionItem NewSplitTransaction = new TransactionItem(); NewSplitTransaction.CustomerId = CustomerId; NewSplitTransaction.TransactionItemId = Guid.NewGuid(); NewSplitTransaction.TransactionItemDate = x.TransactionDate; NewSplitTransaction.TransactionItemName = x.TransactionName; NewSplitTransaction.TransactionItemAmount = x.TransactionAmount; NewSplitTransaction.TransactionItemMemo = x.TransactionMemo; NewSplitTransaction.PrimaryTransactionItem = x.PrimaryTransactionId; NewSplitTransaction.TransactionItemBudgetItem = x.BudgetItemId; NewSplitTransaction.CreationDate = DateTime.Now; NewSplitTransaction.UpdateDate = DateTime.Now; NewSplitTransaction.TransactionItemType = 4; Context.TransactionItems.Add(NewSplitTransaction); var PrimaryTransactionToChange = (from b in Context.TransactionItems where b.TransactionItemId == x.PrimaryTransactionId && b.CustomerId == CustomerId select b).FirstOrDefault(); PrimaryTransactionToChange.TransactionItemType = 3; PrimaryTransactionToChange.UpdateDate = DateTime.Now; Context.Entry(PrimaryTransactionToChange).State = System.Data.Entity.EntityState.Modified; } } Context.SaveChanges(); return("Success"); } catch (Exception e) { return(e.ToString()); } }
public Boolean SaveWizardInstance(WizardViewModel MyWizardViewModel, Guid CustomerId) { try { Guid BudgetId = GetBudgetId(CustomerId); var Context = new Central(); var MyWizardInstance = (from b in Context.WizardInstances where b.BudgetId == BudgetId select b).FirstOrDefault(); Guid WizardId = MyWizardInstance.WizardId; MyWizardInstance.Position = MyWizardViewModel.WizardPosition; MyWizardInstance.PrevPosition = MyWizardViewModel.WizardPrevPosition; //Info MyWizardInstance.PrimaryName = MyWizardViewModel.PrimaryName; MyWizardInstance.SpouseName = MyWizardViewModel.SpouseName; //Answers MyWizardInstance.InitialPurpose = MyWizardViewModel.Answers.InitialPurpose; MyWizardInstance.SubsequentPurpose = MyWizardViewModel.Answers.SubsequentPurpose; MyWizardInstance.MostImportantBudgetItem = MyWizardViewModel.Answers.MostImportantItem; MyWizardInstance.UpdatedDate = DateTime.Now; //Save Changes to Wizard Instance in Database Context.Entry(MyWizardInstance).State = System.Data.Entity.EntityState.Modified; Context.SaveChanges(); if (MyWizardViewModel.BudgetItems != null) { //Save any new Budget Items foreach (var x in MyWizardViewModel.BudgetItems.NewBudgetItems) { if (x.BudgetListItemAmount > 0) { var NewItemStatus = EnterNewBudgetItem(x, CustomerId, "0"); } } //Save any Existing Budget Items var ExistingItemStatus = EditBudgetItemList(MyWizardViewModel.BudgetItems.ExistingBudgetItems, CustomerId); } //Save Employers if (MyWizardViewModel.UserEmployers != null) { Boolean SavedEmployers = SaveUserEmployers(MyWizardViewModel.UserEmployers, WizardId, Context); } return(true); } catch (Exception e) { Console.Write(e.ToString()); return(false); } }
public string EditTransactionsInDatabase(Guid CustomerId, List <UserTransaction> TransactionItems) { string result = ""; try { var Context = new Central(); Boolean Modified = false; Boolean ChangeExists = false; foreach (var x in TransactionItems) { Modified = false; var TItem = (from b in Context.TransactionItems where b.TransactionItemId == x.TransactionItemId && b.CustomerId == CustomerId select b).FirstOrDefault(); if (TItem != null) { if (TItem.TransactionItemType == 2 && x.TransactionType != null) { if (TItem.TransactionItemDate != x.TransactionDate) { TItem.TransactionItemDate = x.TransactionDate; Modified = true; } if (TItem.TransactionItemName != x.TransactionName) { TItem.TransactionItemName = x.TransactionName; Modified = true; } if (TItem.TransactionItemAmount != x.TransactionAmount) { TItem.TransactionItemAmount = x.TransactionAmount; Modified = true; } } if (TItem.TransactionItemType == 4 && x.TransactionType != null && x.TransactionAmount != 0) { if (TItem.TransactionItemAmount != x.TransactionAmount) { TItem.TransactionItemAmount = x.TransactionAmount; Modified = true; } } if (TItem.TransactionItemType != 3 && x.TransactionType != null && x.TransactionAmount != 0) { if (TItem.TransactionItemBudgetItem != x.BudgetItemId) { TItem.TransactionItemBudgetItem = x.BudgetItemId; Modified = true; } if (TItem.TransactionItemMemo != x.TransactionMemo) { TItem.TransactionItemMemo = x.TransactionMemo; Modified = true; } } if (Modified) { TItem.UpdateDate = DateTime.Now; Context.Entry(TItem).State = System.Data.Entity.EntityState.Modified; ChangeExists = true; } } } if (ChangeExists) { Context.SaveChanges(); result = "Success"; } else { result = "NoChange"; } } catch (Exception e) { result = e.ToString(); } return(result); }