protected void gdvHotelBooking_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "PrintInVoice")
{
string HotelBookingId = _objBoutility.Encrypt(e.CommandArgument.ToString(), true);
string url = "printhotelInvoice.aspx?reqstId=" + HotelBookingId;
string s = "window.open('" + url + "', 'popup_window', 'width=800,height=1000,left=100,top=100,resizable=yes');";
ClientScript.RegisterStartupScript(this.GetType(), "script", s, true);
//Response.Redirect("Customer.aspx?HotelBookingId=" + HotelBookingId);
}
else
{
string HotelBookingId = _objBoutility.Encrypt(e.CommandArgument.ToString(), true);
//string url = "../DinoSales/Cancelation.aspx?reqstId=" + HotelBookingId;
//string s = "window.open('" + url + "', 'popup_window', 'width=800,height=1000,left=100,top=100,resizable=yes');";
//ClientScript.RegisterStartupScript(this.GetType(), "script", s, true);
Response.Redirect("../DinoSales/Cancelation.aspx?reqstId=" + HotelBookingId);
}
}
protected void gvPolicy_RowCommand(object sender, GridViewCommandEventArgs e)
{
string PolicyId = e.CommandArgument.ToString();
if (e.CommandName == "Edit Policy")
{
Response.Redirect("Policysetup.aspx?PolicyId=" + HttpUtility.UrlEncode(objBOUtiltiy.Encrypt(PolicyId, true)));
}
if (e.CommandName == "Delete Policy")
{
DeletePolicy(Convert.ToInt32(PolicyId));
BindPloicy();
}
}
private void GeneratehotelQuotation(DataSet objDs)
{
try
{
string FileName = "AgentId_Res" + objDs.Tables[1].Rows[0]["HotelRequestId"].ToString();
string GetFilePath = Server.MapPath("/DinoSales/Xml/Hotel/" + FileName + ".xml");
DataSet objDsHotelResult = ReadHotelXmlFile(GetFilePath);
if (objDsHotelResult.Tables.Count > 0)
{
DataSet objdsSearch = _objBAHotelSearch.GetHotelSearchRequest(Convert.ToInt32(objDs.Tables[1].Rows[0]["HotelRequestId"]));
int OptionCount = 1;
foreach (DataRow drHotel in objDs.Tables[1].Rows)
{
DataRow hotelRow = dtHotelQuotation.NewRow();
DataRow[] drPropertyResult;
drPropertyResult = objDsHotelResult.Tables["PropertyResult"].Select("PropertyID='" + drHotel["PropertyID"].ToString() + "'", "PropertyID", DataViewRowState.CurrentRows);
foreach (DataRow drPropertyResultin in objDsHotelResult.Tables["PropertyResult"].Rows)
{
hotelRow["HotelServiceFee"] = drHotel["ServiceFee"].ToString();
hotelRow["HotelBookingText"] = drHotel["QuotationText"].ToString();
hotelRow["HotelStatus"] = drHotel["Status"].ToString();
hotelRow["HotelRequestId"] = drHotel["HotelRequestId"].ToString();
hotelRow["ApprovalStatus"] = drHotel["ApprovalStatus"].ToString();
hotelRow["TrvellerId"] = drHotel["TravellerId"].ToString();
if (drPropertyResultin["PropertyID"].ToString() == drHotel["PropertyID"].ToString())
{
DataSet objDsHotelProperites = new DataSet();
objDsHotelProperites = _objBAHotelSearch.GetHotelsProperites(drPropertyResultin["PropertyReferenceID"].ToString().TrimEnd(','));
if (objDsHotelProperites.Tables[0].Rows.Count > 0)
{
hotelRow["HotelOptionNo"] = "Proceed for booking";
//if (drHotel["Status"].ToString() == "2")
// hotelRow["HotelOptionNo"] = "Approved";
//else
// hotelRow["HotelOptionNo"] = "Need to approve";
hotelRow["HotelQuotationId"] = drHotel["HotelQuotationId"].ToString();
OptionCount++;
hotelRow["PropertyName"] = objDsHotelProperites.Tables[0].Rows[0]["PropertyName"].ToString();
hotelRow["HotelAddress"] = objDsHotelProperites.Tables[0].Rows[0]["Address1"].ToString() + " " +
objDsHotelProperites.Tables[0].Rows[0]["Address2"].ToString()
+ " " + objDsHotelProperites.Tables[0].Rows[0]["TownCity"].ToString() + " " + objDsHotelProperites.Tables[0].Rows[0]["County"].ToString()
+ " " + objDsHotelProperites.Tables[0].Rows[0]["PostcodeZip"].ToString();
}
}
}
if (objDsHotelResult.Tables["RoomType"].Rows.Count > 0)
{
DataSet objPreBookingResult = new DataSet();
DataRow[] drRoomTypes;
string PreBookingReq = string.Empty;
if (drHotel["PropertyRoomTypeID"].ToString() != "0")
{
drRoomTypes = objDsHotelResult.Tables["RoomType"].Select("PropertyRoomTypeID='" + drHotel["PropertyRoomTypeID"].ToString() + "'", "PropertyRoomTypeID", DataViewRowState.CurrentRows);
if (drRoomTypes.Length > 0)
{
hotelRow["HotelRoomType"] = drRoomTypes[0]["RoomtypeDesc"].ToString();
hotelRow["MealDesc"] = drRoomTypes[0]["MealBasis"].ToString();
hotelRow["HotelOptionText"] = "PropertyID=" + objBOUtiltiy.Encrypt(drHotel["PropertyID"].ToString(), true) + "&PropertyRoomTypeID="
+ objBOUtiltiy.Encrypt(drHotel["PropertyRoomTypeID"].ToString(), true);
}
}
else
{
drRoomTypes = objDsHotelResult.Tables["RoomType"].Select("BookingToken='" + drHotel["BookingToken"].ToString().Replace(" ", "+") + "'", "BookingToken", DataViewRowState.CurrentRows);
hotelRow["HotelRoomType"] = drRoomTypes[0]["RoomtypeDesc"].ToString();
hotelRow["MealDesc"] = drRoomTypes[0]["MealBasis"].ToString();
hotelRow["HotelOptionText"] = "PropertyID=" + objBOUtiltiy.Encrypt(drHotel["PropertyID"].ToString(), true) + "&Bookingtoken="
+ drHotel["BookingToken"].ToString().Replace(" ", "+");
}
int RequestId = Convert.ToInt32(Session["HotelRequestId"]);
DataSet objds = _objBAHotelSearch.GetHotelSearchRequest(RequestId);
if (objdsSearch.Tables[0].Rows.Count > 0)
{
hotelRow["HotelNoNights"] = objdsSearch.Tables[0].Rows[0]["Duration"].ToString();
int HotelRooms = Convert.ToInt32(objdsSearch.Tables[0].Rows[0]["NoRooms"].ToString());
decimal HotelTotalFare = Convert.ToDecimal(drHotel["TotalFee"]);
hotelRow["HotelTotalRooms"] = objdsSearch.Tables[0].Rows[0]["NoRooms"].ToString();
hotelRow["HotelCostFare"] = strCurrencyCode + " " + HotelTotalFare.ToString();
// lblHotelCheckin.Text = objBOUtiltiy.ReverseConvertDateFormat(objdsSearch.Tables[0].Rows[0]["ArrivalDate"].ToString(), "MMMM dd, yyyy");
// lblHotelCheckOut.Text = objBOUtiltiy.ReverseConvertDateFormat(objdsSearch.Tables[0].Rows[0]["CheckOutDate"].ToString(), "MMMM dd, yyyy");
}
if (objdsSearch.Tables[1].Rows.Count > 0)
{
int Adult = 0;
int Child = 0;
int Infant = 0;
int TotalPax = 0;
foreach (DataRow drPax in objdsSearch.Tables[1].Rows)
{
Adult = Adult + Convert.ToInt32(drPax["Adults"]);
Child = Child + Convert.ToInt32(drPax["Children"]);
Infant = Infant + Convert.ToInt32(drPax["Infants"]);
}
TotalPax = Adult + Child + Infant;
hotelRow["NoPax"] = TotalPax.ToString();
}
}
dtHotelQuotation.Rows.Add(hotelRow);
}
if (dtHotelQuotation.Rows.Count > 0)
{
rptHotelQuotation.DataSource = dtHotelQuotation;
rptHotelQuotation.DataBind();
}
}
}
catch (Exception ex)
{
lblMsg.Text = objBOUtiltiy.ShowMessage("danger", "System Error", ex.Message);
}
}