public CaseStudyGenViewModel GenCaseStudySelectPaged(long SubComponentID, int PageNo, int PageSize, string sTerm)
{
CaseStudyGenViewModel model = new CaseStudyGenViewModel();
var parStart = new SqlParameter("@Start", (PageNo - 1) * PageSize);
var parEnd = new SqlParameter("@PageSize", PageSize);
//return result;
var parSubCompID = new SqlParameter("@SubComponentID", DBNull.Value);
if (SubComponentID != 0)
{
parSubCompID = new SqlParameter("@SubComponentID", SubComponentID);
}
var parSearchTerm = new SqlParameter("@SearchTerm", DBNull.Value);
if (!(sTerm == null || sTerm == ""))
{
parSearchTerm.Value = sTerm;
}
var spOutput = new SqlParameter
{
ParameterName = "@TotalCount",
SqlDbType = System.Data.SqlDbType.BigInt,
Direction = System.Data.ParameterDirection.Output
};
model.CaseStudyList = db.Database.SqlQuery <GenCaseStudyView>("GenCaseStudiesSelectAll @Start, @PageSize,@SearchTerm,@SubComponentID, @TotalCount out",
parStart, parEnd, parSearchTerm, parSubCompID, spOutput).ToList();
model.TotalRecords = int.Parse(spOutput.Value.ToString());
return(model);
}
// GET: CaseStudies
public ActionResult Index(long SCID = 0, int PageNo = 1, int PageSize = 5, string searchTerm = "")
{
CaseStudyManageModel model = new CaseStudyManageModel();
CaseStudyGenViewModel _csmodel = new CaseStudyGenViewModel();
_csmodel = ObjCaseStudies.GenCaseStudySelectPaged(SCID, PageNo, PageSize, searchTerm);
model.GenCaseStudies = _csmodel;
model.Components = ObjComp.GetComponentList("");
model.GenComponentModelList = ObjComp.GetGenComponentList();//Component List
if (Request.IsAjaxRequest())
{
return(PartialView("_pvCaseStudiesList", model));
}
return(View(model));
}
