public ActionResult _partialCandidateResult()
{
var result = (dynamic)null;
try
{
string spExecute = "sp_QendidateList @PageNumber = 1 ,@filterbyCreatedDateORmodifiedDate = true,";
DateTime fd = Convert.ToDateTime(BaseUtil.GetCalculatedDateTime(-30));
spExecute += "@fromDate = '" + fd.Date + "',";
DateTime fd1 = Convert.ToDateTime(BaseUtil.GetCurrentDateTime());
spExecute += "@tillDate = '" + fd1.Date + "',";
spExecute += "@isActive = 1 ";
result = db.Database.SqlQuery <sp_QendidateList_Result>(spExecute).ToList();
sp_QendidateList_Result sp = new sp_QendidateList_Result();
decimal pageCount = 0;
if (result.Count > 0)
{
pageCount = (decimal)(result[1].total / 4);
int a = (int)(result[1].total % 4);
if (a > 0)
{
pageCount = pageCount + 1;
}
ViewBag.data = "Yes";
}
else
{
ViewBag.data = "Nodata";
}
sp.PageCount = (int)pageCount;
sp.CurrentPageIndex = 1;
ViewBag.count = pageCount;
ViewBag.currindex = sp.CurrentPageIndex;
}
catch (Exception e)
{
BaseUtil.CaptureErrorValues(e);
ViewBag.data = "Nodata";
}
return(PartialView(result));
}
public ActionResult candidateResult(int currentPageIndex, FormCollection frm)
{
var result = (dynamic)null;
try
{
string spExecute = "sp_QendidateList @PageNumber =" + currentPageIndex + ",";
spExecute += "@filterbyCreatedDateORmodifiedDate = 1 ,";
if (frm["frm[fromdate]"] != "")
{
DateTime fd = Convert.ToDateTime(frm["frm[fromdate]"]);
spExecute += "@fromDate = '" + fd.Date + "',";
}
else
{
DateTime fd = Convert.ToDateTime(BaseUtil.GetCalculatedDateTime(-30));
spExecute += "@fromDate = '" + fd.Date + "',";
}
if (frm["frm[todate]"] != "")
{
DateTime td = Convert.ToDateTime(frm["frm[todate]"]);
spExecute += "@tillDate = '" + td.Date + "',";
}
else
{
DateTime fd = Convert.ToDateTime(BaseUtil.GetCurrentDateTime());
spExecute += "@tillDate = '" + fd.Date + "',";
}
if (frm["frm[name]"] != "")
{
spExecute += "@name = '" + frm["frm[name]"] + "',";
}
else
{
spExecute += "@name = null , ";
}
if (frm["frm[mobile]"] != "")
{
spExecute += "@mobile = '" + frm["frm[mobile]"] + "',";
}
else
{
spExecute += "@mobile = null ,";
}
if (frm["frm[email]"] != "")
{
spExecute += "@email = '" + frm["frm[email]"] + "',";
}
else
{
spExecute += "@email = null ,";
}
if (frm["frm[isActive]"] != null)
{
spExecute += "@isActive = '" + frm["frm[isActive]"] + "'";
}
else
{
spExecute += "@isActive = 1 ";
}
result = db.Database.SqlQuery <sp_QendidateList_Result>(spExecute).ToList();
sp_QendidateList_Result sp = new sp_QendidateList_Result();
decimal pageCount = 0;
if (result.Count > 0)
{
pageCount = (decimal)(result[1].total / 4);
int a = (int)(result[1].total % 4);
if (a > 0)
{
pageCount = pageCount + 1;
}
ViewBag.data = "Yes";
}
else
{
ViewBag.data = "Nodata";
}
sp.PageCount = (int)pageCount;
sp.CurrentPageIndex = currentPageIndex;
ViewBag.count = pageCount;
ViewBag.currindex = currentPageIndex;
}
catch (Exception e)
{
BaseUtil.CaptureErrorValues(e);
ViewBag.data = "Nodata";
}
return(PartialView("_partialCandidateResult", result));
}
