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 static void NewDT(ref System.Data.DataTable dt)
{
dt.Clear();
dt.Columns.Add("SHFR");
dt.Columns.Add("SHFRDOC");
dt.Columns.Add("MARKA");
dt.Columns.Add("OBOSDOC");
dt.Columns.Add("NAIMOBJ");
dt.Columns.Add("STAGE");
dt.Columns.Add("NAIMIZOBR");
dt.Columns.Add("NAIMPROJE");
dt.Columns.Add("DATEOFLASTWRITE");
dt.Columns.Add("Directory");
}
public static void DtAdd(ref System.Data.DataTable dt, ref Row row)
{
DataRow dr = dt.NewRow();
dr["SHFR"] = row.SHFR;
dr["SHFRDOC"] = row.SHFRDOC;
dr["MARKA"] = row.MARKA;
dr["OBOSDOC"] = row.OBOSDOC;
dr["NAIMOBJ"] = row.NAIMOBJ;
dr["STAGE"] = row.STAGE;
dr["NAIMIZOBR"] = row.NAIMIZOBR;
dr["NAIMPROJE"] = row.NAIMPROJE;
dr["DATEOFLASTWRITE"] = row.DATEOFLASTWRITE;
dr["Directory"] = row.Directory;
dt.Rows.Add(dr);
}
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 = "" }));
}
}
