public ActionResult ClientServicingDashboardInfo(int page = 1, string sort = "", string sortDir = "desc", string Search = "", short ClientRowID = 0, string CaseStatus = "", string RecievingDate = "", string CompletedDate = "", byte tatdays = 0)
{
DashboardClientCandidateListViewModel model = new DashboardClientCandidateListViewModel();
try
{
int pageSize = 20;
string SpocEmail = Session["TeamMemberEmail"].ToString();
short teamMemerRowId = Convert.ToInt16(Session["TeamMemberRowID"]);
if (!string.IsNullOrEmpty(CaseStatus) && (CaseStatus == "Pendingwithcandidate" || CaseStatus == "PendingwithHR"))
{
model = repoDashboard.GetClientServicingDashBoardTempPQPersonalInfo(page, pageSize, sort.ToLower(), sortDir.ToLower(), Search, CaseStatus, ClientRowID, RecievingDate, SpocEmail);
}
else
{
model = repoDashboard.GetClientServicingDashBoardInfo(page, pageSize, sort.ToLower(), sortDir.ToLower(), Search, CaseStatus, ClientRowID, RecievingDate, CompletedDate, tatdays, SpocEmail);
}
if (model == null)
{
ViewBag.ErrorMsg = "No item found!";
}
BindClientListByLogInName(SpocEmail);
}
catch (Exception Ex)
{
ViewBag.ErrorMsg = Ex.Message;
clsCommonMethods.ErrorLog(Server.MapPath("~\\ErrorLogs\\Logfiles"), Ex.Message, Ex.StackTrace);
}
return(View(model));
}
public DashboardClientCandidateListViewModel GetClientServicingDashBoardTempPQPersonalInfo(int pageNo, int pageSize, string sort, string sortDir, string Search = "", string CaseStatus = "", short ClientRowID = 0, string RecievingDate = "", string SpocEmailID = "")
{
try
{
if (pageNo < 0)
{
pageNo = 1;
}
IQueryable <TempPQPersonal> data = db.TempPQPersonals;
if (ClientRowID > 0)
{
data = data.Where(a => a.ClientRowID == ClientRowID);
}
else
{
var Clients = db.PQClientMasters.Where(s => s.SpocEmailID.Contains(SpocEmailID)).Select(s => s.ClientRowID).ToList();
data = data.Where(a => Clients.Contains(a.ClientRowID));
}
if (!string.IsNullOrEmpty(Search))
{
data = data.Where(b => (b.Name + " " + b.MiddleName + " " + b.LastName).Replace(" ", String.Empty).Contains(Search.Replace(" ", String.Empty)) || b.CompanyRefNo.ToLower().Trim() == Search.ToLower().Trim());
}
if (!string.IsNullOrEmpty(RecievingDate))
{
DateTime startDate = Convert.ToDateTime(RecievingDate);
data = data.Where(b => DbFunctions.TruncateTime(b.CreatedDate) == startDate.Date);
}
if (CaseStatus == "Pendingwithcandidate")
{
data = data.Where(p => p.OtherDetails != "DEC");
}
if (CaseStatus == "PendingwithHR")
{
data = data.Where(p => p.OtherDetails != "DEC" && p.PQClientMaster.HRApprovalRequired == 1);
}
switch (sort)
{
default:
data = sortDir == "asc" ? data.OrderBy(d => d.PersonalRowID) : data.OrderByDescending(d => d.PersonalRowID);
break;
}
DashboardClientCandidateListViewModel model = new DashboardClientCandidateListViewModel();
model.PageSize = pageSize;
model.TotalRecords = data.Count();
model.DashboardClientCandidates = data.Skip((pageNo - 1) * pageSize).Take(pageSize).Select(item => new ClientCandidateViewModel
{
PersonalRowID = item.PersonalRowID,
ClientRowID = item.ClientRowID,
ClientName = item.PQClientMaster.MasterAbbreviation.ClientName,
CandidateName = item.Name + " " + item.MiddleName + " " + item.LastName,
CandidateCode = item.CandidateCode,//copy
CompanyRefNo = item.CompanyRefNo,
//OutDate = item.DeliveryDate,
CaseStatus = item.OtherDetails,
CreatedDate = item.CreatedDate,
}).ToList();
return(model);
}
catch (Exception)
{
throw;
}
}
public DashboardClientCandidateListViewModel GetClientDashBoardInfo(int pageNo, int pageSize, string sort, string sortDir, string Search = "", string CaseStatus = "", short ClientRowID = 0, string RecievingToDate = "", string RecievingFromDate = "", string CompletedToDate = "", string CompletedFromDate = "", byte tatHours = 0, int ClientUserRowID = 0)
{
try
{
if (pageNo < 0)
{
pageNo = 1;
}
IQueryable <PQPersonal> data = db.PQPersonals.Include("PQClientMaster").Where(p => p.ClientRowID == ClientRowID);
if (ClientRowID > 0)
{
data = data.Where(b => b.ClientRowID == ClientRowID);
}
if (ClientUserRowID > 0)
{
data = data.Where(p => p.ClientUserRowID == ClientUserRowID);
}
if (!string.IsNullOrEmpty(CaseStatus))
{
if (CaseStatus == "ReportReceived")
{
data = data.Where(p => p.RWQCManagerTo > 0 && p.IsReportUploaded && !string.IsNullOrEmpty(p.ReportUploadedName));
}
if (CaseStatus == "WIP")
{
data = data.Where(p => p.ClientRowID == ClientRowID);
}
if (CaseStatus == "Pendingcandidate")
{
data = data.Where(p => p.CaseStatus == "WIP" || p.CaseStatus == "Allocated");
}
if (CaseStatus == "CaseApprpending")
{
data = data.Where(p => p.CaseStatus == "CaseApprpending");
}
if (CaseStatus == "InsuffWIP")
{
data = data.Where(p => p.CaseStatus == "Insufficent");
}
if (CaseStatus == "YTRWIP")
{
data = data.Where(p => p.CaseStatus == "YTRWIP");
}
if (CaseStatus == "RejectionWIP")
{
data = data.Where(p => p.CaseStatus == "Rejected");
}
if (CaseStatus == "ReOpen")
{
data = data.Where(p => p.CaseStatus == "ReOpen");
}
if (CaseStatus == "Priority")
{
data = data.Where(p => p.CaseType == "Priority");
}
if (CaseStatus == "YTRHold")
{
data = data.Where(p => p.CaseStatus == "YTR");
}
if (CaseStatus == "YTRHold10Days")
{
data = data.Where(p => p.CaseStatus == "YTR");
}
if (CaseStatus == "Insufficiency")
{
data = data.Where(p => p.CaseStatus == "Insufficent");
}
if (CaseStatus == "InsuffOr5Day")
{
data = data.Where(p => p.CaseStatus == "Insufficent");
}
if (CaseStatus == "FundApproval")
{
data = data.Where(p => p.CaseStatus == "Funds Pending");
}
if (CaseStatus == "Escalated")
{
data = data.Where(p => p.CaseStatus == "Escalated");
}
if (CaseStatus == "Interim")
{
data = data.Where(p => p.RWQCManagerTo > 0 && p.IsReportUploaded && !string.IsNullOrEmpty(p.ReportUploadedName));
}
if (CaseStatus == "Final")
{
data = data.Where(p => p.CaseStatus == "Final");
}
if (CaseStatus == "OtherthanGreen")
{
data = data.Where(p => !string.IsNullOrEmpty(p.FinalColor) && p.FinalColor != "Green");
}
}
if (!string.IsNullOrEmpty(Search))
{
data = data.Where(b => (b.Name + " " + b.MiddleName + " " + b.LastName).ToString().Replace(" ", "").Contains(Search.Replace(" ", "")) || b.ClientRefID == Search || b.CompanyRefNo == Search || b.CaseStatus == Search || b.CandidateCode == Search);
}
if (tatHours > 0)
{
data = GetPersonalInfoTLByTATHours(data, tatHours);
}
switch (sort)
{
default:
data = sortDir == "asc" ? data.OrderBy(d => d.PersonalRowID) : data.OrderByDescending(d => d.PersonalRowID);
break;
}
DashboardClientCandidateListViewModel model = new DashboardClientCandidateListViewModel();
model.PageSize = pageSize;
model.TotalRecords = data.Count();
model.DashboardClientCandidates = data.Skip((pageNo - 1) * pageSize).Take(pageSize).Select(item => new ClientCandidateViewModel
{
PersonalRowID = item.PersonalRowID,
ClientRowID = item.ClientRowID,
ClientName = item.PQClientMaster.MasterAbbreviation.ClientName,
CandidateName = item.Name + " " + item.MiddleName + " " + item.LastName,
CandidateCode = item.CandidateCode,//copy
CompanyRefNo = item.CompanyRefNo,
OutDate = item.DeliveryDate,
CaseStatus = item.CaseStatus,
CreatedDate = item.CreatedDate,
FinalStatus = item.FinalStatus,
FinalColor = item.FinalColor,
InterimReport = item.PQClientMaster.InterimReport,
IsReportUploaded = item.IsReportUploaded,
ReportUploadedName = item.ReportUploadedName,
ReportUploadedDate = item.ReportUploadedDate,
}).ToList();
return(model);
}
catch (Exception)
{
throw;
}
}
public DashboardClientCandidateListViewModel GetClientServicingDashBoardInfo(int pageNo, int pageSize, string sort, string sortDir, string Search = "", string CaseStatus = "", short ClientRowID = 0, string RecievingDate = "", string CompletedDate = "", byte tatdays = 0, string SpocEmailID = "")
{
try
{
if (pageNo < 0)
{
pageNo = 1;
}
IQueryable <PQPersonal> data = db.PQPersonals.Include("PQClientMaster");
if (ClientRowID > 0)
{
data = data.Where(b => b.ClientRowID == ClientRowID);
}
else
{
var Clients = db.PQClientMasters.Where(s => s.SpocEmailID.Contains(SpocEmailID)).Select(s => s.ClientRowID).ToList();
data = data.Where(a => Clients.Contains(a.ClientRowID));
}
if (!string.IsNullOrEmpty(Search))
{
data = data.Where(b => (b.Name + " " + b.MiddleName + " " + b.LastName).Replace(" ", String.Empty).Contains(Search.Replace(" ", String.Empty)) || b.CompanyRefNo.ToLower().Trim() == Search.ToLower().Trim());
}
if (!string.IsNullOrEmpty(RecievingDate))
{
DateTime startDate = Convert.ToDateTime(RecievingDate);
data = data.Where(b => DbFunctions.TruncateTime(b.OrderDate) == startDate.Date);
}
if (!string.IsNullOrEmpty(CompletedDate))
{
DateTime startDate = Convert.ToDateTime(CompletedDate);
data = data.Where(b => DbFunctions.TruncateTime(b.DeliveryDate) == startDate.Date);
}
if (!string.IsNullOrEmpty(CaseStatus))
{
if (CaseStatus == "WIP")
{
data = data.Where(p => p.CaseStatus == "WIP");
}
if (CaseStatus == "NonInitiated")
{
data = data.Where(p => p.AllocatedToDEScan == 0 && p.AllocatedToDE == 0 && p.AllocatedToDEQC == 0);
}
if (CaseStatus == "YTRHold")
{
data = data.Where(p => p.CaseStatus == "YTR");
}
if (CaseStatus == "RejectionWIP")
{
data = data.Where(p => p.CaseStatus == "Rejected");
}
if (CaseStatus == "ReOpen")
{
data = data.Where(p => p.CaseStatus == "ReOpen");
}
if (CaseStatus == "Priority")
{
data = data.Where(p => p.CaseType == "Priority");
}
if (CaseStatus == "Insufficiency" || CaseStatus == "InsuffWIP")
{
data = data.Where(p => p.CaseStatus == "Insufficent");
}
if (CaseStatus == "WIPRevenue")
{
data = data.Where(p => p.CaseStatus == "WIPRevenue");
}
if (CaseStatus == "WIPYTR")
{
data = data.Where(p => p.CaseStatus == "WIPYTR");
}
if (CaseStatus == "FundApproval")
{
data = data.Where(p => p.CaseStatus == "Funds Pending");
}
if (CaseStatus == "ApprovalPending")
{
data = data.Where(p => p.PQClientMaster.HRApprovalRequired == 1);
}
if (CaseStatus == "WIPDEQC")
{
data = data.Where(p => p.CaseStatus == "Allocated" && p.AllocatedToDEQC > 0);
}
if (CaseStatus == "Escalated")
{
data = data.Where(p => p.CaseStatus == "Escalated");
}
if (CaseStatus == "Closed")
{
data = data.Where(p => p.CaseStatus == "Closed");
}
if (CaseStatus == "OutTAT")
{
data = data.Where(p => p.CaseStatus == "OutTAT");
}
}
if (tatdays > 0)
{
data = GetPersonalInfoByTATHours(data, tatdays);
}
switch (sort)
{
default:
data = sortDir == "asc" ? data.OrderBy(d => d.PersonalRowID) : data.OrderByDescending(d => d.PersonalRowID);
break;
}
DashboardClientCandidateListViewModel model = new DashboardClientCandidateListViewModel();
model.PageSize = pageSize;
model.TotalRecords = data.Count();
model.DashboardClientCandidates = data.Skip((pageNo - 1) * pageSize).Take(pageSize).Select(item => new ClientCandidateViewModel
{
PersonalRowID = item.PersonalRowID,
ClientRowID = item.ClientRowID,
ClientName = item.PQClientMaster.MasterAbbreviation.ClientName,
CandidateName = item.Name + " " + item.MiddleName + " " + item.LastName,
CandidateCode = item.CandidateCode,//copy
CompanyRefNo = item.CompanyRefNo,
OutDate = item.DeliveryDate,
CaseStatus = item.CaseStatus,
CreatedDate = item.CreatedDate,
}).ToList();
return(model);
}
catch (Exception)
{
throw;
}
}
public DashboardClientCandidateListViewModel GetClientTempDashBoardInfo(int pageNo, int pageSize, string sort, string sortDir, string Search = "", string CaseStatus = "", short ClientRowID = 0, string RecievingToDate = "", string RecievingFromDate = "", int ClientUserRowID = 0)
{
try
{
if (pageNo < 0)
{
pageNo = 1;
}
IQueryable <TempPQPersonal> data = db.TempPQPersonals.Include("PQClientMaster").Where(p => p.ClientRowID == ClientRowID);
if (ClientRowID > 0)
{
data = data.Where(b => b.ClientRowID == ClientRowID);
}
if (ClientUserRowID > 0)
{
data = data.Where(p => p.ClientUserRowID == ClientUserRowID);
}
if (!string.IsNullOrEmpty(CaseStatus))
{
if (CaseStatus == "Pendingcandidate")
{
data = data.Where(p => p.OtherDetails != "DEC" && p.OtherDetails != "Approved" && p.OtherDetails == "Pending");
}
if (CaseStatus == "CaseApprpending")
{
data = data.Where(p => p.PQClientMaster.HRApprovalRequired == 1 && p.OtherDetails == "DEC");
}
}
if (!string.IsNullOrEmpty(Search))
{
data = data.Where(b => (b.Name + " " + b.MiddleName + " " + b.LastName).ToString().Contains(Search) || b.ClientRefID == Search || b.CompanyRefNo == Search);
}
if (!string.IsNullOrEmpty(RecievingToDate) && !string.IsNullOrEmpty(RecievingFromDate))
{
DateTime startDate = Convert.ToDateTime(RecievingFromDate);
DateTime EndDate = Convert.ToDateTime(RecievingToDate);
data = data.Where(b => DbFunctions.TruncateTime(b.CreatedDate) >= startDate.Date && DbFunctions.TruncateTime(b.CreatedDate) <= EndDate.Date);
}
switch (sort)
{
default:
data = sortDir == "asc" ? data.OrderBy(d => d.PersonalRowID) : data.OrderByDescending(d => d.PersonalRowID);
break;
}
DashboardClientCandidateListViewModel model = new DashboardClientCandidateListViewModel();
model.PageSize = pageSize;
model.TotalRecords = data.Count();
model.DashboardClientCandidates = data.Skip((pageNo - 1) * pageSize).Take(pageSize).Select(item => new ClientCandidateViewModel
{
PersonalRowID = item.PersonalRowID,
ClientRowID = item.ClientRowID,
ClientName = item.PQClientMaster.MasterAbbreviation.ClientName,
CandidateName = item.Name + " " + item.MiddleName + " " + item.LastName,
CandidateCode = item.CandidateCode,//copy
CompanyRefNo = item.CompanyRefNo,
//OutDate = item.DeliveryDate,
CaseStatus = "DataEntry By Candidate",
CreatedDate = item.CreatedDate,
}).ToList();
return(model);
}
catch (Exception)
{
throw;
}
}
