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());
}
