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