public ActionResult Index()
{
try
{
OCCUSER user = (OCCUSER)Session["User"];
AuthorizerDashboardVM aVm = new AuthorizerDashboardVM();
WebRef.OBLAPP oblApp = new WebRef.OBLAPP();
System.Data.DataTable dt = oblApp.GetByUserID(user.EMPLOYEEID);
foreach (DataRow dataRow in dt.Rows)
{
aVm.EmployeeInfoVm.BranchName = (string)dataRow[21];
aVm.EmployeeInfoVm.Email = (string)dataRow[9];
aVm.EmployeeInfoVm.EmployeeId = (string)dataRow[2];
aVm.EmployeeInfoVm.JobTitle = (string)dataRow[7];
aVm.EmployeeInfoVm.Name = (string)dataRow[3];
aVm.EmployeeInfoVm.PreDeptName = (string)dataRow[17];
}
var pendingReqList = db.CARDCHEREUISITION.Where(x => x.ISDELETE != true).Where(x => x.STATUS == 4).OrderByDescending(x => x.ID).ToList();
var pendingReqListCount = pendingReqList.Count;
aVm.PendingRequisitionCount = pendingReqListCount;
aVm.PendingRequisitionList = pendingReqList.Take(5).ToList();
var pendingChequeList = db.CARDCHTRAN.Where(x => x.STATUS == 13).Where(x => x.ISDELETE != true).OrderByDescending(x => x.ID).ToList();
var pendingChequeListCount = pendingChequeList.Count;
aVm.PendingCardChequeAmount = pendingChequeList.Sum(x => x.AMOUNT);
aVm.PendingCardChequeCount = pendingChequeListCount;
aVm.PendingCardChequeList = pendingChequeList.Take(5).ToList();
var authReqList = db.CARDCHEREUISITION.Where(x => x.ISDELETE != true).Where(x => x.STATUS == 5).OrderByDescending(x => x.ID).ToList();
var authReqListCount = authReqList.Count;
aVm.AuthRequisitionCount = authReqListCount;
aVm.AuthorizedRequisitionList = authReqList.Take(5).ToList();
var authChequeList = db.CARDCHTRAN.Where(x => x.STATUS == 14).Where(x => x.ISDELETE != true).OrderByDescending(x => x.ID).ToList();
var authChequeListCount = authChequeList.Count;
aVm.AuthorizedCardChequeAmount = authChequeList.Sum(x => x.AMOUNT);
aVm.AuthCardCHequeCount = authChequeListCount;
aVm.AuthorizedCardChequeList = authChequeList.Take(5).ToList();
return(View(aVm));
}
catch (Exception)
{
return(RedirectToAction("Error", "Home", new { Area = "" }));
}
// return View();
}
public ActionResult Index(DateTime? startDate, DateTime? endDate, string btnName)
{
try
{
if (startDate != null || endDate != null)
{
OCCUSER user = (OCCUSER)Session["User"];
AuthorizerDashboardVM aVm = new AuthorizerDashboardVM();
WebRef.OBLAPP oblApp = new WebRef.OBLAPP();
System.Data.DataTable dt = oblApp.GetByUserID(user.EMPLOYEEID);
foreach (DataRow dataRow in dt.Rows)
{
aVm.EmployeeInfoVm.BranchName = (string)dataRow[21];
aVm.EmployeeInfoVm.Email = (string)dataRow[9];
aVm.EmployeeInfoVm.EmployeeId = (string)dataRow[2];
aVm.EmployeeInfoVm.JobTitle = (string)dataRow[7];
aVm.EmployeeInfoVm.Name = (string)dataRow[3];
aVm.EmployeeInfoVm.PreDeptName = (string)dataRow[17];
}
var pendingReqList = db.CARDCHEREUISITION.Where(x => x.ISDELETE == false).Where(x => x.STATUS == 4).OrderByDescending(x => x.ID).ToList();
var pendingReqListCount = pendingReqList.Count;
aVm.PendingRequisitionCount = pendingReqListCount;
aVm.PendingRequisitionList = pendingReqList.Take(5).ToList();
var pendingChequeList = db.CARDCHTRAN.Where(x => x.STATUS == 13).Where(x=>x.ISDELETE!=true).OrderByDescending(x => x.ID).ToList();
var pendingChequeListCount = pendingChequeList.Count;
aVm.PendingCardChequeAmount = pendingChequeList.Sum(x => x.AMOUNT);
aVm.PendingCardChequeCount = pendingChequeListCount;
aVm.PendingCardChequeList = pendingChequeList.Take(5).ToList();
var authReqList = db.CARDCHEREUISITION.Where(x => x.ISDELETE != true).Where(x => x.STATUS == 5).OrderByDescending(x => x.ID).ToList();
var authReqListCount = authReqList.Count;
aVm.AuthRequisitionCount = authReqListCount;
aVm.AuthorizedRequisitionList = authReqList.Take(5).ToList();
var authChequeList = db.CARDCHTRAN.Where(x => x.STATUS == 14).Where(x=>x.ISDELETE!=true).OrderByDescending(x => x.ID).ToList();
var authChequeListCount = authChequeList.Count;
aVm.AuthorizedCardChequeAmount = authChequeList.Sum(x => x.AMOUNT);
aVm.AuthCardCHequeCount = authChequeListCount;
aVm.AuthorizedCardChequeList = authChequeList.Take(5).ToList();
if (btnName == "pendingreq")
{
pendingReqList = db.CARDCHEREUISITION.Where(x => x.ISDELETE != true).Where(x => x.STATUS == 4).Where(x => x.CREATEDON >= startDate).Where(x => x.CREATEDON <= endDate).ToList();
pendingReqListCount = pendingReqList.Count;
aVm.PendingRequisitionCount = pendingReqListCount;
aVm.PendingRequisitionList = pendingReqList.ToList();
//aVm.Deposits = List;
}
else if (btnName == "pendingcc")
{
pendingChequeList = db.CARDCHTRAN.Where(x => x.STATUS == 13).Where(x => x.CREATEDON >= startDate).Where(x => x.CREATEDON <= endDate).Where(x=>x.ISDELETE!=true).ToList();
pendingChequeListCount = pendingChequeList.Count;
aVm.PendingCardChequeAmount = pendingChequeList.Sum(x => x.AMOUNT);
aVm.PendingCardChequeCount = pendingChequeListCount;
aVm.PendingCardChequeList = pendingChequeList.ToList();
}
else if (btnName == "authreq")
{
authReqList = db.CARDCHEREUISITION.Where(x => x.ISDELETE != true).Where(x => x.STATUS == 5).Where(x => x.CREATEDON >= startDate).Where(x => x.CREATEDON <= endDate).ToList();
authReqListCount = authReqList.Count;
aVm.AuthRequisitionCount = authReqListCount;
aVm.AuthorizedRequisitionList = authReqList.Take(5).ToList();
}
else if (btnName == "authcc")
{
authChequeList = db.CARDCHTRAN.Where(x => x.STATUS == 14).Where(x => x.CREATEDON >= startDate).Where(x => x.CREATEDON <= endDate).Where(x=>x.ISDELETE!=true).ToList();
authChequeListCount = authChequeList.Count;
aVm.AuthorizedCardChequeAmount = authChequeList.Sum(x => x.AMOUNT);
aVm.AuthCardCHequeCount = authChequeListCount;
aVm.AuthorizedCardChequeList = authChequeList.Take(5).ToList();
}
return View(aVm);
}
return RedirectToAction("Index");
}
catch (Exception exception)
{
return RedirectToAction("Error", "Home", new { Area = "" });
}
}
public ActionResult Index()
{
try
{
OCCUSER user = (OCCUSER)Session["User"];
AuthorizerDashboardVM aVm = new AuthorizerDashboardVM();
WebRef.OBLAPP oblApp = new WebRef.OBLAPP();
System.Data.DataTable dt = oblApp.GetByUserID(user.EMPLOYEEID);
foreach (DataRow dataRow in dt.Rows)
{
aVm.EmployeeInfoVm.BranchName = (string)dataRow[21];
aVm.EmployeeInfoVm.Email = (string)dataRow[9];
aVm.EmployeeInfoVm.EmployeeId = (string)dataRow[2];
aVm.EmployeeInfoVm.JobTitle = (string)dataRow[7];
aVm.EmployeeInfoVm.Name = (string)dataRow[3];
aVm.EmployeeInfoVm.PreDeptName = (string)dataRow[17];
}
var pendingReqList = db.CARDCHEREUISITION.Where(x => x.ISDELETE != true).Where(x => x.STATUS == 4).OrderByDescending(x => x.ID).ToList();
var pendingReqListCount = pendingReqList.Count;
aVm.PendingRequisitionCount = pendingReqListCount;
aVm.PendingRequisitionList = pendingReqList.Take(5).ToList();
var pendingChequeList = db.CARDCHTRAN.Where(x=>x.STATUS==13).Where(x=>x.ISDELETE!=true).OrderByDescending(x => x.ID).ToList();
var pendingChequeListCount = pendingChequeList.Count;
aVm.PendingCardChequeAmount = pendingChequeList.Sum(x => x.AMOUNT);
aVm.PendingCardChequeCount = pendingChequeListCount;
aVm.PendingCardChequeList = pendingChequeList.Take(5).ToList();
var authReqList = db.CARDCHEREUISITION.Where(x=>x.ISDELETE!=true).Where(x => x.STATUS ==5).OrderByDescending(x => x.ID).ToList();
var authReqListCount = authReqList.Count;
aVm.AuthRequisitionCount = authReqListCount;
aVm.AuthorizedRequisitionList = authReqList.Take(5).ToList();
var authChequeList = db.CARDCHTRAN.Where(x => x.STATUS == 14).Where(x=>x.ISDELETE!=true).OrderByDescending(x => x.ID).ToList();
var authChequeListCount = authChequeList.Count;
aVm.AuthorizedCardChequeAmount = authChequeList.Sum(x => x.AMOUNT);
aVm.AuthCardCHequeCount = authChequeListCount;
aVm.AuthorizedCardChequeList = authChequeList.Take(5).ToList();
return View(aVm);
}
catch (Exception)
{
return RedirectToAction("Error", "Home", new { Area = "" });
}
// return View();
}
public ActionResult Index(DateTime?startDate, DateTime?endDate, string btnName)
{
try
{
if (startDate != null || endDate != null)
{
OCCUSER user = (OCCUSER)Session["User"];
AuthorizerDashboardVM aVm = new AuthorizerDashboardVM();
WebRef.OBLAPP oblApp = new WebRef.OBLAPP();
System.Data.DataTable dt = oblApp.GetByUserID(user.EMPLOYEEID);
foreach (DataRow dataRow in dt.Rows)
{
aVm.EmployeeInfoVm.BranchName = (string)dataRow[21];
aVm.EmployeeInfoVm.Email = (string)dataRow[9];
aVm.EmployeeInfoVm.EmployeeId = (string)dataRow[2];
aVm.EmployeeInfoVm.JobTitle = (string)dataRow[7];
aVm.EmployeeInfoVm.Name = (string)dataRow[3];
aVm.EmployeeInfoVm.PreDeptName = (string)dataRow[17];
}
var pendingReqList = db.CARDCHEREUISITION.Where(x => x.ISDELETE == false).Where(x => x.STATUS == 4).OrderByDescending(x => x.ID).ToList();
var pendingReqListCount = pendingReqList.Count;
aVm.PendingRequisitionCount = pendingReqListCount;
aVm.PendingRequisitionList = pendingReqList.Take(5).ToList();
var pendingChequeList = db.CARDCHTRAN.Where(x => x.STATUS == 13).Where(x => x.ISDELETE != true).OrderByDescending(x => x.ID).ToList();
var pendingChequeListCount = pendingChequeList.Count;
aVm.PendingCardChequeAmount = pendingChequeList.Sum(x => x.AMOUNT);
aVm.PendingCardChequeCount = pendingChequeListCount;
aVm.PendingCardChequeList = pendingChequeList.Take(5).ToList();
var authReqList = db.CARDCHEREUISITION.Where(x => x.ISDELETE != true).Where(x => x.STATUS == 5).OrderByDescending(x => x.ID).ToList();
var authReqListCount = authReqList.Count;
aVm.AuthRequisitionCount = authReqListCount;
aVm.AuthorizedRequisitionList = authReqList.Take(5).ToList();
var authChequeList = db.CARDCHTRAN.Where(x => x.STATUS == 14).Where(x => x.ISDELETE != true).OrderByDescending(x => x.ID).ToList();
var authChequeListCount = authChequeList.Count;
aVm.AuthorizedCardChequeAmount = authChequeList.Sum(x => x.AMOUNT);
aVm.AuthCardCHequeCount = authChequeListCount;
aVm.AuthorizedCardChequeList = authChequeList.Take(5).ToList();
if (btnName == "pendingreq")
{
pendingReqList = db.CARDCHEREUISITION.Where(x => x.ISDELETE != true).Where(x => x.STATUS == 4).Where(x => x.CREATEDON >= startDate).Where(x => x.CREATEDON <= endDate).ToList();
pendingReqListCount = pendingReqList.Count;
aVm.PendingRequisitionCount = pendingReqListCount;
aVm.PendingRequisitionList = pendingReqList.ToList();
//aVm.Deposits = List;
}
else if (btnName == "pendingcc")
{
pendingChequeList = db.CARDCHTRAN.Where(x => x.STATUS == 13).Where(x => x.CREATEDON >= startDate).Where(x => x.CREATEDON <= endDate).Where(x => x.ISDELETE != true).ToList();
pendingChequeListCount = pendingChequeList.Count;
aVm.PendingCardChequeAmount = pendingChequeList.Sum(x => x.AMOUNT);
aVm.PendingCardChequeCount = pendingChequeListCount;
aVm.PendingCardChequeList = pendingChequeList.ToList();
}
else if (btnName == "authreq")
{
authReqList = db.CARDCHEREUISITION.Where(x => x.ISDELETE != true).Where(x => x.STATUS == 5).Where(x => x.CREATEDON >= startDate).Where(x => x.CREATEDON <= endDate).ToList();
authReqListCount = authReqList.Count;
aVm.AuthRequisitionCount = authReqListCount;
aVm.AuthorizedRequisitionList = authReqList.Take(5).ToList();
}
else if (btnName == "authcc")
{
authChequeList = db.CARDCHTRAN.Where(x => x.STATUS == 14).Where(x => x.CREATEDON >= startDate).Where(x => x.CREATEDON <= endDate).Where(x => x.ISDELETE != true).ToList();
authChequeListCount = authChequeList.Count;
aVm.AuthorizedCardChequeAmount = authChequeList.Sum(x => x.AMOUNT);
aVm.AuthCardCHequeCount = authChequeListCount;
aVm.AuthorizedCardChequeList = authChequeList.Take(5).ToList();
}
return(View(aVm));
}
return(RedirectToAction("Index"));
}
catch (Exception exception)
{
return(RedirectToAction("Error", "Home", new { Area = "" }));
}
}
