public ActionResult Create([Bind(Include = "BudgetInvoiceId,ASalandWages,AEmpBenefits,AEmpTravel,AEmpTraining,AOfficeRent,AOfficeUtilities,AFacilityIns,AOfficeSupplies,AEquipment,AOfficeCommunications,AOfficeMaint,AConsulting,SubConPayCost,BackgrounCheck,Other,AJanitorServices,ADepreciation,ATechSupport,ASecurityServices,ATotCosts,AdminFee,Trasportation,JobTraining,TuitionAssistance,ContractedResidential,UtilityAssistance,EmergencyShelter,HousingAssistance,Childcare,Clothing,Food,Supplies,RFO,BTotal,Maxtot,Region,Month,Year,SubmittedDate")] BudgetCosts budgetCosts)
{
if (ModelState.IsValid)
{
var dataexist = from s in db.BudgetCosts
where
s.Year == budgetCosts.Year &&
s.Region == budgetCosts.Region
select s;
if (dataexist.Count() >= 1)
{
ViewBag.error = "Data already exists. Please change the params or search in the Reports tab for the current Record.";
}
else
{
budgetCosts.BudgetInvoiceId = Guid.NewGuid();
budgetCosts.SubmittedDate = DateTime.Now;
db.BudgetCosts.Add(budgetCosts);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
var datelist = Enumerable.Range(System.DateTime.Now.Year - 1, 5).ToList();
ViewBag.Year = new SelectList(datelist);
return(View(budgetCosts));
}
public ActionResult DeleteConfirmed(Guid id)
{
BudgetCosts budgetCosts = db.BudgetCosts
.SingleOrDefault(a => a.BudgetInvoiceId == id);
db.BudgetCosts.Remove(budgetCosts);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: BudgetCosts/Delete/5
public ActionResult Delete(Guid?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BudgetCosts budgetCosts = db.BudgetCosts
.SingleOrDefault(a => a.BudgetInvoiceId == id);
if (budgetCosts == null)
{
return(HttpNotFound());
}
return(View(budgetCosts));
}
public ActionResult Edit([Bind(Include = "BudgetInvoiceId,ASalandWages,AEmpBenefits,AEmpTravel,AEmpTraining,AOfficeRent,AOfficeUtilities,AFacilityIns,AOfficeSupplies,AEquipment,AOfficeCommunications,AOfficeMaint,AConsulting,SubConPayCost,BackgrounCheck,Other,AJanitorServices,ADepreciation,ATechSupport,ASecurityServices,ATotCosts,AdminFee,Trasportation,JobTraining,TuitionAssistance,ContractedResidential,UtilityAssistance,EmergencyShelter,HousingAssistance,Childcare,Clothing,Food,Supplies,RFO,BTotal,Maxtot,Region,Month,Year,SubmittedDate")] BudgetCosts budgetCosts)
{
if (ModelState.IsValid)
{
budgetCosts.SubmittedDate = DateTime.Now;
db.Entry(budgetCosts).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
var datelist = Enumerable.Range(DateTime.Now.Year, 5).ToList();
ViewBag.Year = new SelectList(datelist);
return(View(budgetCosts));
}
// GET: BudgetCosts/Edit/5
public ActionResult Edit(Guid?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BudgetCosts budgetCosts = db.BudgetCosts.Find(id);
if (budgetCosts == null)
{
return(HttpNotFound());
}
var datelist = Enumerable.Range(System.DateTime.Now.Year - 1, 5).ToList();
ViewBag.Year = new SelectList(datelist);
return(View(budgetCosts));
}
