void LoadImmigrationCompany(string userid, bool isPostBack) { MaintenanceViewBLL BLL = new MaintenanceViewBLL(); List <ImmigrationCompanyGenericClass> ImmigrationCom = new List <ImmigrationCompanyGenericClass>(); ImmigrationCom = BLL.GetImmigationCompany(userid); uoListviewImmigrationCompany.DataSource = ImmigrationCom[0].ImmigrationCompany; uoListviewImmigrationCompany.DataBind(); if (isPostBack == true) { cboCountry.Items.Clear(); cboCountry.Items.Add(new ListItem("--Select Country--", "0")); cboCountry.DataSource = ImmigrationCom[0].Country.OrderBy(n => n.CountryName); cboCountry.DataTextField = "CountryName"; cboCountry.DataValueField = "CountryID"; cboCountry.DataBind(); Session["Country"] = ImmigrationCom[0].Country; cboCity.Items.Clear(); cboCity.Items.Add(new ListItem("--Select City--", "0")); } }
protected void uoListViewPortAgent_ItemCommand(object sender, System.Web.UI.WebControls.ListViewCommandEventArgs e) { string strLogDescription; string strFunction; int index = GlobalCode.Field2Int(e.CommandArgument); if (e.CommandName == "Delete") { MaintenanceViewBLL.DeleteVehicleVendor(index, uoHiddenFieldUser.Value); //Insert log audit trail (Gabriel Oquialda - 17/11/2011) strLogDescription = "Vehicle vendor branch deleted. (flagged as inactive)"; strFunction = "uoListViewPortAgent_ItemCommand"; DateTime currentDate = CommonFunctions.GetCurrentDateTime(); BLL.AuditTrailBLL.InsertLogAuditTrail(index, "", strLogDescription, strFunction, Path.GetFileName(Request.Path), CommonFunctions.GetDateTimeGMT(currentDate), DateTime.Now, uoHiddenFieldUser.Value); GetPortAgentList(); } else if (e.CommandName != "") { uoHiddenFieldSortBy.Value = e.CommandName; GetPortAgentList(); } else { uoHiddenFieldSortBy.Value = "SortByName"; } }
/// <summary> /// Date Created: 26/12/2011 /// Created By: Josephine Gad /// (description) Save stripes and room types /// ------------------------------------------- /// </summary> private void SaveStripeRoom() { DataTable dtStripeRoom = null; if (uoHiddenFieldStripe.Value != "") { dtStripeRoom = MaintenanceViewBLL.SaveStripeRoomType("0", uoHiddenFieldStripe.Value, uoHiddenFieldRoomID.Value, DateTime.Parse(uoHiddenFieldEffectiveDate.Value), uoHiddenFieldContractLength.Value, GlobalCode.Field2String(Session["UserName"])); uoDropDownListStripes.SelectedValue = ""; uoDropDownListRoom.SelectedValue = "0"; if (GlobalCode.Field2Int(dtStripeRoom.Rows[0]["dtReturnType"]) == 0) { string strLogDescription; string strFunction; //Insert log audit trail (Gabriel Oquialda - 16/02/2012) strLogDescription = "Hotel stripe and room type added."; strFunction = "SaveStripeRoom"; DateTime dateNow = CommonFunctions.GetCurrentDateTime(); AuditTrailBLL.InsertLogAuditTrail(GlobalCode.Field2Int(dtStripeRoom.Rows[0]["dtStripeRoomID"]), "", strLogDescription, strFunction, Path.GetFileName(Request.UrlReferrer.AbsolutePath), CommonFunctions.GetDateTimeGMT(dateNow), DateTime.Now, GlobalCode.Field2String(Session["UserName"])); } else { AlertMessage("Hotel stripe and room type with same effective date already exists."); } } }
/// <summary> /// Author: Josephine Gad /// Date Created: 04/Jul/2014 /// Description: Insert/Delete hotel-brand-hotel matrix /// </summary> private void SaveBrandAirportHotel() { DataTable dtBrand = null; DataTable dtAirport = null; try { List <AirportDTO> listAirportAssigned = new List <AirportDTO>(); listAirportAssigned = GetAirportAssigned(); var listAirport = (from a in listAirportAssigned select new { AirportIDString = GlobalCode.Field2Int(a.AirportIDString) }).ToList(); dtBrand = new DataTable(); DataColumn colBrandID = new DataColumn("colBrandID", typeof(Int32)); dtBrand.Columns.Add(colBrandID); DataRow rowBrand; dtAirport = new DataTable(); DataColumn colAirportID = new DataColumn("colAirportID", typeof(Int32)); dtAirport.Columns.Add(colAirportID); for (int i = 0; i < uoCheckBoxListBrand.Items.Count; i++) { if (uoCheckBoxListBrand.Items[i].Selected) { rowBrand = dtBrand.NewRow(); rowBrand["colBrandID"] = GlobalCode.Field2Int(uoCheckBoxListBrand.Items[i].Value); dtBrand.Rows.Add(rowBrand); } } dtAirport = getDataTable(listAirport); DateTime dateNow = CommonFunctions.GetCurrentDateTime(); MaintenanceViewBLL.BrandAirportHotelSave(GlobalCode.Field2Int(uoHiddenFieldHotelID.Value), uoHiddenFieldUser.Value, "Save Hotel Brand Airport matrix", "SaveBrandAirportHotel", Path.GetFileName(Request.Path), CommonFunctions.GetDateTimeGMT(dateNow), DateTime.Now, dtBrand, dtAirport); ClosePage(""); } catch (Exception ex) { throw ex; } finally { if (dtBrand != null) { dtBrand.Dispose(); } if (dtAirport != null) { dtAirport.Dispose(); } } }
/// <summary> /// Author: Josephine Gad /// Date Created: 16/08/2012 /// Description: Bind Airport /// </summary> private void BindAirport() { List <Airport> air = new List <Airport>(); air = MaintenanceViewBLL.GetAirportList(uoHiddenFieldUser.Value, uoHiddenFieldRole.Value, 0, 0, true); uoDropDownListPort.Items.Clear(); if (air.Count > 0) { uoDropDownListPort.DataSource = air; uoDropDownListPort.DataTextField = "AirportName"; uoDropDownListPort.DataValueField = "AirportID"; } uoDropDownListPort.DataBind(); if (air.Count == 1) { if (uoDropDownListPort.Items.FindByValue(GlobalCode.Field2String(air[0].AirportID)) != null) { uoDropDownListPort.SelectedValue = GlobalCode.Field2String(air[0].AirportID); } } if (GlobalCode.Field2String(Session["Airport"]) != "") { if (uoDropDownListPort.Items.FindByValue(GlobalCode.Field2String(Session["Airport"])) != null) { uoDropDownListPort.SelectedValue = GlobalCode.Field2String(Session["Airport"]); } } uoDropDownListPort.Items.Insert(0, new ListItem("--Select Airport--", "0")); Session["Airport"] = uoDropDownListPort.SelectedValue; }
/// <summary> /// Date Created: 28/12/2011 /// Created By: Josephine Gad /// (description) Save Priority /// </summary> private void SavePriority() { foreach (ListViewItem item in uoHotelVendorList.Items) { string strLogDescription; string strFunction; HiddenField uoHiddenFieldBranchID = (HiddenField)item.FindControl("uoHiddenFieldBranchID"); TextBox uoTextBoxPriority = (TextBox)item.FindControl("uoTextBoxPriority"); if (uoHiddenFieldBranchID != null) { Int32 AirportHotelID = MaintenanceViewBLL.SaveHotelPriority(uoDropDownListAirport.SelectedValue, uoHiddenFieldBranchID.Value, uoTextBoxPriority.Text, GlobalCode.Field2String(Session["UserName"])); //Insert log audit trail (Gabriel Oquialda - 14/02/2012) strLogDescription = "Hotel branch priority updated."; strFunction = "SavePriority"; DateTime currentDate = CommonFunctions.GetCurrentDateTime(); BLL.AuditTrailBLL.InsertLogAuditTrail(AirportHotelID, "", strLogDescription, strFunction, Path.GetFileName(Request.Path), CommonFunctions.GetDateTimeGMT(currentDate), DateTime.Now, GlobalCode.Field2String(Session["UserName"])); } } }
/// <summary> /// Date Created: 26/12/2011 /// Created By: Josephine Gad /// (description) Get list of stripes /// ------------------------------------------- /// Date Modified: 24/02/2012 /// Modified By: Josephine Gad /// (description) Change DataTable to Stripe.StripeList /// ------------------------------------------- /// Date Modified: 31/05/2012 /// Modified By: Josephine Gad /// (description) Do not use Stripe.StripeList /// ------------------------------------------- /// </summary> private void BindStripes() { List <Stripe> list = null; try { //if (Stripe.StripeList == null) //{ list = MaintenanceViewBLL.GetStripes(); //} uoDropDownListStripes.Items.Clear(); if (list.Count > 0) { uoDropDownListStripes.DataTextField = "StripeName"; uoDropDownListStripes.DataValueField = "Stripes"; uoDropDownListStripes.DataSource = list; } uoDropDownListStripes.DataBind(); uoDropDownListStripes.Items.Insert(0, new ListItem("--Select Stripe--", "")); } catch (Exception ex) { throw ex; } //finally //{ // if (list != null) // { // list = null; // } //} }
/// <summary> /// Date Created: 08/09/2011 /// Created By: Gabriel Oquialda /// (description) Get the list of vehicle vendors branch /// ---------------------------------------------- /// Date Modified: 28/10/2011 /// Modified By: Josephine Gad /// (description) Change uoDropDownListRegion.SelectedValue to GlobalCode.Field2String(Session["Region"]) /// </summary> private void GetVehicleVendorBranchListByUser(string strVehicleName) { uoVehicleVendorList.DataSource = MaintenanceViewBLL.GetVehicleVendorBranchListByUser(strVehicleName, GlobalCode.Field2String(Session["UserName"]), GlobalCode.Field2String(Session["Region"]), Session["Country"].ToString(), Session["City"].ToString(), Session["Port"].ToString(), Session["Hotel"].ToString(), GlobalCode.Field2String(Session["UserRole"])); uoVehicleVendorList.DataBind(); }
/// <summary> /// Date Created: 07/03/2012 /// Created By: Josephine Gad /// (description) Add try and catch and dispose DataTable /// --------------------------------------------------------------------- /// </summary> protected void DeleteAirport(Int32 AirportSeaportID, string AirportID, string AirportCode, string AirportName) { List <Airport> AirportList = null; Airport AirportItem = null; List <Airport> AirportNotInList = null; try { AirportList = AirportInSeaport(false); AirportNotInList = AirportNotInSeaport(false); string strLogDescription; string strFunction; if (uoHiddenFieldPortID.Value != "" && uoHiddenFieldPortID.Value != "0") { if (AirportSeaportID != 0) { strLogDescription = "Airport deleted from Seaport. (flagged as inactive)"; strFunction = "DeleteAirport"; MaintenanceViewBLL.RemoveAirportInSeaport(uoHiddenFieldUser.Value, AirportID, uoHiddenFieldPortID.Value, strLogDescription, strFunction, Path.GetFileName(Request.Path)); } } AirportItem = new Airport(); AirportItem.AirportSeaportID = 0; AirportItem.AirportID = GlobalCode.Field2TinyInt(AirportID); AirportItem.AirportCode = AirportCode; AirportItem.AirportName = AirportName; AirportItem.AirportCodeName = AirportName + " :: " + AirportCode; AirportNotInList.Add(AirportItem); AirportList.RemoveAll(a => a.AirportID == GlobalCode.Field2TinyInt(AirportID)); Airport.AirportList = AirportList; Airport.AirportNotInList = AirportNotInList; uoGridViewAirport.DataSource = AirportList; uoGridViewAirport.Columns[0].Visible = true; uoGridViewAirport.Columns[1].Visible = true; uoGridViewAirport.DataBind(); uoGridViewAirport.Columns[0].Visible = false; uoGridViewAirport.Columns[1].Visible = false; LoadAirportDDL(false); } catch (Exception ex) { throw ex; } finally { } }
protected void btnSave_click(object sender, EventArgs e) { MaintenanceViewBLL BLL = new MaintenanceViewBLL(); List <ImmigrationCompany> ImmigrationCom = new List <ImmigrationCompany>(); var list = BLL.SaveImmigationCompany(GlobalCode.Field2Int(uoHiddenFieldImmigrationCompanyID.Value), GlobalCode.Field2Int(cboCountry.SelectedValue), GlobalCode.Field2Int(cboCity.SelectedValue), txtCompany.Text.ToString(), txtAddress.Text.ToString(), txtEmailAdd.Text.ToString(), txtPhoneNo.Text.ToString(), (Request.QueryString["uID"] != null) ? Request.QueryString["uID"] : ""); uoListviewImmigrationCompany.DataSource = list; uoListviewImmigrationCompany.DataBind(); }
private void GetVehicleVendorList(string strVehicleName) { /// <summary> /// Date Created: 04/08/2011 /// Created By: Marco Abejar /// (description) Get the list of vehicle vendors /// </summary> uoVehicleVendorList.DataSource = MaintenanceViewBLL.GetVehicleVendorList(strVehicleName, GlobalCode.Field2String(Session["UserName"]), uoDropDownListRegion.SelectedValue); uoVehicleVendorList.DataBind(); }
//protected void uoDropDownListRegion_SelectedIndexChanged(object sender, EventArgs e) //{ // GetPortList(uoTextBoxSearchParam.Text); //} #endregion #region Functions private void GetPortList(string strPortName) { /// <summary> /// Date Created: 04/08/2011 /// Created By: Marco Abejar /// (description) Get the list of ports /// </summary> uoPortCompanyList.DataSource = MaintenanceViewBLL.GetPortCompanyList(strPortName, GlobalCode.Field2String(Session["UserName"]), Session["Region"].ToString()); uoPortCompanyList.DataBind(); }
/// <summary> /// Date Created: 07/03/2012 /// Created By: Josephine Gad /// (description) Remove Airport in Seaport /// </summary> /// <param name="sAirport"></param> /// <param name="sBranch"></param> private void DeleteHotelInAirport(string sAirport, string sBranch) { string strLogDescription; string strFunction; //Insert log audit trail (Gabriel Oquialda - 16/02/2012) strLogDescription = "Delete button from list clicked."; strFunction = "DeleteHotelInAirport"; MaintenanceViewBLL.RemoveHotelInAirport(uoHiddenFieldUser.Value, sAirport, sBranch, strLogDescription, strFunction, Path.GetFileName(Request.Path)); }
private void SaveAirports() { DataTable dt = new DataTable(); dt.Columns.Add("airportID", typeof(int)); DataRow rowAirport; HiddenField uoHiddenFieldAirport; DataTable dtBrand = null; dtBrand = new DataTable(); DataColumn colBrandID = new DataColumn("colBrandID", typeof(Int32)); dtBrand.Columns.Add(colBrandID); DataRow rowBrand; int portAgent = GlobalCode.Field2Int(Request.QueryString["pid"]); try { foreach (ListViewItem item in uoListViewAirportSaved.Items) { uoHiddenFieldAirport = (HiddenField)item.FindControl("uoHiddenFieldAirportSaved"); //uoCheckBoxListBrand = (CheckBoxList)item.FindControl("uoCheckBoxListBrand"); UserAirportList AirportItem = new UserAirportList(); int airport = GlobalCode.Field2Int(uoHiddenFieldAirport.Value); //get brand and user id of user string stringger = Request.RawUrl.ToString(); rowAirport = dt.NewRow(); rowAirport["airportID"] = airport; dt.Rows.Add(rowAirport); } for (int i = 0; i < uoCheckBoxListBrand.Items.Count; i++) { if (uoCheckBoxListBrand.Items[i].Selected) { rowBrand = dtBrand.NewRow(); rowBrand["colBrandID"] = GlobalCode.Field2Int(uoCheckBoxListBrand.Items[i].Value); dtBrand.Rows.Add(rowBrand); } } MaintenanceViewBLL.BrandAirportVehicleSave(portAgent, dt, dtBrand, uoHiddenFieldUser.Value); } catch (Exception ex) { throw ex; } finally{ } }
protected void uoListviewImmigrationCompany_ItemCommand(object sender, ListViewCommandEventArgs e) { if (String.Equals(e.CommandName, "delete")) { MaintenanceViewBLL BLL = new MaintenanceViewBLL(); List <ImmigrationCompany> ImmigrationCom = new List <ImmigrationCompany>(); var list = BLL.DeleteImmigationCompany(GlobalCode.Field2Int(uoHiddenFieldImmigrationCompanyID.Value), (Request.QueryString["uID"] != null) ? Request.QueryString["uID"] : ""); uoListviewImmigrationCompany.DataSource = list; uoListviewImmigrationCompany.DataBind(); } else if (String.Equals(e.CommandName, "edit")) { Label lblCompanyName = (Label)e.Item.FindControl("lblCompanyName"); Label lblEmailAdd = (Label)e.Item.FindControl("lblEmailAdd"); Label lblContact = (Label)e.Item.FindControl("lblContact"); Label lblAddress = (Label)e.Item.FindControl("lblAddress"); HiddenField HFImmigrationCompanyID = (HiddenField)e.Item.FindControl("HFImmigrationCompanyID"); HiddenField HFCountryID = (HiddenField)e.Item.FindControl("HFCountryID"); HiddenField HFCityID = (HiddenField)e.Item.FindControl("HFCityID"); txtCompany.Text = lblCompanyName.Text; txtAddress.Text = lblAddress.Text; txtEmailAdd.Text = lblEmailAdd.Text; lblAddress.Text = lblAddress.Text; uoHiddenFieldImmigrationCompanyID.Value = HFImmigrationCompanyID.Value; cboCountry.SelectedIndex = GlobalCode.GetselectedIndexValue(cboCountry, HFCountryID.Value); List <Country> country = (List <Country>)Session["Country"]; List <Country> City = country.Where(n => n.CountryID == GlobalCode.Field2Int(HFCountryID.Value)).OrderBy(a => a.CountryName).ToList(); cboCity.Items.Clear(); cboCity.Items.Add(new ListItem("--Select City--", "0")); cboCity.DataSource = City[0].City; cboCity.DataTextField = "CityName"; cboCity.DataValueField = "CityId"; cboCity.DataBind(); cboCity.SelectedIndex = GlobalCode.GetselectedIndexValue(cboCity, HFCityID.Value); } }
//private void GetHotelVendorList(string strHotelName) //{ // /// <summary> // /// Date Created: 04/08/2011 // /// Created By: Marco Abejar // /// (description) Get the list of hotel vendors // /// </summary> // //GlobalCode.Field2String(Session["Region"]), // // GlobalCode.Field2String(Session["Country"]), // //GlobalCode.Field2String(Session["City"]), // //GlobalCode.Field2String(Session["Port"]), // //GlobalCode.Field2String(Session["Hotel"]); // uoHotelVendorList.DataSource = MaintenanceViewBLL.GetHotelVendorList(strHotelName, GlobalCode.Field2String(Session["UserName"]), uoDropDownListRegion.SelectedValue); // uoHotelVendorList.DataBind(); //} /// <summary> /// Date Created: 04/08/2011 /// Created By: Marco Abejar /// (description) Get the list of hotel vendors /// -------------------------------------------------- /// Date Modified: 27/10/2011 /// Modified By: Josephine Gad /// (description) Validate if user role is not empty /// </summary> private void GetHotelVendorListByUser(string strHotelName) { //GlobalCode.Field2String(Session["Region"]), // GlobalCode.Field2String(Session["Country"]), //GlobalCode.Field2String(Session["City"]), //GlobalCode.Field2String(Session["Port"]), //GlobalCode.Field2String(Session["Hotel"]); if (Session["UserRole"] == null) { Session["UserRole"] = UserAccountBLL.GetUserPrimaryRole(GlobalCode.Field2String(Session["UserName"])); } uoHotelVendorList.DataSource = MaintenanceViewBLL.GetHotelVendorListByUser(strHotelName, GlobalCode.Field2String(Session["UserName"]), GlobalCode.Field2String(Session["Region"]), GlobalCode.Field2String(Session["UserVendor"]), GlobalCode.Field2String(Session["UserRole"])); uoHotelVendorList.DataBind(); }
/// <summary> /// Date Created: 26/12/2011 /// Created By: Josephine Gad /// (description) Delete stripes and room types /// ------------------------------------------- /// </summary> /// <param name="StripeRoomID"></param> private void DeleteStripeRoom(string StripeRoomID) { MaintenanceViewBLL.DeleteStripeRoomType(StripeRoomID, GlobalCode.Field2String(Session["UserName"])); string strLogDescription; string strFunction; //Insert log audit trail (Gabriel Oquialda - 16/02/2012) strLogDescription = "Hotel stripe and room type deleted. (flagged as inactive)"; strFunction = "SaveStripeRoom"; DateTime dateNow = CommonFunctions.GetCurrentDateTime(); AuditTrailBLL.InsertLogAuditTrail(Convert.ToInt32(StripeRoomID), "", strLogDescription, strFunction, Path.GetFileName(Request.UrlReferrer.AbsolutePath), CommonFunctions.GetDateTimeGMT(dateNow), DateTime.Now, GlobalCode.Field2String(Session["UserName"])); }
/// <summary> /// Date Created: 07/03/2012 /// Created By: Josephine Gad /// (description) Get Airport not in Seaport /// </summary> /// <param name="IsNew"></param> /// <returns></returns> private List <Airport> AirportNotInSeaport(bool IsNew) { List <Airport> list = new List <Airport>(); if (IsNew || Airport.AirportNotInList == null) { list = MaintenanceViewBLL.GetAirportList(uoHiddenFieldUser.Value, uoHiddenFieldRole.Value, GlobalCode.Field2Int(uoHiddenFieldPortID.Value), 0, false); Airport.AirportNotInList = list; } else { if (Airport.AirportNotInList == null) { List <Airport> AirportNotInList = new List <Airport>(); Airport AirportItem = new Airport(); string[] sAirportNameCode; string sCode; string sName; for (int i = 1; i <= uoDropDownListAiport.Items.Count; i++) { sAirportNameCode = uoDropDownListAiport.Items[i].Text.Split("::".ToCharArray()); if (sAirportNameCode.Length > 0) { sCode = sAirportNameCode[2].Trim(); sName = sAirportNameCode[0].Trim(); AirportItem = new Airport(); AirportItem.AirportSeaportID = 0; AirportItem.AirportID = GlobalCode.Field2TinyInt(uoDropDownListAiport.Items[i].Value); AirportItem.AirportCode = sCode; AirportItem.AirportName = sName; AirportNotInList.Add(AirportItem); } } Airport.AirportNotInList = AirportNotInList; } else { list = Airport.AirportNotInList; } } return(list); }
private void GetHotelVendorBranchList(string strHotelName) { DataTable dt = null; try { if (Session["UserRole"] == null) { Session["UserRole"] = UserAccountBLL.GetUserPrimaryRole(GlobalCode.Field2String(Session["UserName"])); } dt = MaintenanceViewBLL.GetHotelVendorBranchListByUser(strHotelName, GlobalCode.Field2String(Session["UserName"]), GlobalCode.Field2String(Session["Region"]), GlobalCode.Field2String(Session["Country"]), GlobalCode.Field2String(Session["Airport"]), GlobalCode.Field2String(Session["Port"]), "0", GlobalCode.Field2String(Session["UserRole"]), uoHiddenFieldSortByBranch.Value, uoHiddenFieldSortByPriority.Value ); //var results = from myRow in dt.AsEnumerable() // where myRow.Field<int>(uoHiddenFieldOrderBy.Value) == 1 // select myRow; //uoHotelVendorList.DataSource = results; DataView dtview = dt.DefaultView; uoHiddenFieldOrderBy.Value = (uoHiddenFieldOrderBy.Value == "SortByBranchName") ? "colVendorBranchNameVarchar" : uoHiddenFieldOrderBy.Value; dtview.Sort = uoHiddenFieldOrderBy.Value; uoHotelVendorList.DataSource = dtview.ToTable(); uoHotelVendorList.DataSource = dt; uoHotelVendorList.DataBind(); } catch (Exception ex) { throw ex; } finally { if (dt != null) { dt.Dispose(); } } }
//private void GetHotelVendorList(string strHotelName) //{ // /// <summary> // /// Date Created: 04/08/2011 // /// Created By: Marco Abejar // /// (description) Get the list of hotel vendors // /// </summary> // //GlobalCode.Field2String(Session["Region"]), // // GlobalCode.Field2String(Session["Country"]), // //GlobalCode.Field2String(Session["City"]), // //GlobalCode.Field2String(Session["Port"]), // //GlobalCode.Field2String(Session["Hotel"]); // uoHotelVendorList.DataSource = MaintenanceViewBLL.GetHotelVendorList(strHotelName, GlobalCode.Field2String(Session["UserName"]), uoDropDownListRegion.SelectedValue); // uoHotelVendorList.DataBind(); //} /// <summary> /// Date Created: 04/08/2011 /// Created By: Marco Abejar /// (description) Get the list of hotel vendors /// -------------------------------------------------- /// Date Modified: 27/10/2011 /// Modified By: Josephine Gad /// (description) Validate if user role is not empty /// /// -------------------------------------------------- /// Date Modified: 18/03/2013 /// Modified By: Marco Abejar /// (description) Add sorting /// </summary> private void GetHotelVendorListByUser(string strHotelName) { //GlobalCode.Field2String(Session["Region"]), // GlobalCode.Field2String(Session["Country"]), //GlobalCode.Field2String(Session["City"]), //GlobalCode.Field2String(Session["Port"]), //GlobalCode.Field2String(Session["Hotel"]); DataTable dt = MaintenanceViewBLL.GetHotelVendorListByUser(strHotelName, GlobalCode.Field2String(Session["UserName"]), GlobalCode.Field2String(Session["Region"]), GlobalCode.Field2String(Session["UserVendor"]), GlobalCode.Field2String(Session["UserRole"])); DataView dtView = dt.DefaultView; if (dt.Rows.Count > 0 && uoHiddenFieldOrderBy.Value != "0") { dtView.Sort = uoHiddenFieldOrderBy.Value; } uoHotelVendorList.DataSource = dtView.ToTable(); uoHotelVendorList.DataBind(); }
/// <summary> /// Date Created: 02/Jul/2014 /// Created By: Josephine Gad /// (description) Refresh Branch List based from filter /// </summary> public List <VendorHotelList> GetBranch(int iRegionID, int iAirportID, string sAirportName, Int16 iRoomTypeID, int iBrandID, string sBranchFilter, string sOrderBy, Int16 iLoadType, string sUserID, int iStartRow, int iMaxRow) { if (Session["HotelAirportBrand_Hotel"] == null) { sAirportName = GlobalCode.Field2String(sAirportName); sBranchFilter = GlobalCode.Field2String(sBranchFilter); MaintenanceViewBLL BLL = new MaintenanceViewBLL(); BLL.GetHotelVendorBranchListByBrand(iRegionID, iAirportID, sAirportName.Trim(), iRoomTypeID, iBrandID, sBranchFilter.Trim(), sOrderBy, iLoadType, sUserID, iStartRow, iMaxRow); } List <VendorHotelList> listHotel = new List <VendorHotelList>(); listHotel = (List <VendorHotelList>)Session["HotelAirportBrand_Hotel"]; return(listHotel); }
/// <summary> /// Date Created: 01/Jul/2014 /// Created By: Josephine Gad /// (description) Bind the details inside this page /// </summary> private void BindPage() { int iRegionID = GlobalCode.Field2Int(Session["Region"]); int iAirportID = GlobalCode.Field2Int(uoDropDownListAirport.SelectedValue); Int16 iRoomTypeID = GlobalCode.Field2TinyInt(uoDropDownListRoom.SelectedValue); int iBrandID = GlobalCode.Field2Int(uoDropDownListBrand.SelectedValue); MaintenanceViewBLL BLL = new MaintenanceViewBLL(); BLL.GetHotelVendorBranchListByBrand(iRegionID, iAirportID, uoTextBoxAirport.Text.Trim(), iRoomTypeID, iBrandID, uoTextBoxSearchParam.Text.Trim(), uoHiddenFieldOrderBy.Value, 0, uoHiddenFieldUser.Value, 0, uoListViewHotelPager.PageSize); BindRegion(); BindBrand(); BindAirport(0); BindRoomType(); //BindBranch(); uoListViewHotel.DataSourceID = "uoObjectDataSourceHotel"; }
/// <summary> /// Date Created: 26/12/2011 /// Created By: Josephine Gad /// (description) Get list of stripes and room types /// ------------------------------------------- /// </summary> private void BindStripesRoomTypes() { DataTable dt = null; try { dt = MaintenanceViewBLL.GetStripesRoomType(); uoStripesRoomList.DataSource = dt; uoStripesRoomList.DataBind(); } catch (Exception ex) { throw ex; } finally { if (dt != null) { dt.Dispose(); } } }
/// <summary> /// Date Created: 28/May/2013 /// Created By: Josephine Gad /// (description) Bind Airport by Seaport /// --------------------------------------------------------------------------- /// </summary> private void GetAirport() { List <Airport> list = new List <Airport>(); list = MaintenanceViewBLL.GetAirportListByRegionBySeaport(uoHiddenFieldUser.Value, "", GlobalCode.Field2Int(uoDropDownListPort.SelectedValue), GlobalCode.Field2Int(uoDropDownListRegion.SelectedValue)); uoDropDownListAirport.Items.Clear(); uoDropDownListAirport.Items.Insert(0, new ListItem("--Select Airport--", "0")); uoDropDownListAirport.DataSource = list; uoDropDownListAirport.DataTextField = "AirportCodeName"; uoDropDownListAirport.DataValueField = "AirportID"; uoDropDownListAirport.DataBind(); if (list.Count == 1) { if (uoDropDownListAirport.Items.FindByValue(GlobalCode.Field2String(list[0].AirportID)) != null) { uoDropDownListAirport.SelectedValue = GlobalCode.Field2String(list[0].AirportID); } } uoHiddenFieldAirPort.Value = uoDropDownListAirport.SelectedValue; }
protected void uoListViewVehicle_ItemCommand(object sender, System.Web.UI.WebControls.ListViewCommandEventArgs e) { string strLogDescription; string strFunction; int index = Convert.ToInt32(e.CommandArgument); if (e.CommandName == "Delete") { MaintenanceViewBLL.DeleteVehicleTypeBranch(index, GlobalCode.Field2String(Session["UserName"])); //Insert log audit trail (Gabriel Oquialda - 17/11/2011) strLogDescription = "Vehicle vendor branch vehicle type deleted. (flagged as inactive)"; strFunction = "uoListViewVehicle_ItemCommand"; DateTime currentDate = CommonFunctions.GetCurrentDateTime(); //BLL.AuditTrailBLL.InsertLogAuditTrail(strLogDescription, strFunction, Path.GetFileName(Request.Path), // CommonFunctions.GetDateTimeGMT(currentDate), DateTime.Now, GlobalCode.Field2String(Session["UserName"])); vehicleTypeBranchInfoLoad(Request.QueryString["vmId"]); } }
protected void uoHotelVendorList_ItemCommand(object sender, System.Web.UI.WebControls.ListViewCommandEventArgs e) { string strLogDescription; string strFunction; int index = Convert.ToInt32(e.CommandArgument); if (e.CommandName == "Delete") { MaintenanceViewBLL.DeleteHotelVendor(index, GlobalCode.Field2String(Session["UserName"])); //Insert log audit trail (Gabriel Oquialda - 14/02/2012) strLogDescription = "Hotel vendor deleted. (flagged as inactive)"; strFunction = "uoHotelVendorList_ItemCommand"; DateTime currentDate = CommonFunctions.GetCurrentDateTime(); BLL.AuditTrailBLL.InsertLogAuditTrail(index, "", strLogDescription, strFunction, Path.GetFileName(Request.Path), CommonFunctions.GetDateTimeGMT(currentDate), DateTime.Now, GlobalCode.Field2String(Session["UserName"])); GetHotelVendorList(""); } }
/// <summary> /// Author: Josephine Gad /// Date Created: 03/Jul/2014 /// Description: Load value of selected hotel /// </summary> private void BindPage() { MaintenanceViewBLL.GetHotelDetails(GlobalCode.Field2Int(uoHiddenFieldHotelID.Value)); List <VendorHotelList> listHotel = new List <VendorHotelList>(); List <BrandList> listBrand = new List <BrandList>(); List <AirportDTO> listAirportNotAssigned = new List <AirportDTO>(); List <AirportDTO> listAirportAssigned = new List <AirportDTO>(); listHotel = (List <VendorHotelList>)Session["HotelAirportBrandPop_Hotel"]; if (listHotel.Count > 0) { uoTextBoxHotelName.Text = listHotel[0].HotelName; } listBrand = (List <BrandList>)Session["HotelAirportBrandPop_Brand"]; if (listBrand.Count > 0) { uoCheckBoxListBrand.DataSource = listBrand; uoCheckBoxListBrand.DataTextField = "BrandName"; uoCheckBoxListBrand.DataValueField = "BrandID"; uoCheckBoxListBrand.DataBind(); for (int i = 0; i < listBrand.Count; i++) { uoCheckBoxListBrand.Items[i].Selected = listBrand[i].IsAssigned; } } listAirportNotAssigned = (List <AirportDTO>)Session["HotelAirportBrandPop_AirportNotAssigned"]; uoListViewAirportNotAssigned.DataSource = listAirportNotAssigned; uoListViewAirportNotAssigned.DataBind(); listAirportAssigned = (List <AirportDTO>)Session["HotelAirportBrandPop_AirportAssigned"]; uoListViewAirportAssigned.DataSource = listAirportAssigned; uoListViewAirportAssigned.DataBind(); }
/// <summary> /// Date Created: 07/03/2012 /// Created By: Josephine Gad /// (description) Get Airport in Seaport /// </summary> /// <param name="IsNew"></param> /// <returns></returns> private List <Airport> AirportInSeaport(bool IsNew) { List <Airport> list = new List <Airport>(); if (IsNew || Airport.AirportList == null) { list = MaintenanceViewBLL.GetAirportList(uoHiddenFieldUser.Value, uoHiddenFieldRole.Value, GlobalCode.Field2Int(uoHiddenFieldPortID.Value), 0, true); Airport.AirportList = list; } else { if (Airport.AirportList == null) { List <Airport> AirportList = new List <Airport>(); Airport AirportItem = new Airport(); for (int i = 0; i < uoGridViewAirport.Rows.Count; i++) { AirportItem = new Airport(); AirportItem.AirportSeaportID = GlobalCode.Field2Int(uoGridViewAirport.Rows[i].Cells[0].Text); AirportItem.AirportID = GlobalCode.Field2TinyInt(uoGridViewAirport.Rows[i].Cells[1].Text); AirportItem.AirportCode = uoGridViewAirport.Rows[i].Cells[2].Text; AirportItem.AirportName = uoGridViewAirport.Rows[i].Cells[3].Text; AirportList.Add(AirportItem); } Airport.AirportList = AirportList; } else { list = Airport.AirportList; } } return(list); }
/// <summary> /// Date Created: 04/08/2011 /// Created By: Marco Abejar /// (description) Get the list of hotel vendors branch /// -------------------------------------------------- /// Date Modified: 27/10/2011 /// Modified By: Josephine Gad /// (description) Validate if user role is not empty /// Add DatTable dt to close /// </summary> private void GetHotelVendorBranchList(string strHotelName) { DataTable dt = null; try { if (Session["UserRole"] == null) { Session["UserRole"] = UserAccountBLL.GetUserPrimaryRole(GlobalCode.Field2String(Session["UserName"])); } dt = MaintenanceViewBLL.GetHotelVendorBranchListByUser(strHotelName, GlobalCode.Field2String(Session["UserName"]), GlobalCode.Field2String(Session["Region"]), GlobalCode.Field2String(Session["Country"]), GlobalCode.Field2String(Session["Airport"]), GlobalCode.Field2String(Session["Port"]), "0", GlobalCode.Field2String(Session["UserRole"]), uoHiddenFieldSortByBranch.Value, uoHiddenFieldSortByPriority.Value ); uoHotelVendorList.DataSource = dt; uoHotelVendorList.DataBind(); } catch (Exception ex) { throw ex; } finally { if (dt != null) { dt.Dispose(); } } }
/// <summary> /// Date Created: 03/Jul/2014 /// Created By: Josephine Gad /// (description) Save Priority /// </summary> private void SavePriority() { DataTable dt = null; try { DateTime dateNow = CommonFunctions.GetCurrentDateTime(); dt = new DataTable(); DataColumn col = new DataColumn("colBrandAirHotelIDInt", typeof(int)); dt.Columns.Add(col); col = new DataColumn("colBranchIDInt", typeof(int)); dt.Columns.Add(col); col = new DataColumn("colBrandIdInt", typeof(int)); dt.Columns.Add(col); col = new DataColumn("colAirportIDInt", typeof(int)); dt.Columns.Add(col); col = new DataColumn("colPriorityTinyint", typeof(Int16)); dt.Columns.Add(col); col = new DataColumn("colRoomIDInt", typeof(Int16)); dt.Columns.Add(col); DataRow r; int iTotalRow = uoListViewHotel.Items.Count; HiddenField hBrandAirportHoteID; TextBox tPriority; //for (int i = 0; i < iTotalRow; i++ ) foreach (ListViewItem item in uoListViewHotel.Items) { hBrandAirportHoteID = (HiddenField)item.FindControl("uoHiddenFieldBrandAirportHoteID"); tPriority = (TextBox)item.FindControl("uoTextBoxPriority"); r = dt.NewRow(); r["colBrandAirHotelIDInt"] = GlobalCode.Field2Int(hBrandAirportHoteID.Value); r["colPriorityTinyint"] = GlobalCode.Field2TinyInt(tPriority.Text); dt.Rows.Add(r); } MaintenanceViewBLL.BrandAirportHotelSavePriority(uoHiddenFieldUser.Value, "Save Brand Airport Hotel Priority", "SavePriority", Path.GetFileName(Request.Path), CommonFunctions.GetDateTimeGMT(dateNow), DateTime.Now, dt); AlertMessage("Priority successfully saved!"); } catch (Exception ex) { throw ex; } finally { if (dt != null) { dt.Dispose(); } } }