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