public ActionResult DeleteCategory(int? id, int? termID)
{
var deleteCategoryContext = new YNTCTermContext();
TempData["termId"] = termID;
CategoryModel cm = deleteCategoryContext.CategoryModels.Find(id);
return View("DeleteCategoryView", cm);
}
public ActionResult CreateNewCategory(int? id)
{
var createCategoryContext = new YNTCTermContext();
TempData["termId"] = id;
CategoryModel cm = createCategoryContext.CategoryModels.Find(id);
return View("CreateNewCategoryView", cm);
}
public ActionResult CreateNewCustomer(int? id, int? termID)
{
var createCustomerContext = new YNTCTermContext();
TempData["categoryModel"] = id;
TempData["TermId"] = termID;
CustomerModel cm = createCustomerContext.CustomerModels.Find(id);
return View("CreateNewCustomerView", cm);
}
public ActionResult CreateNewCategory(CategoryModel categoryModel)
{
var createCategoryContext = new YNTCTermContext();
int? termId = (int?)TempData["termId"];
var currentTerm = createCategoryContext.Term.Find(termId);
currentTerm.Categories.Add(categoryModel);
if (ModelState.IsValid)
{
createCategoryContext.Entry(categoryModel).State = EntityState.Added;
createCategoryContext.SaveChanges();
return RedirectToAction("MonthOverview", currentTerm);
}
return View("CreateNewCategoryView", categoryModel);
}
public ActionResult CreateNewCustomer(CustomerModel customerModel)
{
var createCustomerContext = new YNTCTermContext();
int? categoryModel = (int?)TempData["categoryModel"];
int? termId = (int?)TempData["termId"];
var currentTerm = createCustomerContext.Term.Find(termId);
CategoryModel modelOfCategory = createCustomerContext.CategoryModels.Find(categoryModel);
modelOfCategory.Customers.Add(customerModel);
if (ModelState.IsValid)
{
createCustomerContext.Entry(customerModel).State = EntityState.Added;
createCustomerContext.SaveChanges();
return RedirectToAction("MonthOverview", currentTerm);
}
return View("CreateNewCustomerView");
}
public ActionResult DeleteCategory([Bind(Include = "Id, NameOfCategory")] CategoryModel categoryModel)
{
var deleteCategoryContext = new YNTCTermContext();
int? termId = (int?)TempData["termId"];
var currentTerm = deleteCategoryContext.Term.Find(termId);
if (ModelState.IsValid)
{
deleteCategoryContext.Entry(categoryModel).State = EntityState.Deleted;
deleteCategoryContext.CategoryModels.Remove(categoryModel);
deleteCategoryContext.SaveChanges();
return RedirectToAction("MonthOverview", currentTerm);
}
return View("DeleteCategoryView");
}
private TermModel GetNewTerm()
{
TermModel term = new TermModel();
using (var db = new YNTCTermContext())
{
TermModel latestTerm = db.Term.OrderByDescending(e => e.Id).FirstOrDefault();
term.PrevId = latestTerm.Id;
//term.NextId = term.Id;
db.SaveChanges();
term.StartDate = latestTerm.StartDate.AddMonths(1);
term.ProjectedGoal = latestTerm.ProjectedGoal;
term.Categories = new List<CategoryModel>();
foreach(CategoryModel catm in latestTerm.Categories)//perform deep copy
{
CategoryModel new_catm = new CategoryModel { NameOfCategory = catm.NameOfCategory,
Customers = new List<CustomerModel>()
};
foreach(CustomerModel custm in catm.Customers)
{
CustomerModel new_custm = new CustomerModel
{
NameOfCompany = custm.NameOfCompany,
BudgetActualCustomer = new BudgetActualModel { Budget = 0, Actual = 0, Difference = 0 }
};
new_catm.Customers.Add(new_custm);
}
term.Categories.Add(new_catm);
}
}
return term;
}
public ActionResult TermDisplay(int? id)
{
TermModel term = new TermModel();
if (id == null)
{
//determine which term is the current date
//If the date does not exist, create it new and create any up until that point
}
else
{
//open term from database by id
using (var db = new YNTCTermContext())
{
term = db.Term.Find(id);
if(term==null)
{
term = GetNewTerm();
db.Term.Add(term);
db.SaveChanges();
}
term.BudgetActual = new BudgetActualModel
{
Budget = 0,
Actual = 0,
Difference = 0
};
foreach (CategoryModel termCategory in term.Categories)
{
termCategory.BudgetActualCategory = new BudgetActualModel
{
Budget = 0,
Actual = 0,
Difference = 0
};
foreach (CustomerModel termCustomer in termCategory.Customers)
{
termCustomer.BudgetActualCustomer.Difference = termCustomer.BudgetActualCustomer.Actual - termCustomer.BudgetActualCustomer.Budget;
termCategory.BudgetActualCategory.Budget += termCustomer.BudgetActualCustomer.Budget;
termCategory.BudgetActualCategory.Actual += termCustomer.BudgetActualCustomer.Actual;
termCategory.BudgetActualCategory.Difference += termCustomer.BudgetActualCustomer.Difference;
}
term.BudgetActual.Budget += termCategory.BudgetActualCategory.Budget;
term.BudgetActual.Actual += termCategory.BudgetActualCategory.Actual;
term.BudgetActual.Difference += termCategory.BudgetActualCategory.Difference;
}
//if term does not exist
//copy categories and budgeted from previous term from database
term.ProjectedGoal.ExpectedAmountToEarn = (term.ProjectedGoal.ExpectedAmountToEarn + term.ProjectedGoal.ExpectedAmountToEarn) / 2;
}
}
return View("TermView", term);
}
public ActionResult SaleClosed([Bind(Include = "Id, NameOfCompany, BudgetActualCustomer")] CustomerModel customerModel)
{
var saleClosedCustomerContext = new YNTCTermContext();
int? termId = (int?)TempData["termId"];
var currentTerm = saleClosedCustomerContext.Term.Find(termId);
if (ModelState.IsValid)
{
saleClosedCustomerContext.Entry(customerModel).State = EntityState.Modified;
saleClosedCustomerContext.SaveChanges();
return RedirectToAction("MonthOverview", currentTerm);
}
return View("SaleClosedView");
}
public ActionResult SaleClosed(int? id, int? termID)
{
var saleClosedCustomerContext = new YNTCTermContext();
TempData["termId"] = termID;
CustomerModel cm = saleClosedCustomerContext.CustomerModels.Find(id);
return View("SaleClosedView", cm);
}
public ActionResult ProjectedGoal([Bind(Include = "Id, ExpectedAmountToEarn")] ProjectedGoalModel projectedGoalModel)
{
var projectedGoalContext = new YNTCTermContext();
int? termId = (int?)TempData["termId"];
YNTCTermContext db = new YNTCTermContext();
TermModel term = projectedGoalContext.Term.Find(termId);
if (term == null)
{
term = GetNewTerm();
db.Term.Add(term);
db.SaveChanges();
}
term.ProjectedGoal = projectedGoalModel;
if (ModelState.IsValid)
{
projectedGoalContext.Entry(projectedGoalModel).State = EntityState.Added;
projectedGoalContext.SaveChanges();
return RedirectToAction("MonthOverview");
}
return View("ProjectedGoalView");
}
public ActionResult EditCustomer(int? id, int? termID)
{
var editCustomerContext = new YNTCTermContext();
TempData["termId"] = termID;
CustomerModel cm = editCustomerContext.CustomerModels.Find(id);
return View("EditCustomerView", cm);
}
public ActionResult EditCategory(int? id, int? termID)
{
var editCategoryContext = new YNTCTermContext();
TempData["termId"] = termID;
CategoryModel cateModel = editCategoryContext.CategoryModels.Find(id);
return View("EditCategoryView", cateModel);
}
public ActionResult DetailsCustomer([Bind(Include = "Id, ContactName, CustomerMotivations")]CustomerModel customerModel, DetailsCustomerModel detailsModel)
{
var createDetailsContext = new YNTCTermContext();
int? termId = (int?)TempData["termId"];
//var currentTerm = createDetailsContext.Term.Find(termId);
var detailsOnCustomerId = createDetailsContext.CustomerModels.Find(customerModel.Id);
detailsOnCustomerId.DetailsOfCustomer = detailsModel;
if (ModelState.IsValid)
{
createDetailsContext.Entry(detailsModel).State = EntityState.Added;
createDetailsContext.SaveChanges();
RedirectToAction("MonthOverview", detailsModel);
}
return View("DetailsCustomerView", detailsModel);
}
public ActionResult DetailsCustomer(int? id, int? termID)
{
var createDetailsContext = new YNTCTermContext();
TempData["termId"] = termID;
DetailsCustomerModel dm = createDetailsContext.CustomerModels.Find(id).DetailsOfCustomer;
return View("DetailsCustomerView", dm);
}