uoDropDownListPort_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (uoDropDownListPort.SelectedIndex == 0)
{
LoadAllCombo();
return;
}
List <CrewAssistHotelList> list = new List <CrewAssistHotelList>();
SF = new CrewAssistBLL();
list = SF.GetGetHotelPortExpendTypeList(1, uoHiddenFieldUser.Value, "0", uoDropDownListPort.SelectedValue.ToString());
lstHotel.Items.Clear();
int iRowCount = list.Count;
if (iRowCount > 0)
{
lstHotel.DataSource = list;
lstHotel.DataTextField = "HotelName";
lstHotel.DataValueField = "HotelID";
lstHotel.DataBind();
}
//BindVendors(uoHiddenFieldUser.Value, GlobalCode.Field2Int(uoDropDownListPort.SelectedValue), 0);
}
catch (Exception ex)
{
AlertMessage("DownListPort: " + ex.Message);
}
}
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void uoButtonSend_click(object sender, EventArgs e)
{
//SendRequest();
int id = GlobalCode.Field2Int(Request.QueryString["ufn"]);
string Val = GlobalCode.Field2String(Request.QueryString["Em"]);
long PortID = GlobalCode.Field2Long(Request.QueryString["porID"]);
CrewAssistBLL CA = new CrewAssistBLL();
CA.TblEmail(id, Val, Val, PortID, uoHiddenFieldUser.Value);
OpenParent();
}
protected void btnSaveCancelHotel_click(object sender, EventArgs e)
{
try
{
CrewAssistBLL BLL = new CrewAssistBLL();
if (uoHiddenFieldIsVehicle.Value == "1")
{
//AlertMessage("Request for hotel Transportation has been sent successfully.");
List <SeafarerDetailHeader> _SDetailList = new List <SeafarerDetailHeader>();
Session["SeafarerDetailList"] = null;
//_SDetailList = BLL.GetCrewAssistCancelTransportationRequest(GlobalCode.Field2TinyInt(uoHiddenFieldVendorType.Value == "PA" ? 1 : 0), GlobalCode.Field2Long(uoHiddenFieldHotelID.Value)
_SDetailList = BLL.GetCrewAssistCancelTransportationRequest(GlobalCode.Field2TinyInt(GlobalCode.Field2String(uoHiddenFieldVendorType.Value) == "True" ? 1 : 0), GlobalCode.Field2Long(uoHiddenFieldHotelID.Value)
, GlobalCode.Field2Long(uoHiddenFieldHTravelRequestID.Value)
, GlobalCode.Field2Long(uoHiddenFieldHIDBigint.Value)
, GlobalCode.Field2Int(uoHiddenFieldSeqNo.Value)
, GlobalCode.Field2String(uoHiddenFieldUser.Value)
, GlobalCode.Field2String(txtEmailTo.Text)
, GlobalCode.Field2String(txtEmailCC.Text)
, GlobalCode.Field2String(uoTextBoxConfirmedBy.Text)
, GlobalCode.Field2String(uoTextBoxComment.Text)
, GlobalCode.Field2DateTime(uoHiddenFieldCurrentDate.Value)
, GlobalCode.Field2String(uoHiddenFieldTimeZone.Value)
, GlobalCode.Field2String(uoHiddenFieldCurrentDate.Value));
Session["SeafarerDetailList"] = _SDetailList;
}
else
{
List <SeafarerDetailHeader> _SDetailList = new List <SeafarerDetailHeader>();
Session["SeafarerDetailList"] = null;
_SDetailList = BLL.GetCancelCrewAssistHotelRequest(GlobalCode.Field2TinyInt(uoHiddenFieldVendorType.Value == "PA" ? 1 : 0), GlobalCode.Field2Long(uoHiddenFieldHotelID.Value)
, GlobalCode.Field2String(uoHiddenFieldUser.Value)
, GlobalCode.Field2String(txtEmailTo.Text)
, GlobalCode.Field2String(txtEmailCC.Text)
, GlobalCode.Field2String(uoTextBoxConfirmedBy.Text)
, GlobalCode.Field2String(uoTextBoxComment.Text)
, GlobalCode.Field2DateTime(uoHiddenFieldCurrentDate.Value)
, GlobalCode.Field2String(uoHiddenFieldTimeZone.Value)
, GlobalCode.Field2String(uoHiddenFieldCurrentDate.Value));
Session["SeafarerDetailList"] = _SDetailList;
//AlertMessage("Request for hotel cancellation has been sent successfully.");
}
ClosePage();
}
catch (Exception ex)
{
AlertMessage(ex.Message);
}
}
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void uoButtonSend_click(object sender, EventArgs e)
{
CrewAssistBLL CA = new CrewAssistBLL();
string res = CA.GetHotelTransactionOverFlow(GlobalCode.Field2Long(uoHiddenFieldEmployeeID.Value)
, GlobalCode.Field2DateTime(uoHiddenFieldCheckinDate.Value)
, GlobalCode.Field2DateTime(uoHiddenFieldCheckOutDate.Value)
, GlobalCode.Field2Long(uoHiddenFieldIDBigint.Value)
, GlobalCode.Field2TinyInt(uoHiddenFieldSeqNo.Value)
, GlobalCode.Field2Long(uoHiddenFieldTravelRequestID.Value)
, GlobalCode.Field2Int(uoHiddenFieldBranchID.Value)
, ""
, GlobalCode.Field2Int(uoHiddenFieldHotelTransID.Value));
if (res == "Record has hotel request already on this date!")
{
OpenParentExistHotelRequest(TextBoxWhoConfirm.Text.ToString(), TextBoxConfirmrate.Text.ToString(), res);
}
else
{
OpenParentSend(TextBoxWhoConfirm.Text.ToString(), TextBoxConfirmrate.Text.ToString());
}
}
void GetCrewAssistHotelInformation(object obj)
{
SF = new CrewAssistBLL();
Session["ContactPerson"] = null;
Session["ContractRate"] = null;
Session["HotelEmailTo"] = null;
DateTime starDate = DateTime.Now;
DateTime enddate = DateTime.Now.AddDays(1);
List <CrewAssistHotelInformation> _HotelInformationList = new List <CrewAssistHotelInformation>();
_HotelInformationList = SF.CrewAssistHotelInformation(0,
GlobalCode.Field2Int(((System.Web.UI.WebControls.ListBox)obj).SelectedValue),
"", "", starDate, 0);
uoTextContractedRate.Text = "";
uoTextBoxMealVoucher.Text = "";
uoTextBoxComfirmRate.Text = "";
CheckBoxEmail.Checked = false;
uoTextBoxEmail.Text = "";
//CheckBoxFax.Checked = false;
//CheckBoxFax.Text = "Fax : ";
//CheckBoxCopycrewassist.Checked = false;
//CheckBoxCopycrewhotels.Checked = false;
//if (uoTextBoxStatus.Text.ToString() == "ON")
//{
// if (uoHiddenFieldRequestDate.Value == "")
// {
// starDate = GlobalCode.Field2DateTime(GlobalCode.Field2DateTime(uoHiddenFieldRequestDate.Value));
// enddate = GlobalCode.Field2DateTime(GlobalCode.Field2DateTime(uoHiddenFieldRequestDate.Value).AddDays(+1));
// }
// else
// {
// starDate = GlobalCode.Field2DateTime(GlobalCode.Field2DateTime(uoHiddenFieldRequestDate.Value).AddDays(-1));
// enddate = GlobalCode.Field2DateTime(uoHiddenFieldRequestDate.Value);
// }
//}
//else
//{
// if (uoHiddenFieldRequestDate.Value == "")
// {
// starDate = GlobalCode.Field2DateTime(GlobalCode.Field2DateTime(uoHiddenFieldRequestDate.Value));
// enddate = GlobalCode.Field2DateTime(GlobalCode.Field2DateTime(uoHiddenFieldRequestDate.Value).AddDays(+1));
// }
// else
// {
// enddate = GlobalCode.Field2DateTime(GlobalCode.Field2DateTime(uoHiddenFieldRequestDate.Value).AddDays(+1));
// starDate = GlobalCode.Field2DateTime(uoHiddenFieldRequestDate.Value);
// }
//}
uoTextBoxCheckinDate.Text = GlobalCode.Field2Date(starDate);
uoTextBoxCheckoutDate.Text = GlobalCode.Field2Date(enddate);
uoTextBoxDuration.Text = "1";
uoTxtBoxTimeOut.Text = DateTime.Now.Hour.ToString() + ":00";
uoTxtBoxTimeIn.Text = DateTime.Now.Hour.ToString() + ":00";
uoDropDownListCurrency.SelectedIndex = GlobalCode.GetselectedIndex(uoDropDownListCurrency, _HotelInformationList[0].CurrencyID);
if (_HotelInformationList.Count > 0)
{
//uoLabelAdress.Text = _HotelInformationList[0].Address;
//uoLabelTelephone.Text = _HotelInformationList[0].ContactNo;
uoHiddenFieldCityCode.Value = _HotelInformationList[0].CityCode;
uoTextContractedRate.Text = _HotelInformationList[0].ContractedRate;
uoTextBoxMealVoucher.Text = _HotelInformationList[0].MealVoucher;
uoTextBoxComfirmRate.Text = _HotelInformationList[0].ContractRoomRateTaxPercentage;
uoTextBoxEmail.Text = _HotelInformationList[0].EmailTo;
//CheckBoxFax.Text = "Fax : " + _HotelInformationList[0].FaxNo;
//TextBoxWhoConfirm.Text = _HotelInformationList[0].ContactPerson;
if (uoTextBoxEmail.Text.ToString().Length > 0)
{
CheckBoxEmail.Checked = true;
uoTextBoxEmail.Enabled = true;
}
uoCheckboxBreakfast.Checked = _HotelInformationList[0].IsBreakfast;
uoCheckboxLunch.Checked = _HotelInformationList[0].IsLunch;
uoCheckboxDinner.Checked = _HotelInformationList[0].IsDinner;
uoCheckBoxIsWithShuttle.Checked = _HotelInformationList[0].IsWithShuttle;
//if (_HotelInformationList[0].ATTEMail.Count > 0)
//{
// uoHiddenFieldHotelEmail.Value = _HotelInformationList[0].ATTEMail[0].Email;
//}
Session["ContactPerson"] = _HotelInformationList[0].ContactPerson;
Session["ContractRate"] = _HotelInformationList[0].ContractedRate;
Session["HotelEmailTo"] = _HotelInformationList[0].EmailTo;
uoHiddenFieldContractStart.Value = _HotelInformationList[0].ContractDateStarted;
uoHiddenFieldContractEnd.Value = _HotelInformationList[0].ContractDateEnd;
uoDropDownListRoomeType.SelectedValue = GlobalCode.Field2String(_HotelInformationList[0].RoomTypeID);
}
//ScriptManager.RegisterStartupScript(Page, GetType(), "key", "HighLightTab();", true);
}
void GetCrewAssistPAHotelInformation(long ID)
{
try
{
uoHiddenFieldContractStart.Value = "";
uoHiddenFieldContractEnd.Value = "";
SF = new CrewAssistBLL();
Session["ContactPerson"] = null;
Session["ContractRate"] = null;
Session["HotelEmailTo"] = null;
DateTime starDate = DateTime.Now;
DateTime enddate = DateTime.Now;
List <CrewAssistHotelInformation> _HotelInformationList = new List <CrewAssistHotelInformation>();
_HotelInformationList = SF.GetPortAgentHotelVendor(0, ID,
0,
0, "");
uoTextContractedRate.Text = "";
uoTextBoxMealVoucher.Text = "";
uoTextBoxComfirmRate.Text = "";
CheckBoxEmail.Checked = false;
uoTextBoxEmail.Text = "";
//CheckBoxFax.Checked = false;
//CheckBoxFax.Text = "Fax : ";
//CheckBoxCopycrewassist.Checked = false;
//CheckBoxCopycrewhotels.Checked = false;
//if (uoTextBoxStatus.Text.ToString() == "ON")
//{
// if (uoHiddenFieldRequestDate.Value == "")
// {
// starDate = GlobalCode.Field2DateTime(GlobalCode.Field2DateTime(uoHiddenFieldRequestDate.Value));
// enddate = GlobalCode.Field2DateTime(GlobalCode.Field2DateTime(uoHiddenFieldRequestDate.Value).AddDays(+1));
// }
// else
// {
// starDate = GlobalCode.Field2DateTime(GlobalCode.Field2DateTime(uoHiddenFieldRequestDate.Value).AddDays(-1));
// enddate = GlobalCode.Field2DateTime(uoHiddenFieldRequestDate.Value);
// }
//}
//else
//{
// if (uoHiddenFieldRequestDate.Value == "")
// {
// starDate = GlobalCode.Field2DateTime(GlobalCode.Field2DateTime(uoHiddenFieldRequestDate.Value));
// enddate = GlobalCode.Field2DateTime(GlobalCode.Field2DateTime(uoHiddenFieldRequestDate.Value).AddDays(+1));
// }
// else
// {
// enddate = GlobalCode.Field2DateTime(GlobalCode.Field2DateTime(uoHiddenFieldRequestDate.Value).AddDays(+1));
// starDate = GlobalCode.Field2DateTime(uoHiddenFieldRequestDate.Value);
// }
//}
uoTextBoxCheckinDate.Text = GlobalCode.Field2Date(starDate);
uoTextBoxCheckoutDate.Text = GlobalCode.Field2Date(enddate);
uoTextBoxDuration.Text = "1";
uoTxtBoxTimeOut.Text = DateTime.Now.Hour.ToString() + ":00";
uoTxtBoxTimeIn.Text = DateTime.Now.Hour.ToString() + ":00";
if (_HotelInformationList.Count > 0)
{
//uoLabelAdress.Text = _HotelInformationList[0].Address;
//uoLabelTelephone.Text = _HotelInformationList[0].ContactNo;
uoHiddenFieldCityCode.Value = _HotelInformationList[0].CityCode;
uoTextContractedRate.Text = _HotelInformationList[0].ContractedRate;
uoTextBoxMealVoucher.Text = _HotelInformationList[0].MealVoucher;
uoTextBoxComfirmRate.Text = _HotelInformationList[0].ContractRoomRateTaxPercentage;
uoTextBoxEmail.Text = _HotelInformationList[0].EmailTo;
//CheckBoxFax.Text = "Fax : " + _HotelInformationList[0].FaxNo;
//TextBoxWhoConfirm.Text = _HotelInformationList[0].ContactPerson;
if (uoTextBoxEmail.Text.ToString().Length > 0)
{
CheckBoxEmail.Checked = true;
uoTextBoxEmail.Enabled = true;
}
uoCheckboxBreakfast.Checked = _HotelInformationList[0].IsBreakfast;
uoCheckboxLunch.Checked = _HotelInformationList[0].IsLunch;
uoCheckboxDinner.Checked = _HotelInformationList[0].IsDinner;
uoCheckBoxIsWithShuttle.Checked = _HotelInformationList[0].IsWithShuttle;
uoDropDownListCurrency.SelectedIndex = GlobalCode.GetselectedIndex(uoDropDownListCurrency, _HotelInformationList[0].CurrencyID);
//uoHiddenFieldHotelEmail.Value = "";
//if (_HotelInformationList[0].ATTEMail.Count > 0)
//{
// uoHiddenFieldHotelEmail.Value = _HotelInformationList[0].ATTEMail[0].Email;
// Session["HotelEmailTo"] = _HotelInformationList[0].ATTEMail;
//}
Session["ContactPerson"] = _HotelInformationList[0].ContactPerson;
Session["ContractRate"] = _HotelInformationList[0].ContractedRate;
Session["HotelEmailTo"] = _HotelInformationList[0].EmailTo;
uoHiddenFieldContractStart.Value = _HotelInformationList[0].ContractDateStarted;
uoHiddenFieldContractEnd.Value = _HotelInformationList[0].ContractDateEnd;
uoDropDownListRoomeType.SelectedValue = GlobalCode.Field2String(_HotelInformationList[0].RoomTypeID);
}
}
catch (Exception ex)
{
AlertMessage("DownListPort: " + ex.Message);
}
}
/// ----------------------------------------------
/// Modified By: Muhallidin G Wali
/// Date Modified: 07/02/2012
/// Description: Add option "Select ALL Hotel" ,"-1" if there is selected Region
/// ----------------------------------------------
/// </summary>
private void LoadAllCombo()
{
List <CrewAssistGenericClass> list = new List <CrewAssistGenericClass>();
try
{
SF = new CrewAssistBLL();
list = SF.GetGetHotelPortExpendTypeList(uoHiddenFieldUser.Value, "0", "0");
lstHotel.DataSource = null;
lstHotel.Items.Clear();
uoDropDownListPort.DataSource = null;
uoDropDownListPort.Items.Clear();
uoDropDownListHotel.DataSource = null;
uoDropDownListHotel.Items.Clear();
Session["CrewAssistVehicleVendor"] = null;
int iRowCount = list.Count;
if (iRowCount > 0)
{
Session["HotelNameList"] = list[0].CrewAssistHotelList;
lstHotel.DataSource = list[0].CrewAssistHotelList;
lstHotel.DataTextField = "HotelName";
lstHotel.DataValueField = "HotelID";
lstHotel.DataBind();
uoDropDownListPort.DataSource = null;
uoDropDownListPort.Items.Clear();
Session["CrewAssitPortList"] = list[0].CrewAssitPortList;
uoDropDownListPort.DataSource = list[0].CrewAssitPortList;
uoDropDownListPort.DataTextField = "PORTName";
uoDropDownListPort.DataValueField = "PORTID";
uoDropDownListPort.DataBind();
uoDropDownListPort.Items.Insert(0, new ListItem("--Select Port--", "0"));
//lstPort.DataSource = list[0].CrewAssitPortList;
//lstPort.DataTextField = "PORTName";
//lstPort.DataValueField = "PORTID";
//lstPort.DataBind();
uoDropDownListCurrency.DataSource = list[0].CrewAssistCurrency;
uoDropDownListCurrency.DataTextField = "CurrencyName";
uoDropDownListCurrency.DataValueField = "CurrencyID";
uoDropDownListCurrency.DataBind();
//uoDropDownListRouteFrom.Items.Clear();
//uoDropDownListRouteFrom.Items.Add(new ListItem("--Select Route From--", "0"));
//uoDropDownListRouteFrom.DataSource = list[0].CrewAssistRout;
//uoDropDownListRouteFrom.DataTextField = "RoutName";
//uoDropDownListRouteFrom.DataValueField = "RoutId";
//uoDropDownListRouteFrom.DataBind();
//uoDropDownListMAGTo.Items.Clear();
//uoDropDownListMAGTo.Items.Add(new ListItem("--Select To--", "0"));
//uoDropDownListMAGTo.DataSource = list[0].CrewAssistRout;
//uoDropDownListMAGTo.DataTextField = "RoutName";
//uoDropDownListMAGTo.DataValueField = "RoutId";
//uoDropDownListMAGTo.DataBind();
//ListView mylist = ((ListView)uoListViewTranportationRoute);
//ListViewItem lvi = null;
//if (mylist.Controls.Count == 1)
// lvi = mylist.Controls[0] as ListViewItem;
//ListView mylist = ((ListView)uoListViewTranportationRoute)
//if (lvi == null || lvi.ItemType != ListViewItemType.EmptyItem)
// return;
//Literal literal1 = (Literal)lvi.FindControl("Literal1");
//if (literal1 != null)
// literal1.Text = "No items to display";
//Session["CrewAssistVehicleVendor"] = list[0].VehicleVendor;
//var Vehresult = (from dbo in list[0].VehicleVendor
// select new
// {
// Vehicle = dbo.Vehicle,
// VehicleID = dbo.VehicleID,
// IsPortAgent = dbo.IsPortAgent
// }).Distinct();
//uoDropDownListVehicleVendor.DataSource = null;
//uoDropDownListVehicleVendor.Items.Clear();
//uoDropDownListVehicleVendor.DataSource = Vehresult;
//uoDropDownListVehicleVendor.DataTextField = "Vehicle";
//uoDropDownListVehicleVendor.DataValueField = "VehicleID";
//uoDropDownListVehicleVendor.DataBind();
//uoDropDownListVehicleVendor.Items.Insert(0, new ListItem("--Select Vehicle--", "0"));
//uoDropDownListVCountryVisiting.DataSource = list[0].CrewAssistNationality;
//uoDropDownListVCountryVisiting.DataTextField = "Nationality";
//uoDropDownListVCountryVisiting.DataValueField = "NatioalityID";
//uoDropDownListVCountryVisiting.DataBind();
//uoDropDownListVCountryVisiting.Items.Insert(0, new ListItem("--Select Country Visit--", "0"));
//Session["MeetAndGreetVendor"] = list[0].CrewAssistMeetAndGreetVendor;
//var result = (from dbo in list[0].CrewAssistMeetAndGreetVendor
// select new
// {
// MeetAndGreetVendor = dbo.MeetAndGreetVendor,
// MeetAndGreetVendorID = dbo.MeetAndGreetVendorID
// })
// .ToList().Distinct();
////var rr = list[0].CrewAssistMeetAndGreetVendor.Select(e => new { e.MeetAndGreetVendor, e.MeetAndGreetVendorID }).Distinct();
//uoDropDownListMAndGVendor.DataSource = null;
//uoDropDownListMAndGVendor.Items.Clear();
//uoDropDownListMAndGVendor.DataSource = result;
//uoDropDownListMAndGVendor.DataTextField = "MeetAndGreetVendor";
//uoDropDownListMAndGVendor.DataValueField = "MeetAndGreetVendorID";
//uoDropDownListMAndGVendor.DataBind();
//uoDropDownListMAndGVendor.Items.Insert(0, new ListItem("--Select Meet And Greet--", "0"));
//Session["PortAgentVendor"] = list[0].CrewAssistVendorPortAgent;
//var PAsult = (from dbo in list[0].CrewAssistVendorPortAgent
// select new
// {
// PortAgentVendorName = dbo.PortAgentVendorName,
// PortAgentVendorID = dbo.PortAgentVendorID
// })
// .ToList().Distinct();
//uoDropDownListPortAgent.DataSource = PAsult;
//uoDropDownListPortAgent.DataTextField = "PortAgentVendorName";
//uoDropDownListPortAgent.DataValueField = "PortAgentVendorID";
//uoDropDownListPortAgent.DataBind();
//uoDropDownListPortAgent.Items.Insert(0, new ListItem("--Select Service Provider--", "0"));
//var Safresult = (from dbo in list[0].CrewAssistSafeguardVendor
// select new
// {
// SafeguardName = dbo.SafeguardName,
// SafeguardVendorID = dbo.SafeguardVendorID
// })
// .ToList().Distinct();
//Session["CrewAssistSafeguardVendor"] = list[0].CrewAssistSafeguardVendor;
//uoDropDownListSafeguard.Items.Clear();
//uoDropDownListSafeguard.Items.Add(new ListItem("--Select Safeguard--", "0"));
//uoDropDownListSafeguard.DataSource = Safresult;
//uoDropDownListSafeguard.DataTextField = "SafeguardName";
//uoDropDownListSafeguard.DataValueField = "SafeguardVendorID";
//uoDropDownListSafeguard.DataBind();
////uoDropDownListSafeguard.SelectedValue = "0";
//cboAirportList.DataSource = list[0].CrewAssistAirport;
//cboAirportList.DataTextField = "PortName";
//cboAirportList.DataValueField = "PortCode";
//cboAirportList.DataBind();
//cboRemarkType.Items.Clear();
//cboRemarkType.Items.Add(new ListItem("--Select Type--", "0"));
//cboRemarkType.DataSource = list[0].RemarkType;
//cboRemarkType.DataTextField = "RemarkType";
//cboRemarkType.DataValueField = "RemarkTypeID";
//cboRemarkType.DataBind();
//cboRemarkStatus.Items.Clear();
//cboRemarkStatus.Items.Add(new ListItem("--Select Remark Status--", "0"));
//cboRemarkStatus.DataSource = list[0].RemarkStatus;
//cboRemarkStatus.DataTextField = "RemarkType";
//cboRemarkStatus.DataValueField = "RemarkTypeID";
//cboRemarkStatus.DataBind();
//cboRemarkRequestor.Items.Clear();
//cboRemarkRequestor.Items.Add(new ListItem("--Select Remark Requestor--", "0"));
//cboRemarkRequestor.DataSource = list[0].RemarkRequestor;
//cboRemarkRequestor.DataTextField = "RemarkType";
//cboRemarkRequestor.DataValueField = "RemarkTypeID";
//cboRemarkRequestor.DataBind();
}
}
catch (Exception ex)
{
throw ex;
}
}
