private string GetHotels(string sc, string searchid) { string rq = ""; //pcc = "VL5H"; //ipcc = "7A7H"; ; //username = "******"; //password = "******"; //result = XMLRead.ContextChange(pcc,ipcc,username,password,searchid); result = XMLRead.ContextChange(searchid); ContextResult = result; if (result.ToString() != "") { DataSet ds = new DataSet(); DataSet dsSession = new DataSet(); StringReader se_stream = new StringReader(result); dsSession.ReadXml(se_stream); string Rq = ""; if (dsSession.Tables["BinarySecurityToken"] != null) { DataTable dtBinarySecurityToken = dsSession.Tables["BinarySecurityToken"]; DataTable dtMessageData = dsSession.Tables["MessageData"]; DataTable dtMessageHeader = dsSession.Tables["MessageHeader"]; string timestamp = DateTime.UtcNow.ToString(); rq = GetRq(dtBinarySecurityToken, dtMessageData, dtMessageHeader, sc); result = XMLRead.SendQuery(rq); XMLRead.SaveXMLFile(rq, result, searchid + "_hotelsAvail"); } } return(result); }
public HotelImageJson Get(string searchid, string HotelCode, string curcode) { string rvalue = ""; string ContextResult = ""; DataTable dtHotelUrl = HotelDBLayer.GetHotelImageUrl(HotelCode); if (dtHotelUrl.Rows.Count > 0) { hij.Image = dtHotelUrl.Rows[0]["ImageUrl"].ToString(); hij.Logo = dtHotelUrl.Rows[0]["Logourl"].ToString(); return(hij); } else { string filePathContext = Path.Combine(HttpRuntime.AppDomainAppPath, "HotelXML/" + searchid + "_" + curcode + "_ContextChange-RS.xml"); if (File.Exists(filePathContext)) { ContextResult = File.ReadAllText(filePathContext); } else { ContextResult = XMLRead.ContextChange(searchid); } HotelImageAj hotelimage = new HotelImageAj(HotelCode, "", searchid, ContextResult); string image = hotelimage.Image; string logo = hotelimage.logo; HotelDBLayer.SaveHotelImageUrl(HotelCode, image, logo); hij.Image = image; hij.Logo = logo; return(hij); } }
public string GetImageXML(string Hotelcode, string searchid) { //pcc = "VL5H"; //ipcc = "7A7H"; ; //username = "******"; //password = "******"; //XMLRead xmlHotelImage = new XMLRead(); string result = ""; // result = XMLRead.ContextChange(pcc, ipcc, username, password, searchid); result = XMLRead.ContextChange(searchid); string rq = ""; rq = GetXMLRQ(result, Hotelcode); result = XMLRead.SendQuery(rq); XMLRead.SaveXMLFile(rq, result, searchid + "_hotelsImage" + "_" + Hotelcode); return(result); }
//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 HotelMedia(string Hotelcode, string contextresult, string searchid, string viewid, string b2c_idn) { DataTable dtpcc = manage_data.getpccdetails(b2c_idn); if (dtpcc.Rows.Count > 0) { pcc = dtpcc.Rows[0]["prv_pcc"].ToString(); ipcc = dtpcc.Rows[0]["prv_ipcc"].ToString(); username = dtpcc.Rows[0]["prv_username"].ToString(); password = dtpcc.Rows[0]["prv_pwd"].ToString(); } try { string ContextResult = ""; // ContextResult = contextresult; //string filePathContext = Path.Combine(HttpRuntime.AppDomainAppPath, "HotelXML/" + searchid + "_ContextChange-RS.xml"); //if (File.Exists(filePathContext)) //{ // ContextResult = File.ReadAllText(filePathContext); //} //else //{ // ContextResult = XMLRead.ContextChange(searchid); //} ContextResult = XMLRead.ContextChange(searchid + "_Media"); string resultxml = GetMediaXMLContext(Hotelcode, searchid, ContextResult, b2c_idn); if (resultxml.ToString() != "") { DataSet ds = new DataSet(); DataSet dsSession = new DataSet(); StringReader se_stream = new StringReader(resultxml); dsSession.ReadXml(se_stream); string Rq = ""; if (dsSession.Tables["BinarySecurityToken"] != null) { DataTable dtBinarySecurityToken = dsSession.Tables["BinarySecurityToken"]; DataTable dtMessageData = dsSession.Tables["MessageData"]; DataTable dtMessageHeader = dsSession.Tables["MessageHeader"]; string timestamp = DateTime.UtcNow.ToString(); string cresult = XMLRead.closession(dtMessageData.Rows[0]["MessageId"].ToString(), timestamp, dtBinarySecurityToken.Rows[0]["BinarySecurityToken_Text"].ToString(), searchid + "_Media", XMLRead.pcc, XMLRead.ipcc); } } xmldoc.LoadXml(resultxml); XmlNode xnod = xmldoc.DocumentElement; XmlNode xheader = xnod.ChildNodes[0]; XmlNode xbody = xnod.ChildNodes[1]; XmlNode xGetImageRS = xbody.ChildNodes[0]; XmlNode xMediaInfos = xGetImageRS.ChildNodes[1]; CreateTables(); foreach (XmlNode xn in xMediaInfos) { int rno = dtHotelMediaInfo.Rows.Count + 1; FillHotelMediaInfo(rno, xn); foreach (XmlNode xn1 in xn) { if (xn1.Name.ToLower() == "ns23:hotelinfo") { AddXMLHotelInfo(xn1, rno); } if (xn1.Name.ToLower() == "ns23:imageitems") { AddXMLImageItems(xn1, rno); } } } } catch { } }
public PNRDataAj(string searchid, CustomerInfo ci, string rph, string BookinID, string hotelcode, string CurrencyCode, string b2c_idn, string rooms, string Guestdet) { string ratekey = string.Empty; string cmdtxtrkey = "select HB_RateKey from HotelBooking where Bookingidn=" + BookinID + ""; DataTable dtrkey = manage_data.GetDataTable(cmdtxtrkey, manage_data.con); if (dtrkey.Rows.Count > 0) { ratekey = dtrkey.Rows[0]["HB_RateKey"].ToString(); } //// temporarily commented //string filePathContext = Path.Combine(HttpRuntime.AppDomainAppPath, "HotelXML/" + searchid + "_ContextChange-RS.xml"); //if (File.Exists(filePathContext)) //{ // ContextResult = File.ReadAllText(filePathContext); //} //else //{ // ContextResult = XMLRead.ContextChange(searchid); //} DataTable dtpcc = manage_data.getpccdetails(b2c_idn); if (dtpcc.Rows.Count > 0) { cnphone = dtpcc.Rows[0]["cust_identifier"].ToString().Substring(0, 3) + "-" + dtpcc.Rows[0]["cust_identifier"].ToString().Substring(3, 3) + "-" + dtpcc.Rows[0]["cust_identifier"].ToString().Substring(6, 4); cident = dtpcc.Rows[0]["cust_identifier"].ToString(); pcc = dtpcc.Rows[0]["prv_pcc"].ToString(); ipcc = dtpcc.Rows[0]["prv_ipcc"].ToString(); username = dtpcc.Rows[0]["prv_username"].ToString(); password = dtpcc.Rows[0]["prv_pwd"].ToString(); } XMLRead.GetPccDetails(b2c_idn); string result = ""; result = XMLRead.ContextChange(searchid + "_" + hotelcode + "_PNR"); int rphl = rph.ToString().Length; if (rphl == 1) { rph = "0" + rph.ToString(); } //string RateBodyRQ = GetRateDescBodyRQ(rph); //string PassengerBodyRQ = GetPassengerBodyRQ(ci, Guestdet); string htlbkuri = ConfigurationManager.AppSettings["HotelPortalBookingUri"] != null ? ConfigurationManager.AppSettings["HotelPortalBookingUri"].ToString() : string.Empty; if (!string.IsNullOrEmpty(htlbkuri)) { string HoteResBodyRQ = GetHotelResBodyRQ(searchid, ci, rph, rooms, ratekey, BookinID); result = XMLRead.SendQuery(HoteResBodyRQ, htlbkuri); XMLRead.SaveXMLTextFile(HoteResBodyRQ, result, searchid + "_" + BookinID + "_PNRHotelResDet"); //searchid = "7430"; //BookinID = "1918"; string filePathRQ = Path.Combine(HttpRuntime.AppDomainAppPath, "HotelXML/" + searchid + "_" + BookinID + "_PNRHotelResDet" + "-RS.xml"); result = File.ReadAllText(filePathRQ); //string RateRQ = GetRateDescRQ(result, RateBodyRQ); //result = XMLRead.SendQuery(RateRQ); //XMLRead.SaveXMLTextFile(RateRQ, result, searchid + "_" + BookinID + "_PNRRateDesec"); //string PassengerRQ = GetPassengerXMLRQ(result, PassengerBodyRQ); //result = XMLRead.SendQuery(PassengerRQ); //XMLRead.SaveXMLTextFile(PassengerRQ, result, searchid + "_" + BookinID + "_PNRPassengerDet"); //string HotelResRq = GetHotelResXMLRQ(result, HoteResBodyRQ); //result = XMLRead.SendQuery(HotelResRq); //XMLRead.SaveXMLTextFile(HotelResRq, result, searchid + "_" + BookinID + "_PNRHotelResDet"); //string EndTransRQ = GetEndTransRQ(result); //result = XMLRead.SendQuery(EndTransRQ); //XMLRead.SaveXMLTextFile(EndTransRQ, result, searchid + "_" + BookinID + "_PNREndTrans"); string EndTransXML = result; Hes = new HotelEndTrans(EndTransXML, BookinID, filePathRQ); ////closing the session //if (result.ToString() != "") //{ // DataSet ds = new DataSet(); // DataSet dsSession = new DataSet(); // StringReader se_stream = new StringReader(result); // dsSession.ReadXml(se_stream); // string Rq = ""; // if (dsSession.Tables["BinarySecurityToken"] != null) // { // DataTable dtBinarySecurityToken = dsSession.Tables["BinarySecurityToken"]; // DataTable dtMessageData = dsSession.Tables["MessageData"]; // DataTable dtMessageHeader = dsSession.Tables["MessageHeader"]; // string timestamp = DateTime.UtcNow.ToString(); // string cresult = XMLRead.closession(dtMessageData.Rows[0]["MessageId"].ToString(), timestamp, dtBinarySecurityToken.Rows[0]["BinarySecurityToken_Text"].ToString(), searchid + "_" + BookinID + "_PNR", XMLRead.pcc, XMLRead.ipcc); // } //} } }
public List <HotelImageJsonCode> Get(string searchid, string HotelCode, string curcode, string b2c_idn) { List <HotelImageJsonCode> HotelImages = new List <HotelImageJsonCode>(); try { if (searchid != "" && searchid != null && HotelCode != "" && HotelCode != null) { string[] HotelCodes = HotelCode.Trim('*').Split('*'); foreach (string hcode in HotelCodes) { HotelImageJsonCode hijc = new HotelImageJsonCode(); DataTable dtHotelUrl = HotelDBLayer.GetHotelImageUrl(hcode); if (dtHotelUrl.Rows.Count > 0) { hijc.Image = dtHotelUrl.Rows[0]["ImageUrl"].ToString(); hijc.Logo = dtHotelUrl.Rows[0]["Logourl"].ToString(); hijc.Hotelcode = hcode; HotelImages.Add(hijc); } else { string filePathContext = Path.Combine(HttpRuntime.AppDomainAppPath, "HotelXML/" + searchid + "_" + curcode + "_ImageContextChange-RS.xml"); if (File.Exists(filePathContext)) { ContextResult = File.ReadAllText(filePathContext); } else { ContextResult = XMLRead.ContextChange(searchid + "Image"); try { File.WriteAllText(filePathContext, ContextResult); } catch { } } HotelImageAj hotelimage = new HotelImageAj(HotelCode, "", searchid, ContextResult); string image = hotelimage.Image; string logo = hotelimage.logo; if (image != "N") { HotelDBLayer.SaveHotelImageUrl(hcode, image, logo); } hijc.Hotelcode = hcode; if (image != "N") { hijc.Image = image; } else { hijc.Image = "../images/No Image found.png"; } if (logo != "N") { hijc.Logo = logo; } else { hijc.Logo = "../images/No Image found.png"; } HotelImages.Add(hijc); } } //closing the session if (ContextResult.ToString() != "") { DataSet ds = new DataSet(); DataSet dsSession = new DataSet(); StringReader se_stream = new StringReader(ContextResult); dsSession.ReadXml(se_stream); string Rq = ""; if (dsSession.Tables["BinarySecurityToken"] != null) { DataTable dtBinarySecurityToken = dsSession.Tables["BinarySecurityToken"]; DataTable dtMessageData = dsSession.Tables["MessageData"]; DataTable dtMessageHeader = dsSession.Tables["MessageHeader"]; string timestamp = DateTime.UtcNow.ToString(); string cresult = XMLRead.closession(dtMessageData.Rows[0]["MessageId"].ToString(), timestamp, dtBinarySecurityToken.Rows[0]["BinarySecurityToken_Text"].ToString(), searchid + "Image", XMLRead.pcc, XMLRead.ipcc); } } } } catch { } return(HotelImages); }