public HPDCondition GetCondition(string searchid, string hotelcode, string CurrencyCode) { HPDCondition Hapc = new HPDCondition(); DataTable dssearch = HotelDBLayer.GetSearch(searchid); int guestcount = Convert.ToInt16(dssearch.Rows[0]["Adults"].ToString()) + Convert.ToInt16(dssearch.Rows[0]["Children"].ToString()); try { Hapc.HotelCode = hotelcode; } catch { Hapc.HotelCode = ""; } try { Hapc.rooms = Convert.ToInt32(dssearch.Rows[0]["Rooms"]).ToString(); } catch { Hapc.checkin = ""; } try { Hapc.checkin = Convert.ToDateTime(dssearch.Rows[0]["CheckInDt"]).ToString("yyyy-MM-dd"); } catch { Hapc.checkin = ""; } try { Hapc.checkout = Convert.ToDateTime(dssearch.Rows[0]["CheckOutDt"]).ToString("yyyy-MM-dd"); } catch { Hapc.checkout = ""; } try { Hapc.guestcount = guestcount.ToString(); } catch { Hapc.guestcount = ""; } try { Hapc.Adult = dssearch.Rows[0]["Adults"].ToString(); } catch { } try { Hapc.children = Convert.ToInt32(dssearch.Rows[0]["Children"].ToString()); } catch { } try { Hapc.childrenage = dssearch.Rows[0]["HB_ChildAge"].ToString(); } catch { } if (CurrencyCode == "") { Hapc.CurrencyCode = "USD"; } else { Hapc.CurrencyCode = CurrencyCode; } return(Hapc); }
public AvailabilityRS GetDataChangedate(string SearchID, string hotelcode, string rooms, string checkin, string checkout, string adult, string children, string childrenage, string gc, string CurrencyCode, string b2c_idn) { //HotelPropertyAj hpr = null; AvailabilityRS objAvailabilityRS = new AvailabilityRS(); //string filePathContext = Path.Combine(HttpRuntime.AppDomainAppPath, "HotelXML/" + SearchID + "_ContextChange-RS.xml"); //if (File.Exists(filePathContext)) //{ // ContextResult = File.ReadAllText(filePathContext); //} //else //{ // ContextResult = XMLRead.ContextChange(searchid); //} try { searchid = SearchID; objfavicons = new ClsFevicons(); CultureInfo cultureInfo = Thread.CurrentThread.CurrentCulture; TextInfo = cultureInfo.TextInfo; //string filePathRQ = Path.Combine(HttpRuntime.AppDomainAppPath, "HotelXML/" + searchid + "_propertydesc_" + hotelcode + "_" + CurrencyCode + "-RS.xml"); string filePathRQ = Path.Combine(HttpRuntime.AppDomainAppPath, "HotelXML/" + searchid + "_propertydesc_" + hotelcode + "_" + CurrencyCode + "_hotelsAvail-RS.xml"); XmlDataDocument xmldoc = new XmlDataDocument(); if (File.Exists(filePathRQ)) { FileStream fs = new FileStream(filePathRQ, FileMode.Open, FileAccess.Read); xmldoc.Load(fs); fs.Close(); XmlNode xnod = xmldoc.DocumentElement; XmlSerializer deserializer = new XmlSerializer(typeof(AvailabilityRS)); StreamReader reader = new StreamReader(filePathRQ); objAvailabilityRS = (AvailabilityRS)deserializer.Deserialize(reader); } else { DataTable dssearch = HotelDBLayer.GetSearch(searchid); HPDCondition Hapc = GetCondition(searchid, hotelcode, CurrencyCode); result = gethdata(Hapc, ContextResult, searchid, CurrencyCode, b2c_idn); filePathRQ = Path.Combine(HttpRuntime.AppDomainAppPath, "HotelXML/" + searchid + "_propertydesc_" + hotelcode + "_" + CurrencyCode + "_hotelsAvail-RS.xml"); FileStream fs = new FileStream(filePathRQ, FileMode.Open, FileAccess.Read); xmldoc.Load(fs); fs.Close(); XmlNode xnod = xmldoc.DocumentElement; XmlSerializer deserializer = new XmlSerializer(typeof(AvailabilityRS)); StreamReader reader = new StreamReader(filePathRQ); objAvailabilityRS = (AvailabilityRS)deserializer.Deserialize(reader); if (!File.Exists(filePathRQ)) { File.WriteAllText(filePathRQ, objAvailabilityRS.Xmlns); } } } catch { } return(objAvailabilityRS); }
// // GET: /HotelFilters/ public string GetHFilters(string searchid) { string rvalue = ""; DataTable dssearch = HotelDBLayer.GetSearch(searchid); string HLFPath = Path.Combine(HttpRuntime.AppDomainAppPath, "HotelXML/" + searchid + "_HotelData.xml"); DataSet ds = new DataSet(); ds.ReadXml(HLFPath); DataTable Hotellist = ds.Tables[0]; return(rvalue); }
public static string GetDataroom(string SearchID, string hotelcode, string CurrencyCode, string b2c_idn) { string filePathRQ = string.Empty; AvailabilityRS objAvailabilityRS = new AvailabilityRS(); ManageHDetAj objManageHDetAj = new ManageHDetAj(); string result = string.Empty; try { string searchid = SearchID; ClsFevicons objfavicons; objfavicons = new ClsFevicons(); CultureInfo cultureInfo = Thread.CurrentThread.CurrentCulture; // TextInfo = cultureInfo.TextInfo; //string filePathRQ = Path.Combine(HttpRuntime.AppDomainAppPath, "HotelXML/" + searchid + "_propertydesc_" + hotelcode + "_" + CurrencyCode + "-RS.xml"); filePathRQ = Path.Combine(HttpRuntime.AppDomainAppPath, "HotelXML/" + searchid + "_" + CurrencyCode + "_hotelsAvail-RS.xml"); XmlDataDocument xmldoc = new XmlDataDocument(); if (File.Exists(filePathRQ)) { FileStream fs = new FileStream(filePathRQ, FileMode.Open, FileAccess.Read); xmldoc.Load(fs); fs.Close(); XmlNode xnod = xmldoc.DocumentElement; XmlSerializer deserializer = new XmlSerializer(typeof(AvailabilityRS)); StreamReader reader = new StreamReader(filePathRQ); result = File.ReadAllText(filePathRQ); objAvailabilityRS = (AvailabilityRS)deserializer.Deserialize(reader); } else { DataTable dssearch = HotelDBLayer.GetSearch(searchid); HPDCondition Hapc = objManageHDetAj.GetCondition(searchid, hotelcode, CurrencyCode); result = objManageHDetAj.gethdata(Hapc, ContextResult, searchid, CurrencyCode, b2c_idn); filePathRQ = Path.Combine(HttpRuntime.AppDomainAppPath, "HotelXML/" + searchid + "_propertydesc_" + hotelcode + "_" + CurrencyCode + "_hotelsAvail-RS.xml"); FileStream fs = new FileStream(filePathRQ, FileMode.Open, FileAccess.Read); xmldoc.Load(fs); fs.Close(); XmlNode xnod = xmldoc.DocumentElement; XmlSerializer deserializer = new XmlSerializer(typeof(AvailabilityRS)); StreamReader reader = new StreamReader(filePathRQ); objAvailabilityRS = (AvailabilityRS)deserializer.Deserialize(reader); result = File.ReadAllText(filePathRQ); if (!File.Exists(filePathRQ)) { File.WriteAllText(filePathRQ, objAvailabilityRS.Xmlns); } } } catch { } return(result); }
public string Get(string searchid, string curcode, string b2c_idn) { string rvalue = "N"; try { string checkind = ""; string checkoutd = ""; string selroom = ""; string seladults = ""; string selchildren = ""; string seladultsbyroom = ""; string selchildrenbyroom = ""; string city = ""; int guestcount = 1; string childrenages = ""; DataTable dssearch = HotelDBLayer.GetSearch(searchid); city = dssearch.Rows[0]["Destination"].ToString(); checkind = Convert.ToDateTime(dssearch.Rows[0]["CheckInDt"]).ToString("yyyy-MM-dd"); checkoutd = Convert.ToDateTime(dssearch.Rows[0]["CheckOutDt"]).ToString("yyyy-MM-dd"); selroom = dssearch.Rows[0]["Rooms"].ToString(); seladults = dssearch.Rows[0]["Adults"].ToString(); seladultsbyroom = dssearch.Rows[0]["HB_AdultsByRoom"].ToString(); selchildren = dssearch.Rows[0]["Children"].ToString(); selchildrenbyroom = dssearch.Rows[0]["HB_ChildrenByRoom"].ToString(); guestcount = Convert.ToInt16(dssearch.Rows[0]["Adults"].ToString()) + Convert.ToInt16(dssearch.Rows[0]["Children"].ToString()); childrenages = dssearch.Rows[0]["HB_ChildAge"].ToString(); HACondition Hac = GetSearchConditon(city, checkind, checkoutd, guestcount.ToString(), Convert.ToInt32(selroom), Convert.ToInt32(seladults), seladultsbyroom, Convert.ToInt32(selchildren), selchildrenbyroom, childrenages, curcode.Trim()); HotelSearchAj hs = new HotelSearchAj(Hac, searchid, b2c_idn); DataTable dtHList = hs.dtBPIadd; DataSet ds = new DataSet(); ds.Tables.Add(dtHList); // string HLFPath = Path.Combine(HttpRuntime.AppDomainAppPath, "HotelAvail/" + searchid + "_" + curcode + "_HotelList.xml");//yogi //string HLFPath = Path.Combine(HttpRuntime.AppDomainAppPath, "HotelXML/" + searchid + "_" + curcode + "_hotelsAvail-RS"); //ds.WriteXml(HLFPath); rvalue = "Y"; } catch (Exception ex) { rvalue = "N"; } return(rvalue); }
private HPDCondition GetCondition(string hotelcode) { HPDCondition Hapc = new HPDCondition(); DataTable dssearch = HotelDBLayer.GetSearch(searchid); int guestcount = Convert.ToInt16(dssearch.Rows[0]["Adults"].ToString()) + Convert.ToInt16(dssearch.Rows[0]["Children"].ToString()); try { Hapc.HotelCode = hotelcode; } catch { Hapc.HotelCode = ""; } try { Hapc.checkin = Convert.ToDateTime(dssearch.Rows[0]["CheckInDt"]).ToString("MM-dd"); } catch { Hapc.checkin = ""; } try { Hapc.checkout = Convert.ToDateTime(dssearch.Rows[0]["CheckOutDt"]).ToString("MM-dd"); } catch { Hapc.checkout = ""; } try { Hapc.guestcount = guestcount.ToString(); } catch { Hapc.guestcount = ""; } return(Hapc); }
//public HotelProperty GetData(string SearchID,string contextresult,string hotelcode ) public HotelProperty GetData(string SearchID, string hotelcode) { HotelProperty hpr = null; string filePathContext = Path.Combine(HttpRuntime.AppDomainAppPath, "HotelXML/" + SearchID + "_ContextChange-RS.xml"); if (File.Exists(filePathContext)) { ContextResult = File.ReadAllText(filePathContext); } else { ContextResult = XMLRead.ContextChange(SearchID); } try { searchid = SearchID; objfavicons = new ClsFevicons(); CultureInfo cultureInfo = Thread.CurrentThread.CurrentCulture; TextInfo = cultureInfo.TextInfo; // string filePathRQ = Path.Combine(HttpRuntime.AppDomainAppPath, "HotelProperty/" + searchid + "_" + hotelcode + "_PropertyData.xml"); string filePathRQ = Path.Combine(HttpRuntime.AppDomainAppPath, "HotelXML/" + searchid + "_propertydesc_" + hotelcode + "-RS.xml"); if (File.Exists(filePathRQ)) { string result = File.ReadAllText(filePathRQ); hpr = new HotelProperty(result, hotelcode, searchid); } else { DataTable dssearch = HotelDBLayer.GetSearch(searchid); HPDCondition Hapc = GetCondition(hotelcode); hpr = new HotelProperty(Hapc, ContextResult, searchid); if (!File.Exists(filePathRQ)) { File.WriteAllText(filePathRQ, hpr.PropertyXmlResult); } } } catch { } return(hpr); }
public checkresult Get(string searchid, string hcode, string ratekey, string b2c_idn) { double admarkup = 0.00; double adroommarkup = 0.00; double adpercmarkup = 0.00; double clpercmarkup = 0.00; double adperdiscount = 0.00; double clperdiscount = 0.00; double clmarkup = 0.00; double finalmarkup = 0.00; double finaldiscount = 0.00; double addiscount = 0.00; double cldiscount = 0.00; double baseamount = 0.00; double roombaseamount = 0.00; double roomamountwithouttax = 0.00; double roomamountwithtax = 0.00; double adroompercmarkup = 0.00; double clroompercmarkup = 0.00; double adroomperdiscount = 0.00; double clroomperdiscount = 0.00; double clroommarkup = 0.00; double finalroommarkup = 0.00; double finalroomdiscount = 0.00; double adroomdiscount = 0.00; double clroomdiscount = 0.00; double rrate; double roomtaxprice = 0.00; double eachroomavgtaxprice = 0.00; double roomcancellationprice = 0.00; double troomspricepernightwithmarkup = 0.00; double eachroomspernihgtpricewmrk = 0.00; string ratetable = string.Empty; double allroomsprice = 0.00; string filePathRQ = string.Empty; ManageHDetAj mhd = new ManageHDetAj(); string Result = string.Empty; AvailabilityRS objAvailabilityRS = new AvailabilityRS(); CheckRateRS objCheckRateRS = new CheckRateRS(); List <upselling> lstupselling = new List <upselling>(); Rooms objRooms = new Rooms(); Room objupsellingRoom = new Room(); checkresult objchkres = new checkresult(); DataTable dssearch = HotelDBLayer.GetSearch(searchid); int rooms = Convert.ToInt32(dssearch.Rows[0]["Rooms"]); checkrates(searchid, hcode, ratekey, b2c_idn); string[] ratekeys = ratekey.Split(','); string ratekey_split = ratekeys[0].Substring(ratekeys[0].Length - 4); try { ClsFevicons objfavicons; objfavicons = new ClsFevicons(); CultureInfo cultureInfo = Thread.CurrentThread.CurrentCulture; // TextInfo = cultureInfo.TextInfo; //string filePathRQ = Path.Combine(HttpRuntime.AppDomainAppPath, "HotelXML/" + searchid + "_propertydesc_" + hotelcode + "_" + CurrencyCode + "-RS.xml"); filePathRQ = Path.Combine(HttpRuntime.AppDomainAppPath, "Checkrates_tbluexml/" + searchid + "_" + ratekey_split + "_checkrate-RS.xml"); if (File.Exists(filePathRQ)) { XmlDataDocument xmldoc = new XmlDataDocument(); FileStream fs = new FileStream(filePathRQ, FileMode.Open, FileAccess.Read); xmldoc.Load(fs); fs.Close(); XmlNode xnod = xmldoc.DocumentElement; XmlSerializer deserializer = new XmlSerializer(typeof(CheckRateRS)); StreamReader reader = new StreamReader(filePathRQ); objCheckRateRS = (CheckRateRS)deserializer.Deserialize(reader); if (objCheckRateRS.Error == null) { double dc = 0.0; try { dc = (Convert.ToDateTime(objCheckRateRS.Hotel.CheckOut.ToString()) - Convert.ToDateTime(objCheckRateRS.Hotel.CheckIn.ToString())).TotalDays; } catch { } string cancleplFrom = ""; string cancleplamount = ""; foreach (Room objrooms in objCheckRateRS.Hotel.Rooms.Room) { Rates objrates = new Rates(); objrates = objrooms.Rates; List <Rate> lstRate = objrates.Rate; if (lstRate != null && lstRate.Count > 0) { for (int r = 0; r < lstRate.Count; r++) { // eachroomsprice = Convert.ToDouble(troomsprice / norooms); rrate = Convert.ToDouble(Convert.ToDouble(Convert.ToDouble(lstRate[r].Net) / dc).ToString("0.00")); string avgpnignt = Convert.ToDouble(rrate).ToString(); //string avgroompernight = (Convert.ToDouble(avgpnignt) / dc).ToString("0.00"); roombaseamount = Convert.ToDouble(avgpnignt); DataTable dtwt = new DataTable(); SqlConnection sqlconwt = new SqlConnection(con); try { SqlCommand cmd = new SqlCommand(); cmd.Connection = sqlconwt; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "p_SreTS_HDR"; cmd.Parameters.AddWithValue("@B2C_IDN", b2c_idn); cmd.Parameters.AddWithValue("@Hotelcode", hcode); cmd.Parameters.AddWithValue("@GDS", "HB"); cmd.Parameters.AddWithValue("@IsLoginCust", "Y"); SqlDataAdapter sa = new SqlDataAdapter(cmd); sa.Fill(dtwt); } catch { } if (dtwt.Rows.Count > 0) { string Ts_mode = string.Empty; Ts_mode = dtwt.Rows[0]["TS_Mode"].ToString(); if (Ts_mode == "Fixed") { adroommarkup = Convert.ToDouble(dtwt.Rows[0]["TS_Markup"].ToString()); adroomdiscount = Convert.ToDouble(dtwt.Rows[0]["TS_Discount"].ToString()); } else if (Ts_mode == "Percentage") { adroompercmarkup = Convert.ToDouble(dtwt.Rows[0]["TS_Markup"].ToString()); adroommarkup = ((roombaseamount / 100.00) * adroompercmarkup); adroomperdiscount = Convert.ToDouble(dtwt.Rows[0]["TS_Discount"].ToString()); adroomdiscount = (((roombaseamount) / 100.00) * adroomperdiscount); } else { adroommarkup = 0.00; adroomdiscount = 0.00; } string Cl_Mode = string.Empty; Cl_Mode = dtwt.Rows[0]["Cl_Mode"].ToString(); if (Cl_Mode == "Fixed") { clmarkup = Convert.ToDouble(dtwt.Rows[0]["Cl_Markup"].ToString()); cldiscount = Convert.ToDouble(dtwt.Rows[0]["Cl_Discount"].ToString()); } else if (Cl_Mode == "Percentage") { clroompercmarkup = Convert.ToDouble(dtwt.Rows[0]["Cl_Markup"].ToString()); clroommarkup = (((roombaseamount) / (100)) * clroompercmarkup); clroomperdiscount = Convert.ToDouble(dtwt.Rows[0]["Cl_Discount"].ToString()); clroomdiscount = ((roombaseamount / 100.00) * clroomperdiscount); } else { clmarkup = 0.00; } finalroommarkup = adroommarkup + clroommarkup; finalroomdiscount = adroomdiscount + clroomdiscount; roombaseamount = roombaseamount + (finalroommarkup - finalroomdiscount); roomamountwithouttax = (Convert.ToDouble(roombaseamount)); // roombaseamount = (Convert.ToDouble(roomamountwithouttax) + Convert.ToDouble(tax)); troomspricepernightwithmarkup = troomspricepernightwithmarkup + (Convert.ToDouble(roomamountwithouttax)); allroomsprice = allroomsprice + Convert.ToDouble(lstRate[r].Net); } if (lstRate[r].Taxes != null && lstRate[r].Taxes.Tax.Amount != null) { roomtaxprice = roomtaxprice + Convert.ToDouble(lstRate[r].Taxes.Tax.Amount.ToString()); } try { if (lstRate[r].CancellationPolicies != null && lstRate[r].CancellationPolicies.CancellationPolicy.Amount != null) { roomcancellationprice = roomcancellationprice + Convert.ToDouble(lstRate[r].CancellationPolicies.CancellationPolicy.Amount.ToString()); } } catch { //cancleplamount = "NO Cancellation amount"; } } eachroomspernihgtpricewmrk = (troomspricepernightwithmarkup / rooms); eachroomavgtaxprice = Convert.ToDouble(roomtaxprice / rooms); //lstRate.Add(dr.Rates.Rate.Where(n => n.BoardCode == boardCode && (n.ChildrenAges.Contains(',') ? n.ChildrenAges.Split(',')[0].ToString() : n.ChildrenAges) == (childAges.Contains(',') ? childAges.Split(',')[0].ToString() : childAges)).FirstOrDefault()); //foreach (Rate drrt in lstRate) //{ //var roomamt = rooms[i].Room[i].Rates.Rate[n].Net; string ratetype = lstRate[0].RateType; string ratecommentid = string.Empty; try { ratecommentid = lstRate[0].RateCommentsId; } catch { } try { cancleplFrom = lstRate[0].CancellationPolicies.CancellationPolicy.From.ToString(); } catch { } try { cancleplamount = roomcancellationprice.ToString("0.00");//roomcancellationprice.ToString(); } catch { //cancleplamount = "NO Cancellation amount"; } ratetable = GetRateTable(hcode, objCheckRateRS, lstRate, hcode, searchid, "USD", adroommarkup, clroommarkup, adroomdiscount, clroomdiscount, roomtaxprice, b2c_idn, rooms);//HttpUtility.HtmlEncode( } } //objchkres.amount = Convert.ToDouble(Convert.ToDouble(objCheckRateRS.Hotel.Rooms.Room[0].Rates.Rate[0].Net) / dc).ToString("0.00"); objchkres.amount = eachroomspernihgtpricewmrk.ToString("0.00"); objchkres.allroomstamount = allroomsprice.ToString("0.00"); objchkres.cancellationamt = cancleplamount; objchkres.cancellationfrom = cancleplFrom; objchkres.roomdetailstable = ratetable; try { //List<Tax> lsttax = new List<Tax>(); //foreach (var lttax in objCheckRateRS.Hotel.Rooms.Room[0].Rates.Rate[0].Taxes.Tax) //{ if (objCheckRateRS.Hotel.Rooms.Room[0].Rates.Rate[0].Taxes.Tax.Amount != null) { objchkres.Tax = eachroomavgtaxprice.ToString();//Convert.ToDouble(Convert.ToDouble(objCheckRateRS.Hotel.Rooms.Room[0].Rates.Rate[0].Taxes.Tax.Amount)).ToString("0.00"); } else { objchkres.Tax = "0.00"; } //} } catch { objchkres.Tax = "0.00"; } //HotelListGenerate.CreateTables(dtBPIadd); //HotelListGenerate.FillHStable(xnod, dtBPIadd);//yogi } else { objchkres.Message = "Fare Not Available"; } } } catch { objchkres.Message = "Fare Not Available"; } return(objchkres); }
private string GetRateTable(string RPH, CheckRateRS hpr, List <Rate> lstRate, string hcode, string searchid, string curcode, double admarkup, double clmarkup, double addiscount, double cldiscount, double roomtaxprice, string b2c_idn, int norooms)// DataRow dr, { string rvalue = ""; List <Rooms> lstRooms = new List <Rooms>(); Room objRoom = new Room(); double rrate = 0.00; double adroommarkup = 0.00; double roombaseamount = 0.00; double roomamountwithouttax = 0.00; double adroompercmarkup = 0.00; double clroompercmarkup = 0.00; double adroomperdiscount = 0.00; double clroomperdiscount = 0.00; double clroommarkup = 0.00; double finalroommarkup = 0.00; double finalroomdiscount = 0.00; double adroomdiscount = 0.00; double clroomdiscount = 0.00; DataTable dts = HotelDBLayer.GetSearch(searchid); DateTime checkindt = Convert.ToDateTime(hpr.Hotel.CheckIn); DateTime checkoutdt = Convert.ToDateTime(hpr.Hotel.CheckOut); norooms = Convert.ToInt32(dts.Rows[0]["Rooms"].ToString()); double dc = 0.0; try { dc = (Convert.ToDateTime(checkoutdt.ToString()) - Convert.ToDateTime(checkindt.ToString())).TotalDays; } catch { } DateTime startweekdate = checkindt.AddDays(-(int)checkindt.DayOfWeek); DateTime endweekdate = checkoutdt.AddDays(-(int)checkoutdt.DayOfWeek).AddDays(6); double noofdays = (endweekdate - startweekdate).TotalDays; decimal noofweeks = Decimal.Ceiling(Convert.ToDecimal(noofdays) / 7); string strtable = "<table width='100%' border='0' cellspacing='0' cellpadding='0' class='week-table-main'>"; strtable += "<tbody><tr><td>"; strtable += "<table width='100%' border='0' cellspacing='0' cellpadding='0' class='week-days'>"; strtable += "<tbody><tr><td> </td><td>Sun</td><td>mon</td><td>tue</td><td>wed</td><td>thu</td><td>fri</td> <td>sat</td> </tr></tbody></table>"; strtable += "</td></tr><tr><td> <table width='100%' border='0' cellspacing='0' cellpadding='0' class='price-details'><tbody>"; DataRow[] hpraterangerow = null; try { // hpraterangerow = hpr.HP_RateRange.Select("HotelPricingID='" + hotelpricingrow[0]["HotelPricingID"].ToString() + "'"); } catch { } DataTable dtr = new DataTable(); dtr.Columns.Add("id"); dtr.Columns.Add("amount"); dtr.Columns.Add("taxes"); dtr.Columns.Add("surcharges"); dtr.Columns.Add("expdate", typeof(DateTime)); dtr.Columns.Add("effedate", typeof(DateTime)); dtr.Columns.Add("hid"); int r = 1; foreach (var rate in lstRate) { double troomspricepernightwithmarkup = 0.00; // eachroomsprice = Convert.ToDouble(troomsprice / norooms); rrate = Convert.ToDouble(Convert.ToDouble(Convert.ToDouble(lstRate[r - 1].Net) / dc).ToString("0.00")); string avgpnignt = Convert.ToDouble(rrate).ToString(); //string avgroompernight = (Convert.ToDouble(avgpnignt) / dc).ToString("0.00"); roombaseamount = Convert.ToDouble(avgpnignt); DataTable dtwt = new DataTable(); SqlConnection sqlconwt = new SqlConnection(con); try { SqlCommand cmd = new SqlCommand(); cmd.Connection = sqlconwt; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "p_SreTS_HDR"; cmd.Parameters.AddWithValue("@B2C_IDN", b2c_idn); cmd.Parameters.AddWithValue("@Hotelcode", hcode); cmd.Parameters.AddWithValue("@GDS", "HB"); cmd.Parameters.AddWithValue("@IsLoginCust", "Y"); SqlDataAdapter sa = new SqlDataAdapter(cmd); sa.Fill(dtwt); } catch { } if (dtwt.Rows.Count > 0) { string Ts_mode = string.Empty; Ts_mode = dtwt.Rows[0]["TS_Mode"].ToString(); if (Ts_mode == "Fixed") { adroommarkup = Convert.ToDouble(dtwt.Rows[0]["TS_Markup"].ToString()); adroomdiscount = Convert.ToDouble(dtwt.Rows[0]["TS_Discount"].ToString()); } else if (Ts_mode == "Percentage") { adroompercmarkup = Convert.ToDouble(dtwt.Rows[0]["TS_Markup"].ToString()); adroommarkup = ((roombaseamount / 100.00) * adroompercmarkup); adroomperdiscount = Convert.ToDouble(dtwt.Rows[0]["TS_Discount"].ToString()); adroomdiscount = (((roombaseamount) / 100.00) * adroomperdiscount); } else { adroommarkup = 0.00; adroomdiscount = 0.00; } string Cl_Mode = string.Empty; Cl_Mode = dtwt.Rows[0]["Cl_Mode"].ToString(); if (Cl_Mode == "Fixed") { clmarkup = Convert.ToDouble(dtwt.Rows[0]["Cl_Markup"].ToString()); cldiscount = Convert.ToDouble(dtwt.Rows[0]["Cl_Discount"].ToString()); } else if (Cl_Mode == "Percentage") { clroompercmarkup = Convert.ToDouble(dtwt.Rows[0]["Cl_Markup"].ToString()); clroommarkup = (((roombaseamount) / (100)) * clroompercmarkup); clroomperdiscount = Convert.ToDouble(dtwt.Rows[0]["Cl_Discount"].ToString()); clroomdiscount = ((roombaseamount / 100.00) * clroomperdiscount); } else { clmarkup = 0.00; } finalroommarkup = adroommarkup + clroommarkup; finalroomdiscount = adroomdiscount + clroomdiscount; roombaseamount = roombaseamount + (finalroommarkup - finalroomdiscount); roomamountwithouttax = (Convert.ToDouble(roombaseamount)); // roombaseamount = (Convert.ToDouble(roomamountwithouttax) + Convert.ToDouble(tax)); troomspricepernightwithmarkup = troomspricepernightwithmarkup + (Convert.ToDouble(roomamountwithouttax)); } DataRow drp = dtr.NewRow(); drp[0] = 0; drp[1] = troomspricepernightwithmarkup.ToString("0.00"); //roomdescrow[0]["RatePernight"]; drp[2] = 0; drp[3] = 0; drp[4] = "2019-" + checkoutdt.ToString("MM-dd"); drp[5] = "2019-" + checkindt.ToString("MM-dd"); drp[6] = 1; dtr.Rows.Add(drp); strtable += "<tr><td>Room" + (r) + "</td>"; for (int i = 0; i < noofweeks; i++) { strtable += "<tr><td>Week" + (i + 1) + "</td>"; for (int j = 0; j < 7; j++) { DateTime chkdate = startweekdate.AddDays((7 * i) + j); if (checkoutdt == chkdate) { strtable += "<td> </td>"; } else { var perDays = rate.Net.ToString(); var perDay = Convert.ToDouble(perDays) / dc; strtable += "<td>" + "$" + GetDayRate(dtr, r, chkdate.ToString("MM-dd-yyyy")) + "</td>"; } } strtable += "</tr>"; } r++; } strtable += "</tbody> </table> </td> </tr> </tbody></table>"; return(strtable); }
private string GetRateTable(string RPH, HotelProperty hpr, DataRow dr, string searchid) { string rvalue = ""; DataTable dts = HotelDBLayer.GetSearch(searchid); DateTime checkindt = Convert.ToDateTime(dts.Rows[0]["CheckInDt"]); DateTime checkoutdt = Convert.ToDateTime(dts.Rows[0]["CheckOutDt"]); DateTime startweekdate = checkindt.AddDays(-(int)checkindt.DayOfWeek); DateTime endweekdate = checkoutdt.AddDays(-(int)checkoutdt.DayOfWeek).AddDays(6);; double noofdays = (endweekdate - startweekdate).TotalDays; decimal noofweeks = Decimal.Ceiling(Convert.ToDecimal(noofdays) / 7); string strtable = "<table width='100%' border='0' cellspacing='0' cellpadding='0' class='week-table-main'>"; strtable += "<tbody><tr><td>"; strtable += "<table width='100%' border='0' cellspacing='0' cellpadding='0' class='week-days'>"; strtable += "<tbody><tr><td> </td><td>Sun</td><td>mon</td><td>tue</td><td>wed</td><td>thu</td><td>fri</td> <td>sat</td> </tr></tbody></table>"; strtable += "</td></tr><tr><td> <table width='100%' border='0' cellspacing='0' cellpadding='0' class='price-details'><tbody>"; DataRow[] roomdescrow = hpr.dtRoomInfo.Select("RPH='" + RPH + "'"); DataRow[] roomRaterow = hpr.dtRoomRate.Select("RPH='" + RPH + "'"); DataRow[] hotelpricingrow = hpr.dtHotelPricing.Select("RoomRateID='" + roomRaterow[0]["RoomRateID"].ToString() + "'"); DataRow[] hpraterangerow = hpr.HP_RateRange.Select("HotelPricingID='" + hotelpricingrow[0]["HotelPricingID"].ToString() + "'"); DataTable dtr = new DataTable(); dtr.Columns.Add("id"); dtr.Columns.Add("amount"); dtr.Columns.Add("taxes"); dtr.Columns.Add("surcharges"); dtr.Columns.Add("expdate", typeof(DateTime)); dtr.Columns.Add("effedate", typeof(DateTime)); dtr.Columns.Add("hid"); if (hpraterangerow.Count() > 0) { foreach (DataRow drr in hpraterangerow) { DataRow drp = dtr.NewRow(); drp[0] = drr[0]; drp[1] = drr[1]; drp[2] = drr[2]; drp[3] = drr[3]; drp[4] = "2018-" + drr[4].ToString(); drp[5] = "2018-" + drr[5].ToString(); drp[6] = drr[6]; dtr.Rows.Add(drp); } } else { DataRow drp = dtr.NewRow(); drp[0] = 0; drp[1] = roomdescrow[0]["RatePernight"]; drp[2] = 0; drp[3] = 0; drp[4] = "2018-" + checkoutdt.ToString("MM-dd"); drp[5] = "2018-" + checkindt.ToString("MM-dd"); drp[6] = 1; dtr.Rows.Add(drp); } for (int i = 0; i < noofweeks; i++) { strtable += "<tr><td>Week" + (i + 1) + "</td>"; for (int j = 0; j < 7; j++) { strtable += "<td>" + GetDayRate(dtr, startweekdate.AddDays((7 * i) + j).ToString("MM-dd-yyyy")) + "</td>"; } strtable += "</tr>"; } strtable += "</tbody> </table> </td> </tr> </tbody></table>"; return(strtable); }
private string GetHotellist(AvailabilityRS dtHList, string searchid, string checkind, string checkoutd, string guestcount, string selaudults, string selchilds, string currencycode, string b2c_idn) { double admarkup = 0.00; double adpercmarkup = 0.00; double clpercmarkup = 0.00; double clmarkup = 0.00; double finalmarkup = 0.00; double finaldiscount = 0.00; double adperdiscount = 0.00; double clperdiscount = 0.00; double addiscount = 0.00; double cldiscount = 0.00; double baseamount = 0.00; string reviewrate = string.Empty; string rvalue = ""; string imagecode = "GEN"; int order = 2; string childage = string.Empty; // foreach (DataRow drh in dtHList.Rows) //{ string b2c_idnencript = Encrypt(b2c_idn); double dc = 0.0; try { dc = (Convert.ToDateTime(checkoutd.ToString()) - Convert.ToDateTime(checkind.ToString())).TotalDays; } catch { } DataTable dssearch = HotelDBLayer.GetSearch(searchid); if (dssearch.Rows.Count > 0) { childage = dssearch.Rows[0]["HB_ChildAge"].ToString(); } HotelDevMTWebapi.Models.Hotel drh = new HotelDevMTWebapi.Models.Hotel(); string agency_name = ""; DataTable dtpccdet = manage_data.getpccdetails(b2c_idn); if (dtpccdet.Rows.Count > 0) { agency_name = dtpccdet.Rows[0]["agency_name"].ToString(); } string cmdfacility = ""; cmdfacility = "select HB_HotelCodes from hotelsearch where searchidn=" + searchid; DataTable dthbhotelcds = manage_data.GetDataTable(cmdfacility, manage_data.con); DataTable dtffbookingfb = null; DataRow[] drimgpath = null; if (System.Web.HttpContext.Current.Cache["dtffbookingfb" + searchid] == null) { string cmdflbkfb = "select HotelCode,Path,ImageTypeCode from HotelImage where HotelCode in (" + dthbhotelcds.Rows[0]["HB_HotelCodes"].ToString() + ") order by HotelCode,Path asc"; dtffbookingfb = manage_data.GetDataTable(cmdflbkfb, manage_data.flip_conhb); System.Web.HttpContext.Current.Cache["dtffbookingfb" + searchid] = dtffbookingfb; } else { dtffbookingfb = (DataTable)System.Web.HttpContext.Current.Cache["dtffbookingfb" + searchid]; } for (int i = (vpageno - 1) * 20; i < (vpageno * 20); i++) { if (i >= dtHList.Hotels.Hotel.Count || i >= 350) { break; } drh = dtHList.Hotels.Hotel[i]; HotelMaincintent objhtl = new HotelMaincintent(); List <Hdbfacilities> lstHdbfacilities = new List <Hdbfacilities>(); objhtl = HotelListGenerate.GetHotelContent(vpageno, drh.Code); if (objhtl.Name != null) { lstHdbfacilities = HotelListGenerate.Gethotelfacilities(drh.Code); //string lengt = objfacility.FacilityCode; string facilitydescr = string.Empty; facilitydescr = HotelListGenerate.GetFacilityList(lstHdbfacilities); //foreach (Hdbfacilities obj in objfacility) //{ // string decrptnlist = ""; // if (!string.IsNullOrEmpty(obj.FacilityCode)) // { // decrptnlist = HotelListGenerate.getfacidisc(obj.FacilityCode.ToString(), obj.FacilityGroupCode.ToString()); // facilitydescr += "<li>" + decrptnlist + "</li>"; // } //} drimgpath = dtffbookingfb.Select("HotelCode='" + dtHList.Hotels.Hotel[i].Code + "' and ImageTypeCode='" + imagecode + "'"); rvalue += "<div class='col-md-12 hotel-details'><div class='row'>"; try { rvalue += " <div class='htl-img-blk col-md-4'> <img src='http://photos.hotelbeds.com/giata/" + drimgpath[0]["Path"].ToString() + "' onerror='this.src="../images/No%20Image%20found.png"' class='img-responsive' id='HotelImage_" + dtHList.Hotels.Hotel[i].Code + "' /></div>"; } catch { rvalue += " <div class='htl-img-blk col-md-4'> <img src='../images/No Image found.png' onerror='this.src="../images/No%20Image%20found.png"' class='img-responsive' id='HotelImage_" + dtHList.Hotels.Hotel[i].Code + "' /></div>"; } rvalue += "<div class='col-md-8 col-sm-8 col-xs-8 htl-content'> <div class='col-md-8 col-sm-8 col-xs-8 htl-cont-left'>"; rvalue += "<div class='htl-header'> <div class='htl-name'>"; double rating = 0.0; int starRating = 0; try { //rating = Convert.ToDouble("3.0"); string ratingv = drh.CategoryName.ToString(); string[] rativ_split = ratingv.Split(' '); if (rativ_split[0].ToString() != "1" && rativ_split[0].ToString() != "2" && rativ_split[0].ToString() != "3" && rativ_split[0].ToString() != "4" && rativ_split[0].ToString() != "5") { //if (ratingv == "WITHOUT OFFICIAL CATEGORY") //{ rating = 0.0; } else { //rativ_split = ratingv.Split(' '); rating = Convert.ToDouble(rativ_split[0].ToString()); } starRating = Convert.ToInt32(rating); //if (drh.Reviews != null) //{ // rating = Convert.ToDouble(drh.Reviews.Review.Rate.ToString()); // starRating = Convert.ToInt32(rating); //} } catch { rating = Convert.ToDouble("0.0"); starRating = Convert.ToInt32(rating); } rvalue += "<a target='_blank' href='HotelDetails_load.aspx?id=" + searchid + "&HotelCode=" + drh.Code + "&chkin=" + checkind + "&chkout=" + checkoutd + "&gc=" + selaudults + "&award=" + rating.ToString() + "&childAges=" + childage + "&Totalguest=" + guestcount + "&childrens=" + selchilds + "&clid=" + b2c_idnencript + "'>"; //if(drh["contractnegcode"].ToString()!="") //{ rvalue += "<h4>" + drh["HotelName"] + "*<span class='star-blk'><img src='../images/" + drh["RatingValue"] + "stars.png' class='img-responsive' /> </span></h4></a>"; } //else //{ //} try { if (starRating > 0) { rvalue += "<h4>" + drh.Name + "<span class='star-blk'><img src='../images/" + starRating + "stars.png' class='img-responsive' /> </span></h4>"; } else { rvalue += "<h4>" + drh.Name + "</h4>"; } } catch { } rvalue += "</a>"; rvalue += "</div></div>"; rvalue += "<div class='htl-adress'> <p><span class='addressrpblck'><i class='fa fa-map-marker' aria-hidden='true'></i>" + HotelListGenerate.Getaddress(drh.Code) + "</span> |<a href='#' id='btnShow1' data-toggle='modal' data-target='#DivMap' onclick=\"showmap(" + drh.Latitude + "," + drh.Longitude + ",'" + drh.Name + "')\"> Show Map </a></span></p> </div>"; rvalue += "<div class='facilities'><ul class='list-inline'>"; rvalue += facilitydescr; rvalue += "</ul></div>"; //rvalue += " <div class='facilities'>" + facilitydescr + " </div> "; try { if (drh.Reviews != null) { rvalue += " <div class='reviws-blk'> <ul class='list-inline'>"; rvalue += "<li class='review-rate'>" + drh.Reviews.Review.Rate + "</li> <li class='reviw-scre'><span>Excellent</span> (" + drh.Reviews.Review.ReviewCount + " reviews)</li> </ul></div>"; } //else //{ // rvalue += " <div class='reviws-blk'> <ul class='list-inline'>"; // rvalue += "<li class='review-rate'>3.0</li> <li class='reviw-scre'><span>Excellent</span> (15 reviews)</li> </ul></div>"; //} } catch { } rvalue += "</div>"; rvalue += "<div class='col-md-4 col-sm-4 col-xs-4 htl-cont-right'>"; baseamount = (Convert.ToDouble(drh.MinRate) / Convert.ToDouble(dc)); if (drh.Code.ToString() != "") { DataTable dt = new DataTable(); SqlConnection sqlcon = new SqlConnection(con); try { SqlCommand cmd = new SqlCommand(); cmd.Connection = sqlcon; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "p_SreTS_HDR"; cmd.Parameters.AddWithValue("@B2C_IDN", b2c_idn); cmd.Parameters.AddWithValue("@Hotelcode", drh.Code.ToString()); cmd.Parameters.AddWithValue("@GDS", "HB"); cmd.Parameters.AddWithValue("@IsLoginCust", "Y"); SqlDataAdapter sa = new SqlDataAdapter(cmd); sa.Fill(dt); } catch { } if (dt.Rows.Count > 0) { string Ts_mode = string.Empty; Ts_mode = dt.Rows[0]["TS_Mode"].ToString(); if (Ts_mode == "Fixed") { admarkup = Convert.ToDouble(dt.Rows[0]["TS_Markup"].ToString()); addiscount = Convert.ToDouble(dt.Rows[0]["TS_Discount"].ToString()); } else if (Ts_mode == "Percentage") { adpercmarkup = Convert.ToDouble(dt.Rows[0]["TS_Markup"].ToString()); adperdiscount = Convert.ToDouble(dt.Rows[0]["TS_Discount"].ToString()); admarkup = (((baseamount) / 100.00) * adpercmarkup); addiscount = (((baseamount) / 100.00) * adperdiscount); } else { admarkup = 0.00; addiscount = 0.00; } string Cl_Mode = string.Empty; Cl_Mode = dt.Rows[0]["Cl_Mode"].ToString(); if (Cl_Mode == "Fixed") { clmarkup = Convert.ToDouble(dt.Rows[0]["Cl_Markup"].ToString()); cldiscount = Convert.ToDouble(dt.Rows[0]["Cl_Discount"].ToString()); } else if (Cl_Mode == "Percentage") { clpercmarkup = Convert.ToDouble(dt.Rows[0]["Cl_Markup"].ToString()); clperdiscount = Convert.ToDouble(dt.Rows[0]["Cl_Discount"].ToString()); clmarkup = ((baseamount / 100.00) * clpercmarkup); cldiscount = ((baseamount / 100.00) * clperdiscount); } else { clmarkup = 0.00; cldiscount = 0.00; } finalmarkup = admarkup + clmarkup; finaldiscount = addiscount + cldiscount; baseamount = baseamount + (finalmarkup - finaldiscount); } rvalue += " <h2 class='price-cnt'>" + Utilities.GetRatewithSymbol(currencycode) + Convert.ToDouble(Convert.ToDouble(baseamount)).ToString("0.00") + "*</h2>";//drh.MinRate) / (dc) } else { rvalue += " <h2 class='price-cnt'>" + Utilities.GetRatewithSymbol(currencycode) + Convert.ToDouble(Convert.ToDouble(baseamount)).ToString("0.00") + "</h2>";//drh.MinRate) / (dc) } rvalue += " <p class='srch-pr-nyt'>Per Night</p>"; //if (drh.Reviews != null) //{ // rating = Convert.ToDouble(drh.Reviews.Review.Rate.ToString()); //} rvalue += "<a target='_blank' href='HotelDetails_load.aspx?id=" + searchid + "&HotelCode=" + drh.Code + "&chkin=" + checkind + "&chkout=" + checkoutd + "&gc=" + guestcount + "&award=" + rating.ToString() + "&childAges=" + childage + "&Currency=" + currencycode + "&clid=" + b2c_idnencript + "' class='chocse-rm'>Choose Room</a>"; rvalue += " <p class='avail-rms'>"; rvalue += "<a class='lnkviewavrooms' style='cursor:pointer;' onclick=\"RoomDetails('" + drh.Code + "',this,' " + rating.ToString() + "')\">View Available Rooms</a>"; rvalue += " </p></div>"; rvalue += " <div class='discount col-md-12 col-sm-12 col-xs-12 col-sm-12 col-xs-12'>"; rvalue += " <div class='benft'> <p> <span class='hotl-logo'>"; rvalue += " <img src='http://photos.hotelbeds.com/giata/" + HotelListGenerate.getimpagePath(imagecode, drh.Code) + "' onerror='this.src="../images/No%20Image%20found.png"' id='HotelLogo_" + drh.Code + "'/></span>*Special Discounted Rates </p> </div>"; rvalue += "</div></div> </div>"; rvalue += " <div class='availble-rm-blk' id='divavailroom" + drh.Code + "'>"; rvalue += " <div class='loaing-bg_img' style='display:none ;width: 100%; margin-top: 20px; text-align: center;'><img src='../images/loader.gif' /><br /> please wait..</div>"; rvalue += "</div></div>"; } } return(rvalue); }