public ActionResult _partialEmployerListResult()
{
var result = (dynamic)null;
try
{
string spExecute = "sp_EmployerList @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_EmployerList_Result>(spExecute).ToList();
//var emp = repo.SQLQuery<sp_EmployerList_Result>("sp_EmployerList @PageNumber, @filterbyCreatedDateORmodifiedDate", new SqlParameter("PageNumber", SqlDbType.Int) { Value = 1},new SqlParameter("filterbyCreatedDateORmodifiedDate", SqlDbType.Bit) { Value = 0}).ToList();
sp_EmployerList_Result sp = new sp_EmployerList_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 EmployerListResult(int currentPageIndex, FormCollection frm)
{
var result = (dynamic)null;
try {
string spExecute = "sp_EmployerList @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[companyname]"] != "")
{
spExecute += "@ComapnyName = '" + frm["frm[companyname]"] + "',";
}
else
{
spExecute += "@ComapnyName = null , ";
}
if (frm["frm[employername]"] != "")
{
spExecute += "@EmployerName = '" + frm["frm[employername]"] + "',";
}
else
{
spExecute += "@EmployerName = 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_EmployerList_Result>(spExecute).ToList();
sp_EmployerList_Result sp = new sp_EmployerList_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.CurrentPageIndex = currentPageIndex;
ViewBag.count = pageCount;
ViewBag.currindex = currentPageIndex;
}
catch (Exception e)
{
BaseUtil.CaptureErrorValues(e);
ViewBag.data = "Nodata";
}
return(PartialView("_partialEmployerListResult", result));
}