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