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