public DataSet PropertyList_Sort(ListingBo listBo)
{
var transactionStatus = new TransactionStatus();
var Listing = BuiltPropertyListingDomain(listBo);
Listing.Rating = Listing.Rating == "%" ? null : Listing.Rating;
CemexDb con = new CemexDb();
SqlParameter[] Params =
{
new SqlParameter("@City_Id", Listing.CityMasterId), //0
new SqlParameter("@Room_Checkin", Listing.Room_Checkin), //1
new SqlParameter("@Room_Checkout", Listing.Room_Checkout), //2
new SqlParameter("@No_Of_Rooms", Listing.No_Of_Rooms), //3
new SqlParameter("@Facilities", Listing.Facilities), //3
new SqlParameter("@Price1", Listing.Price1), //3
new SqlParameter("@Price2", Listing.Price2), //3
new SqlParameter("@Rating", Listing.Rating), //3
new SqlParameter("@SortBy", Listing.SortBy), //3
};
//DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_PropertyListing_Sort_New3", Params);
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "USP_GetAllRooms", Params);
return(ds);
}
//PropertyListing
public DataSet PropertyList(ListingBo listBo)
{
var transactionStatus = new TransactionStatus();
var Listing = BuiltPropertyListingDomain(listBo);
CemexDb con = new CemexDb();
SqlParameter[] Params =
{
new SqlParameter("@City_Id", Listing.CityMasterId), //0
new SqlParameter("@Room_Checkin", Listing.Room_Checkin), //1
new SqlParameter("@Room_Checkout", Listing.Room_Checkout), //2
new SqlParameter("@No_Of_Rooms", Listing.No_Of_Rooms), //3
};
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_PropertyListing", Params);
return(ds);
}
private PropertyListing BuiltPropertyListingDomain(ListingBo list)
{
return((PropertyListing) new PropertyListing().InjectFrom(list));
}
