// GET: /Advance/Delete/5
public JsonResult advancedDelete(int id = 0)
{
tbl_Advance advance = db.tbl_Advance.Where(x => x.AdvanceID == id).FirstOrDefault();
db.tbl_Advance.Remove(advance);
db.SaveChanges();
return(Json(true, JsonRequestBehavior.AllowGet));
}
public ActionResult AdvancedList(string keyword, tbl_Advance advance)
{
var results = (from item in db.tbl_Advance where item.tbl_staffInfo.Name.Contains(keyword) select item).ToList();
var pageIndex = advance.Page ?? 1;
advance.AdvancedListResults = results.ToPagedList(pageIndex, RecordsPerPage);
return(View(advance));
}
public ActionResult AdvancedList(tbl_Advance advance)
{
var results = (from item in db.tbl_Advance
select item).ToList().OrderBy(p => p.AdvanceID);
var pageIndex = advance.Page ?? 1;
advance.AdvancedListResults = results.ToPagedList(pageIndex, RecordsPerPage);
return(View(advance));
//return View(db.Advances.ToList());
}
public ActionResult advanceUpdate(int id = 0)
{
advanceid = id;
tbl_Advance bc = db.tbl_Advance.FirstOrDefault(a => a.AdvanceID == advanceid);
if (bc == null)
{
return(HttpNotFound());
}
ViewBag.StaffID = new SelectList(db.tbl_staffInfo, "StaffID", "Name");
ViewBag.GetSalary = bc.Salary;
ViewBag.GetAdvanceDate = bc.AdvanceDate;
ViewBag.GetAdvanceAmount = bc.AdvanceAmount;
ViewBag.GetNewAdvance = bc.NewAdvance;
ViewBag.GetAdvanceBack = bc.AdvanceBack;
ViewBag.GetPaymentWay = bc.PaymentWay;
ViewBag.GetGrandTotalAmount = bc.GrandTotalAmount;
ViewBag.GetPaid = bc.Paid;
return(View(bc));
}
public ActionResult advanceUpdate(tbl_Advance bc, int id = 0)
{
tbl_Advance bc1 = db.tbl_Advance.FirstOrDefault(a => a.AdvanceID == advanceid);
bc1.StaffID = bc.StaffID;
bc1.Salary = bc.Salary;
bc1.AdvanceDate = bc.AdvanceDate;
bc1.AdvanceAmount = bc.AdvanceAmount;
bc1.NewAdvance = bc.NewAdvance;
bc1.AdvanceBack = bc.AdvanceBack;
bc1.PaymentWay = bc.PaymentWay;
bc1.GrandTotalAmount = bc.GrandTotalAmount;
bc1.Paid = bc.Paid;
if (bc1 == null)
{
return(HttpNotFound());
}
db.SaveChanges();
ViewBag.StaffID = new SelectList(db.tbl_staffInfo, "StaffID", "Name");
return(View(bc1));
}
public ActionResult addAdvanced(tbl_Advance advance)
{
if (ModelState.IsValid)
{
string userid = "";
string userSettings = "";
if (Request.Cookies["UserSettings"] != null)
{
if (Request.Cookies["UserSettings"]["UserName"] != null)
{
userSettings = Request.Cookies["UserSettings"]["UserName"]; userid = Request.Cookies["UserSettings"]["UserId"];
}
}
advance.EntryDate = DateTime.Today;
advance.UserInfoID = Convert.ToInt32(userid);
db.tbl_Advance.Add(advance);
db.SaveChanges();
return(RedirectToAction("addAdvanced"));
}
ViewBag.StaffID = new SelectList(db.tbl_staffInfo, "StaffID", "Name");
ViewBag.UserInfoID = new SelectList(db.tbl_UserInfo, "UserInfoID", "UserName");
return(View(advance));
}
