public async Task <GenTourPackageVM> GetDestinationPackageListAsync(string Destination, int pageno, int pagesize, string sterm) { GenTourPackageVM model = new GenTourPackageVM(); try { var parDest = new SqlParameter("@DestinationName", Destination); var parStart = new SqlParameter("@Start", (pageno - 1) * pagesize); var parEnd = new SqlParameter("@PageSize", pagesize); var parSearchTerm = new SqlParameter("@SearchTerm", DBNull.Value); if (!(sterm == null || sterm == "")) { parSearchTerm.Value = sterm; } // setting stored procedure OUTPUT value // This return total number of rows, and avoid two database call for data and total number of rows var spOutput = new SqlParameter { ParameterName = "@TotalCount", SqlDbType = System.Data.SqlDbType.BigInt, Direction = System.Data.ParameterDirection.Output }; model.PackageList = await db.Database.SqlQuery <GenTourPackageView>("udspGenDestinationPackageList @DestinationName,@Start, @PageSize,@SearchTerm, @TotalCount out", parDest, parStart, parEnd, parSearchTerm, spOutput).ToListAsync(); model.TotalRecords = int.Parse(spOutput.Value.ToString()); return(model); } catch (Exception ex) { throw ex; } }
public async Task <GenTourPackageVM> GenTourPackageList(int PageNo, int PageSize, string SearchTerm) { GenTourPackageVM objVM = new GenTourPackageVM(); objVM = await objDAL.GetGenTourPackageListAsync(PageNo, PageSize, SearchTerm); return(objVM); }
public async Task <GenTourPackageVM> SearchGenTourPackageListAsync(GenSearchModel search) { GenTourPackageVM model = new GenTourPackageVM(); ConvertListToDT objList = new ConvertListToDT(); DataTable subdt = new DataTable(); try { //Converting subject list to datatable if record is present else send empty datatable if (search.TourType != null) { List <IDModel> villList = search.TourType.Select(x => new IDModel() { ID = Convert.ToInt64(x) }).ToList(); subdt = objList.ConvertIEnumerableToDataTable(villList); } else { if (subdt.Columns.Count == 0) { DataColumn col = new DataColumn(); col.ColumnName = "ID"; subdt.Columns.Add(col); } } var parSubDT = new SqlParameter("@TourTypeTable", subdt); parSubDT.SqlDbType = SqlDbType.Structured; parSubDT.TypeName = "dbo.IDType"; var parStart = new SqlParameter("@Start", (search.PageNo - 1) * search.PageSize); var parEnd = new SqlParameter("@PageSize", search.PageSize); var parWhere = new SqlParameter("@Where", DBNull.Value); if (!(search.Where == null || search.Where == "")) { parWhere.Value = search.Where; } // setting stored procedure OUTPUT value // This return total number of rows, and avoid two database call for data and total number of rows var spOutput = new SqlParameter { ParameterName = "@TotalCount", SqlDbType = System.Data.SqlDbType.BigInt, Direction = System.Data.ParameterDirection.Output }; model.PackageList = await db.Database.SqlQuery <GenTourPackageView>("udspGenTourPackageSearch @Start, @PageSize,@Where, @TourTypeTable, @TotalCount out", parStart, parEnd, parWhere, parSubDT, spOutput).ToListAsync(); model.TotalRecords = int.Parse(spOutput.Value.ToString()); return(model); } catch (Exception ex) { throw ex; } }
public ActionResult PackageOfferDetails(int po, int PageNo = 1, int PageSize = 10) { string query = "POID=" + po + "&PageNo=" + PageNo + "&PageSize=" + PageSize; GenTourPackageAPIVM apiModel = objAPI.GetRecordByQueryString<GenTourPackageAPIVM>("tourpackage", "GenOfferPackageByID", query); GenTourPackageVM model = new GenTourPackageVM(); model.OfferPackageList = apiModel.OfferPackageList; model.PagingInfo = new PagingInfo { CurrentPage = PageNo, ItemsPerPage = PageSize, TotalItems = apiModel.TotalRecords }; if (Request.IsAjaxRequest()) { return PartialView("_pvofferpackageList", model); } return View(model); }
public ActionResult TourPackageList(int PageNo = 1, int PageSize = 10, string SearchTerm = "") { ViewBag.ActiveURL = "/general/tourpackagelist"; string query = "PageNo=" + PageNo + "&PageSize=" + PageSize + "&SearchTerm=" + SearchTerm; GenTourPackageAPIVM apiModel = objAPI.GetRecordByQueryString<GenTourPackageAPIVM>("tourpackage", "GenTourPackageList", query); GenTourPackageVM model = new GenTourPackageVM(); model.PackageList = apiModel.TourPackageList; model.PagingInfo = new PagingInfo { CurrentPage = PageNo, ItemsPerPage = PageSize, TotalItems = apiModel.TotalRecords }; if (Request.IsAjaxRequest()) { return PartialView("_pvtourpackageList", model); } return View(model); }
public ActionResult Index() { string query = "PageNo=1&PageSize=10&SearchTerm="; ViewBag.TourPackages = objAPI.GetRecordByQueryString <GenTourPackageVM>("tourpackage", "GenTourPackageList", query).PackageList; ViewBag.Destinations = objAPI.GetAllRecords <utblMstDestination>("clientenquiry", "alldestinations").Take(6); ViewBag.BannerList = objAPI.GetAllRecords <utblMstBanner>("tourpackage", "homebannerlist"); string[] abc = objAPI.GetAllRecords <string>("tourpackage", "wherenames").ToArray(); ViewBag.Where = abc; ViewBag.TourTypes = objAPI.GetAllRecords <utblMstPackageType>("tourpackage", "tourtypes"); //ViewBag.PackagesTypeList = objAPI.GetRecordByQueryString<GenTourPackageVM>("tourpackage", "GenTourPackageDispList", query).PackageList; GenTourPackageVM obj = new GenTourPackageVM(); obj.PackageList = objAPI.GetRecordByQueryString <GenTourPackageVM>("tourpackage", "GenTourPackageDispList", query).PackageList; var pType = (from s in obj.PackageList group s by s.PackageTypeName).ToDictionary(x => x.Key, x => x.ToList()); ViewBag.PType = pType; //offer package list ViewBag.OfferPackage = objAPI.GetAllRecords <GenPackageOfferView>("tourpackage", "GenOfferPackagelist"); ViewBag.TourGuides = objAPI.GetAllRecords <TourGuideListView>("tourpackage", "tourguides"); return(View()); }