// GET: BadInputData #region "Load Bad Input Data" public ActionResult Index(int?page, int?sortby, int?sortorder, int?pagevalue, string sort = null) { // Clear WorkQueue for Data StewUserActivityCloseWindow(); if (Request.IsAjaxRequest()) { // Set User name in session. CompanyFacade fac = new CompanyFacade(this.CurrentClient.ApplicationDBConnectionString, Helper.UserName); #region Set pagination Code int pageNumber = (page ?? 1); if (!string.IsNullOrEmpty(SessionHelper.CleanMatchPageNo) && pagevalue == null) { pagevalue = Convert.ToInt32(SessionHelper.CleanMatchPageNo); } if (pagevalue == null || Convert.ToInt32(pagevalue) == 0) { SettingFacade sfac = new SettingFacade(this.CurrentClient.ApplicationDBConnectionString); pagevalue = Convert.ToInt32(sfac.GetDefaultPageSize(Helper.oUser.UserId, "BadInputData")); pagevalue = pagevalue == 0 ? 10 : pagevalue; } BadInputDataModel model = new BadInputDataModel(); if (!(sortby.HasValue && sortby.Value > 0)) { sortby = 1; } if (!(sortorder.HasValue && sortorder.Value > 0)) { sortorder = 1; } int totalCount = 0; int pageno = pagevalue.HasValue ? pagevalue.Value : 10; pageno = pageno < 5 ? 5 : pageno; // Set page no , sortorder , sortby and Page size to session ViewBag.SortBy = sortby; ViewBag.SortOrder = sortorder; ViewBag.Page = pageNumber; ViewBag.pageno = pageno; Tuple <List <CompanyEntity>, string> tuplecompany = fac.GetBIDCompany(Helper.oUser.UserId, pageNumber, pageno, out totalCount); model.Companies = tuplecompany.Item1; SessionHelper.CleanQueueMessage = tuplecompany.Item2; SessionHelper.CleanMatchPage = Convert.ToString(pageNumber); SessionHelper.CleanMatchPageNo = Convert.ToString(pageno); SessionHelper.CleanTotalCount = Convert.ToString(totalCount); SessionHelper.CleanMatchedCompany = JsonConvert.SerializeObject(model.Companies); #endregion IPagedList <CompanyEntity> pagedCompany = new StaticPagedList <CompanyEntity>(model.Companies.ToList(), pageNumber, pageno, totalCount);// Set model of Company entity to pass this model to view. return(PartialView("_Index", pagedCompany)); } else { SessionHelper.BadInputData_IsFirstTimeFilter = true; } return(View()); }
public ActionResult FilterCleanData(List <FilterData> filters) { UserSessionFilterEntity filtermodel = new UserSessionFilterEntity(); foreach (var item in filters) { if (item.FieldName == "SrcRecordId") { filtermodel.SrcRecordId = item.FilterValue; } else if (item.FieldName == "CompanyName") { filtermodel.CompanyName = item.FilterValue; } else if (item.FieldName == "City") { filtermodel.City = item.FilterValue; } else if (item.FieldName == "State") { filtermodel.State = item.FilterValue; } else if (item.FieldName == "Country") { filtermodel.CountryISOAlpha2Code = item.FilterValue; } else if (item.FieldName == "ImportProcess") { filtermodel.ImportProcess = item.FilterValue; } else if (item.FieldName == "CountryGroup") { filtermodel.CountryGroupId = Convert.ToInt32(item.FilterValue); } else if (item.FieldName == "Tag") { filtermodel.Tag = item.FilterValue; } else if (item.FieldName == "OrderByColumn") { filtermodel.OrderByColumn = item.FilterValue; } else if (item.FieldName == "ErrorCode") { filtermodel.ErrorCode = item.FilterValue; } } filtermodel.UserId = Helper.oUser.UserId; int pagenumber = 0; if (string.IsNullOrEmpty(Convert.ToString(SessionHelper.BadInputData_IsFirstTimeFilter)) || !SessionHelper.BadInputData_IsFirstTimeFilter) { UserSessionFacade fac = new UserSessionFacade(this.CurrentClient.ApplicationDBConnectionString); fac.InsertOrUpdateUserSessionFilter(filtermodel); pagenumber = 1; } else { if (SessionHelper.BadInputData_IsFirstTimeFilter) { pagenumber = 1; } else { if (!string.IsNullOrEmpty(SessionHelper.CleanMatchPage)) { pagenumber = Convert.ToInt32(SessionHelper.CleanMatchPage); } else { pagenumber = 1; } } } SessionHelper.BadInputData_IsFirstTimeFilter = false; int totalCount = 0; int pagevalue = 0; if (!string.IsNullOrEmpty(SessionHelper.CleanMatchPageNo)) { pagevalue = Convert.ToInt32(SessionHelper.CleanMatchPageNo); } if (pagevalue == null || pagevalue == 0) { SettingFacade sfac = new SettingFacade(this.CurrentClient.ApplicationDBConnectionString); pagevalue = Convert.ToInt32(sfac.GetDefaultPageSize(Helper.oUser.UserId, "BadInputData")); pagevalue = pagevalue == 0 ? 10 : pagevalue; } pagevalue = pagevalue < 5 ? 5 : pagevalue; BadInputDataModel model = new BadInputDataModel(); CompanyFacade cfac = new CompanyFacade(this.CurrentClient.ApplicationDBConnectionString, Helper.UserName); Tuple <List <CompanyEntity>, string> tuplecompany = cfac.GetBIDCompany(Helper.oUser.UserId, 1, pagevalue, out totalCount); model.Companies = tuplecompany.Item1; SessionHelper.CleanQueueMessage = tuplecompany.Item2; SessionHelper.CleanMatchPage = pagenumber.ToString(); SessionHelper.CleanMatchPageNo = Convert.ToString(pagevalue); SessionHelper.CleanTotalCount = Convert.ToString(totalCount); SessionHelper.CleanMatchedCompany = JsonConvert.SerializeObject(model.Companies); IPagedList <CompanyEntity> pagedCompany = new StaticPagedList <CompanyEntity>(model.Companies.ToList(), pagenumber, pagevalue, totalCount);// Set model of Company entity to pass this model to view. return(PartialView("_Index", pagedCompany)); }
public ActionResult GetFilteredCompanyList(int?mode, int?page, int?sortby, int?sortorder, int?pagevalue, string sort = null) { // For Filtration of data . CompanyFacade fac = new CompanyFacade(this.CurrentClient.ApplicationDBConnectionString, Helper.UserName); #region Set Pagination code //Get Current Page size ,page Number. if (!string.IsNullOrEmpty(SessionHelper.CleanMatchPage)) { page = Convert.ToInt32(SessionHelper.CleanMatchPage); } if (!string.IsNullOrEmpty(SessionHelper.CleanMatchPageNo)) { pagevalue = Convert.ToInt32(SessionHelper.CleanMatchPageNo); } if (pagevalue == null || Convert.ToInt32(pagevalue) == 0) { SettingFacade sfac = new SettingFacade(this.CurrentClient.ApplicationDBConnectionString); pagevalue = Convert.ToInt32(sfac.GetDefaultPageSize(Helper.oUser.UserId, "BadInputData")); pagevalue = pagevalue == 0 ? 10 : pagevalue; } int pageNumber = (page ?? 1); BadInputDataModel model = new BadInputDataModel(); if (!(sortby.HasValue && sortby.Value > 0)) { sortby = 1; } if (!(sortorder.HasValue && sortorder.Value > 0)) { sortorder = 1; } int totalCount = 0; int pageno = pagevalue.HasValue ? pagevalue.Value : 10; pageno = pageno < 5 ? 5 : pageno; ViewBag.SortBy = sortby; ViewBag.SortOrder = sortorder; ViewBag.Page = pageNumber; ViewBag.pageno = pageno; #endregion if (!string.IsNullOrEmpty(SessionHelper.CleanMatchedCompany)) //if Company is already in temp data then don't do db call to find company list { model.Companies = JsonConvert.DeserializeObject <List <CompanyEntity> >(SessionHelper.CleanMatchedCompany); totalCount = !string.IsNullOrEmpty(SessionHelper.CleanTotalCount) ? Convert.ToInt32(SessionHelper.CleanTotalCount) : 0; } else { //model.Companies = fac.GetBIDCompany(Helper.oUser.UserId, pageNumber, pageno, out totalCount);//Get Company List if it is not found from the TempData Tuple <List <CompanyEntity>, string> tuplecompany = fac.GetBIDCompany(Helper.oUser.UserId, pageNumber, pageno, out totalCount); model.Companies = tuplecompany.Item1; SessionHelper.CleanQueueMessage = tuplecompany.Item2; } if (sortorder != null && sortby != null) { model.Companies = SortData(model.Companies, Convert.ToInt32(sortorder), Convert.ToInt32(sortby)); } if (totalCount <= 0 && model.Companies.Count == 0 && pageNumber > 1) { totalCount = Convert.ToInt32(pagevalue); } // Set model of Company entity to pass this model to view. IPagedList <CompanyEntity> pagedCompany = new StaticPagedList <CompanyEntity>(model.Companies.ToList(), pageNumber, pageno, totalCount); ViewBag.CloseAlert = "<script type='text/javascript'>$(document).ready(function(){parent.backToparent();});</script>"; if (Request.IsAjaxRequest()) { return(PartialView("_Index", pagedCompany)); } return(View(pagedCompany)); }