//Load Partial Result 1st time
public ActionResult _partialCandidateResultList(int jobid)
{
oriondbEntities db = new oriondbEntities();
DateTime updatbefore = BaseUtil.GetCalculatedDateTime(-365);
string spExecute = ""; var result = (dynamic)null;
try {
spExecute = "sp_candidateSearch @defaultSearch =1 , @modifiedDate='" + updatbefore + "',@PageNumber = 1, @jobID ='" + jobid + "'";
result = db.Database.SqlQuery <sp_candidateSearch_result>(spExecute).ToList();
sp_candidateSearch_result sp = new sp_candidateSearch_result();
if (result != null)
{
sp.PageCount = result[0].PageCount;
}
else
{
sp.PageCount = 1;
}
ViewBag.defaultSearch = 1;
sp.CurrentPageIndex = 1;
ViewBag.totalpages = sp.PageCount;
}
catch (Exception e)
{
BaseUtil.CaptureErrorValues(e);
TempData["saveResult"] = "";
}
return(PartialView("_partialCandidateResult", result));
}
public ActionResult _partialSkillsResultList()
{
oriondbEntities db = new oriondbEntities();
string spExecute = "sp_skillsList @PageNumber = 1 ,@filterbyCreatedDateORmodifiedDate = true";
var result = db.Database.SqlQuery <sp_skillsList_Result>(spExecute).ToList();
sp_skillsList_Result sp = new sp_skillsList_Result();
double pageCount = Convert.ToDouble(result[1].total / 2);
sp.PageCount = (int)Math.Ceiling(pageCount);
sp.CurrentPageIndex = 1;
ViewBag.count = pageCount;
ViewBag.data = "Yes";
ViewBag.currindex = sp.CurrentPageIndex;
return(PartialView(result));
}
public BaseClass()
{
db = new oriondbEntities();
}
public ActionResult skillsResultList(int currentPageIndex, FormCollection frm)
{
oriondbEntities db = new oriondbEntities();
string spExecute = "sp_skillsList @PageNumber =" + currentPageIndex + ",";
if (frm["frm[radio0]"] != null)
{
spExecute += "@filterbyCreatedDateORmodifiedDate =" + frm["frm[radio0]"] + ",";
}
else
{
spExecute += "@filterbyCreatedDateORmodifiedDate = 1 ,";
}
if (frm["frm[name]"] != "")
{
spExecute += "@skillName = '" + frm["frm[name]"] + "',";
}
else
{
spExecute += "@skillName = null , ";
}
if (frm["frm[isActive]"] != null)
{
spExecute += "@isActive = " + frm["frm[isActive]"] + "";
}
else
{
spExecute += "@isActive = 1 ";
}
var result = db.Database.SqlQuery <sp_skillsList_Result>(spExecute).ToList();
sp_skillsList_Result sp = new sp_skillsList_Result();
double pageCount;
if (result.Count == 1)
{
pageCount = Convert.ToDouble(result.Count);
sp.PageCount = (int)Math.Ceiling(pageCount);
sp.PageCount = Convert.ToInt32(pageCount);
sp.CurrentPageIndex = currentPageIndex;
ViewBag.count = pageCount;
ViewBag.data = "Yes";
ViewBag.currindex = currentPageIndex;
}
else if (result.Count > 1)
{
pageCount = Convert.ToDouble((result.Count) / 2);
sp.PageCount = (int)Math.Ceiling(pageCount);
sp.PageCount = Convert.ToInt32(pageCount);
sp.CurrentPageIndex = currentPageIndex;
ViewBag.count = pageCount;
ViewBag.data = "Yes";
ViewBag.currindex = currentPageIndex;
}
else
{
ViewBag.data = "Nodata";
}
return(PartialView("_partialSkillsResultList", result));
}
public UnitOfWork()
{
_db = new oriondbEntities();
}
