public async Task <ActionResult> Create([Bind(Include = "Id,RecieverName,PayingDate,ItemQuantity,ItemName,CategoryId,TransactionYear,PaidAmount")] ExpensesRecords expensesRecords)
{
if (ModelState.IsValid)
{
expensesRecords.TransactionYear = DateTime.Now.Year;
db.ExpensesRecords.Add(expensesRecords);
await db.SaveChangesAsync();
db.Entry(expensesRecords).GetDatabaseValues();
int salaryrecid = expensesRecords.Id;
//here inserting inventory expense records into the expense outgoing mpdel
ExpenseOutgoingRecords expensetransection = new ExpenseOutgoingRecords();
expensetransection.RecordId = salaryrecid;
expensetransection.Personid = 0;
expensetransection.PersonName = expensesRecords.RecieverName;
expensetransection.TransactionType = "Inventory Expense";
expensetransection.TransactionDate = expensesRecords.PayingDate;
expensetransection.TransactionYear = expensesRecords.TransactionYear;
expensetransection.TransactionAmount = expensesRecords.PaidAmount;
db.ExpenseOutgoingRecords.Add(expensetransection);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CategoryId = new SelectList(db.collegeExpenseCategories, "Id", "Categories", expensesRecords.CategoryId);
return(View(expensesRecords));
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
ExpensesRecords expensesRecords = await db.ExpensesRecords.FindAsync(id);
db.ExpensesRecords.Remove(expensesRecords);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
// GET: ExpensesRecords/Create
public ActionResult Create()
{
var view = new ExpensesRecords
{
TransactionYear = DateTime.Now.Year,
PayingDate = DateTime.Now.Date,
};
ViewBag.CategoryId = new SelectList(db.collegeExpenseCategories, "Id", "Categories");
return(View(view));
}
public async Task <ActionResult> Edit([Bind(Include = "Id,RecieverName,PayingDate,ItemQuantity,ItemName,CategoryId,TransactionYear,PaidAmount")] ExpensesRecords expensesRecords)
{
if (ModelState.IsValid)
{
db.Entry(expensesRecords).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.CategoryId = new SelectList(db.collegeExpenseCategories, "Id", "Categories", expensesRecords.CategoryId);
return(View(expensesRecords));
}
// GET: ExpensesRecords/Details/5
public async Task <ActionResult> Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ExpensesRecords expensesRecords = await db.ExpensesRecords.FindAsync(id);
if (expensesRecords == null)
{
return(HttpNotFound());
}
return(View(expensesRecords));
}
// GET: ExpensesRecords/Edit/5
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ExpensesRecords expensesRecords = await db.ExpensesRecords.FindAsync(id);
if (expensesRecords == null)
{
return(HttpNotFound());
}
ViewBag.CategoryId = new SelectList(db.collegeExpenseCategories, "Id", "Categories", expensesRecords.CategoryId);
return(View(expensesRecords));
}
