public ActionResult DeleteConfirmed(int id)
{
OperationCostDetail operationCostDetail = db.OperationCostDetails.Find(id);
db.OperationCostDetails.Remove(operationCostDetail);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "OperationCostDetailID,CostHead,ExpenseID,CostAmount,AddedBy,CostDate")] OperationCostDetail operationCostDetail)
{
if (ModelState.IsValid)
{
db.Entry(operationCostDetail).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ExpenseID = new SelectList(db.Expenses, "ExpenseID", "Month", operationCostDetail.ExpenseID);
return(View(operationCostDetail));
}
// GET: OperationCostDetail/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
OperationCostDetail operationCostDetail = db.OperationCostDetails.Find(id);
if (operationCostDetail == null)
{
return(HttpNotFound());
}
return(View(operationCostDetail));
}
// GET: OperationCostDetail/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
OperationCostDetail operationCostDetail = db.OperationCostDetails.Find(id);
if (operationCostDetail == null)
{
return(HttpNotFound());
}
ViewBag.ExpenseID = new SelectList(db.Expenses, "ExpenseID", "Month", operationCostDetail.ExpenseID);
return(View(operationCostDetail));
}
public ActionResult Create([Bind(Include = "OperationCostDetailID,CostHead,ExpenseID,CostAmount,AddedBy,CostDate")] OperationCostDetail operationCostDetail)
{
if (ModelState.IsValid)
{
int sid = Convert.ToInt32(Session["OutletID"].ToString());
string month = DateTime.Now.ToString("MMMM");
int expID = db.Expenses.FirstOrDefault(e => e.OutletID == sid && e.Month.ToLower() == month.ToLower()).ExpenseID;
operationCostDetail.ExpenseID = expID;
operationCostDetail.AddedBy = HttpContext.User.Identity.Name;
operationCostDetail.CostDate = DateTime.Now;
db.OperationCostDetails.Add(operationCostDetail);
db.SaveChanges();
var expenseUpdate = db.Expenses.Where(e => e.ExpenseID == expID).FirstOrDefault();
if (operationCostDetail.CostAmount > expenseUpdate.CashOnHand)
{
if (expenseUpdate.CashOnHand == 0)
{
expenseUpdate.OtherExpense += operationCostDetail.CostAmount;
}
else
{
expenseUpdate.OtherExpense = operationCostDetail.CostAmount - expenseUpdate.CashOnHand;
expenseUpdate.CashOnHand -= expenseUpdate.CashOnHand;
}
}
else
{
expenseUpdate.CashOnHand -= operationCostDetail.CostAmount;
}
db.Entry(expenseUpdate).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ExpenseID = new SelectList(db.Expenses, "ExpenseID", "Month", operationCostDetail.ExpenseID);
return(View(operationCostDetail));
}
