/// <summary> /// Author: Charlene Remotigue /// Date Created: 04/05/2012 /// Description: initialize session values /// </summary> protected void InitializeValues() { if (GlobalCode.Field2String(Session["UserName"]) == "") { Session["UserName"] = User.Identity.Name; } MembershipUser mUser = Membership.GetUser(GlobalCode.Field2String(Session["UserName"])); if (mUser == null) { Response.Redirect("~/Login.aspx"); } else { if (!mUser.IsOnline) { Response.Redirect("~/Login.aspx"); } } if (GlobalCode.Field2String(Session["DateFrom"]) == "") { Session["DateFrom"] = GlobalCode.Field2DateTime(Request.QueryString["dt"]).ToString("MM/dd/yyyy"); } Session["strPrevPage"] = Request.RawUrl; uoHiddenFieldDate.Value = GlobalCode.Field2DateTime(Session["DateFrom"]).ToString("MM/dd/yyyy"); uoHiddenFieldDate.Value = uoHiddenFieldDate.Value.Replace("_", "/"); }
/// <summary> /// Date Created: 22/02/2011 /// Created By: Josephine Gad /// (description) disable lock button if past dates and if there is no data /// ------------------------------------------------------- /// Date Modified: 23/03/2012 /// Modified By: Josephine Gad /// (description) disable lock button if already locked /// ------------------------------------------------------- /// Date Modified: 02/10/2012 /// Modified By: Josephine Gad /// (description) disable lock button if "ALL Hotel" is selected /// ------------------------------------------------------- /// </summary> private void ButtonLockSettings() { if (uolistviewHotelInfo.Items.Count > 0) { //uoBtnExportList.Enabled = true; if (uoDropDownListHotel.SelectedValue == "-1") { //uoButtonLock.Enabled = false; } } else { //uoBtnExportList.Enabled = false; } string sDate = GlobalCode.Field2DateTime((uoHiddenFieldDate.Value)).ToString(); if (GlobalCode.Field2DateTime((sDate)) < DateTime.Parse(DateTime.Now.ToString("MM/dd/yyyy"))) { //uoButtonLock.Enabled = false; } //bool IsAlreadyLocked = HotelManifestBLL.IsHotelHasLockedManifest(sDate, uoDropDownListHotel.SelectedValue, uoDropDownListHours.SelectedValue); //if (IsAlreadyLocked) //{ // uoButtonLock.Enabled = false; //} }
/// <summary> /// Author: Muhallidin G Wali /// Date Created: 23/Dec/2013 /// Description: create the file to be exported /// --------------------------------------------- /// </summary> /// <param name="dt"></param> //protected void CreateFile(DataTable dt, DataTable dtConfirmed, DataTable dtCancelled) protected void CreateFile(DataTable dt) { try { string strFileName = ""; string FilePath = Server.MapPath("~/Extract/VehicleManifest/"); string sDate = DateTime.Now.ToString(TravelMartVariable.DateTimeFormatFileExtension); string sDateManifest = GlobalCode.Field2DateTime(uoHiddenFieldDate.Value).ToString("MMMddyyy"); string FileName = "VehicleManifest_" + sDateManifest + '_' + sDate + ".xls"; strFileName = FilePath + FileName; if (File.Exists(strFileName)) { File.Delete(strFileName); } CreateExcel(dt, strFileName, uoHiddenFieldVendor.Value); OpenExcelFile(FileName, strFileName); } catch (Exception ex) { throw ex; } finally { if (dt != null) { dt.Dispose(); } } }
protected void uoObjectDataSourceHotel_Selecting(object sender, ObjectDataSourceSelectingEventArgs e) { e.InputParameters["DateFrom"] = GlobalCode.Field2DateTime((uoHiddenFieldDate.Value)).ToString(); e.InputParameters["DateTo"] = uoHiddenFieldDateTo.Value; e.InputParameters["UserID"] = uoHiddenFieldUser.Value; e.InputParameters["FilterByDate"] = Session["strPendingFilter"]; e.InputParameters["RegionID"] = GlobalCode.Field2String(Session["Region"]); e.InputParameters["CountryID"] = GlobalCode.Field2String(Session["Country"]); e.InputParameters["CityID"] = GlobalCode.Field2String(Session["City"]); e.InputParameters["Status"] = uoDropDownListStatus.SelectedValue; e.InputParameters["FilterByNameID"] = uoDropDownListFilterBy.SelectedValue; e.InputParameters["FilterNameID"] = uoTextBoxFilter.Text.Trim(); e.InputParameters["PortID"] = GlobalCode.Field2String(Session["Port"]); e.InputParameters["VesselID"] = uoDropDownListVessel.SelectedValue; e.InputParameters["Nationality"] = uoDropDownListNationality.SelectedValue; e.InputParameters["Gender"] = uoDropDownListGender.SelectedValue; e.InputParameters["Rank"] = uoDropDownListRank.SelectedValue; e.InputParameters["Role"] = uoHiddenFieldRole.Value; e.InputParameters["ByVessel"] = Int16.Parse(uoHiddenFieldByVessel.Value); e.InputParameters["ByName"] = Int16.Parse(uoHiddenFieldByName.Value); e.InputParameters["ByE1ID"] = Int16.Parse(uoHiddenFieldByE1ID.Value); e.InputParameters["ByDateOnOff"] = Int16.Parse(uoHiddenFieldByDateOnOff.Value); e.InputParameters["ByStatus"] = Int16.Parse(uoHiddenFieldByStatus.Value); e.InputParameters["ByPort"] = Int16.Parse(uoHiddenFieldByPort.Value); e.InputParameters["ByRank"] = Int16.Parse(uoHiddenFieldByRank.Value); e.InputParameters["BranchId"] = GlobalCode.Field2Int(Session["Hotel"]).ToString(); }
/// <summary> /// Date Created: 08/Nov/2012 /// Created By: Josephine Gad /// (description) Page for calendar of room count needed daily /// ------------------------------------------- /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { uoHiddenFieldBranchID.Value = GlobalCode.Field2String(Request.QueryString["bID"]); if (!IsPostBack) { DateTime sDateFrom = new DateTime(); if (GlobalCode.Field2String(Request.QueryString["dt"]) == "") { sDateFrom = GlobalCode.Field2DateTime(Session["DateFrom"]); } else { sDateFrom = GlobalCode.Field2DateTime(Request.QueryString["dt"]); } Session["DateFrom"] = sDateFrom.ToShortDateString(); Session.Remove("CalendarRoomNeeded"); uoCalendarDashboard.SelectedDate = sDateFrom; uoCalendarDashboard.VisibleDate = sDateFrom; GetCaption(); } uoCalendarDashboard.Visible = true; }
/// <summary> /// Date Created: 12/10/2011 /// Created By: Charlene Remotigue /// ------------------------------------------- /// Date Modified: 16/03/2012 /// Modified By: Josephine Gad /// (description) Replace Global Variable with Session /// ------------------------------------------- /// </summary> /// <summary> /// Author: Charlene Remotigue /// Date Created: 07/05/2012 /// Description: initialize session values /// </summary> protected void InitializeValues() { if (GlobalCode.Field2String(Session["UserName"]) == "") { Session["UserName"] = User.Identity.Name; } MembershipUser sUser = Membership.GetUser(GlobalCode.Field2String(Session["UserName"])); if (sUser == null) { Response.Redirect("~/Login.aspx"); } else { if (!sUser.IsOnline) { Response.Redirect("~/Login.aspx"); } } if (GlobalCode.Field2String(Session["UserRole"]) == "") { string UserRolePrimary = UserAccountBLL.GetUserPrimaryRole(GlobalCode.Field2String(Session["UserName"])); Session["UserRole"] = UserRolePrimary; } if (GlobalCode.Field2String(Session["DateFrom"]) == "") { Session["DateFrom"] = GlobalCode.Field2DateTime(Request.QueryString["dt"]).ToString("mm/dd/yyyy"); } Session["strPrevPage"] = Request.RawUrl; }
protected void uoLinkExport_Click(object sender, EventArgs e) { DataSet ds = ManifestBLL.getAllDataFiles(GlobalCode.Field2DateTime(Session["DateFrom"]), GlobalCode.Field2String(Session["UserName"])); string FilePath = Server.MapPath("~/Extract/Manifest/"); string mDate = GlobalCode.Field2DateTime(Session["DateFrom"]).ToString(TravelMartVariable.DateTimeFormatFileExtension); string sDate = DateTime.Now.ToString(TravelMartVariable.DateTimeFormatFileExtension); string FileName = "Manifest_" + mDate + "_" + sDate + ".xls"; ds.Tables[0].TableName = "Same day Arrival Departure"; ds.Tables[1].TableName = "No Travel request"; int count = 2; while (count < ds.Tables.Count) { ds.Tables[count].TableName = ds.Tables[count].Rows[0]["HotelName"].ToString(); count += 1; } string strFileName = FilePath + FileName; if (File.Exists(strFileName)) { File.Delete(strFileName); } Convert(ds, strFileName); OpenExcelFile(FileName); }
/// <summary> /// Date Created: 08/Nov/2012 /// Created By: Josephine Gad /// (description) Get Calendar Room Count using session /// ------------------------------------------- /// </summary> /// <returns></returns> protected List <CalendarRoomNeeded> GetCalendarRoomCount() { List <CalendarRoomNeeded> list = new List <CalendarRoomNeeded>(); try { if (Session["CalendarRoomNeeded"] == null) { list = calendar.GetCalendarRoomNeeded(GlobalCode.Field2String(Session["UserName"]), GlobalCode.Field2DateTime(GlobalCode.Field2String(Session["DateFrom"])), "", GlobalCode.Field2Int(Session["Region"]), GlobalCode.Field2Int(Session["Port"]), GlobalCode.Field2Int(uoHiddenFieldBranchID.Value) ); Session.Remove("CalendarRoomNeeded"); Session["CalendarRoomNeeded"] = list; return(list); } else { list = (List <CalendarRoomNeeded>)Session["CalendarRoomNeeded"]; return(list); } } catch (Exception ex) { throw ex; } }
/// <summary> /// Date Created: 08/07/2011 /// Created By: Marco Abejar /// (description) Get seafarer air travel info /// ---------------------------------------------------------------- /// Date Created: 22/07/2011 /// Modifed By: Josephine Gad /// (description) uogridviewAirTravelInfo to uoListViewAirTravelInfo /// ---------------------------------------------------------------- /// Date Created: 02/08/2011 /// Modifed By: Josephine Gad /// (description) Add parameter seafarer name /// ---------------------------------------------------------------- /// Date Modified: 05/08/2011 /// Modifed By: Josephine Gad /// (description) Add Date Range parameter /// </summary> private void GetSFAirTravelDetails() { DataTable AirDataTable = null; try { //string DateFromString = (uoHiddenFieldDateFrom.Value == "" ? DateTime.Now.ToShortDateString() : uoHiddenFieldDateFrom.Value); //string DateToString = (uoHiddenFieldDateTo.Value == "" ? DateTime.Now.ToShortDateString() : uoHiddenFieldDateTo.Value); //AirDataTable = SeafarerTravelBLL.GetSFAirTravelDetails(strSFStatus, strFlightDateRange, strAirStatusFilter, uoTextBoxName.Text, // DateFromString, DateToString, GlobalCode.Field2String(Session["UserName"]), GlobalCode.Field2String(Session["Region"]), uoHiddenFieldFilterBy.Value); AirDataTable = SeafarerTravelBLL.GetSFAirTravelDetails(GlobalCode.Field2DateTime((uoHiddenFieldDate.Value)).ToString(), uoHiddenFieldDateTo.Value, GlobalCode.Field2String(Session["strAirStatusFilter"]), GlobalCode.Field2String(Session["UserName"]), GlobalCode.Field2String(Session["strPendingFilter"]), GlobalCode.Field2String(Session["Region"]), GlobalCode.Field2String(Session["Country"]), GlobalCode.Field2String(Session["City"]), uoDropDownListStatus.SelectedValue, uoDropDownListFilterBy.SelectedValue, uoTextBoxFilter.Text.Trim(), GlobalCode.Field2String(Session["Port"]), uoDropDownListVessel.SelectedValue, uoDropDownListNationality.SelectedValue, uoDropDownListGender.SelectedValue, uoDropDownListRank.SelectedValue); uoListViewAirTravelInfo.DataSource = AirDataTable; uoListViewAirTravelInfo.DataBind(); } catch (Exception ex) { throw ex; } finally { if (AirDataTable != null) { AirDataTable.Dispose(); } } }
/// <summary> /// Date Created: 30/09/2011 /// Created By: Josephine Gad /// (description) Get vessel list /// --------------------------------------------------------------------------- /// </summary> private void GetVessel() { DataTable VesselDataTable = null; try { string UserName = GlobalCode.Field2String(Session["UserName"]); string UserRole = GlobalCode.Field2String(Session["UserRole"]); if (UserRole == "") { UserRole = UserAccountBLL.GetUserPrimaryRole(UserName); } VesselDataTable = VesselBLL.GetVessel(UserName, GlobalCode.Field2DateTime((uoHiddenFieldDate.Value)).ToString(), uoHiddenFieldDateTo.Value, GlobalCode.Field2String(Session["Region"]), GlobalCode.Field2String(Session["Country"]), GlobalCode.Field2String(Session["City"]), GlobalCode.Field2String(Session["Port"]), UserRole); uoDropDownListVessel.Items.Clear(); ListItem item = new ListItem("--Select Vessel--", "0"); uoDropDownListVessel.Items.Add(item); uoDropDownListVessel.DataSource = VesselDataTable; uoDropDownListVessel.DataTextField = "VesselName"; uoDropDownListVessel.DataValueField = "VesselID"; uoDropDownListVessel.DataBind(); } catch (Exception ex) { throw ex; } finally { if (VesselDataTable != null) { VesselDataTable.Dispose(); } } }
/// <summary> /// Author: Josephine Gad /// Date Created: 01/10/2012 /// Description: Get records removed from Exception List /// </summary> /// <returns></returns> private List <OverflowBooking2> GetHotelOverflowList() { try { List <OverflowBooking2> list = new List <OverflowBooking2>(); int iRegionID = GlobalCode.Field2Int(Session["Region"]); int iPortID = GlobalCode.Field2Int(Session["Port"]); if (Session["HotelOverflowBookingsRemovedList"] != null) { list = (List <OverflowBooking2>)Session["HotelOverflowBookingsRemovedList"]; } else { list = OverFlowBookingBLL.OverflowGetRemovedList(GlobalCode.Field2DateTime(Session["DateFrom"]), GlobalCode.Field2String(Session["UserName"]), 0, iRegionID, iPortID); Session["HotelOverflowBookingsRemovedList"] = list; } return(list); } catch (Exception ex) { throw ex; } }
private void LoadTravelDetails() { Session["Hotel"] = uoDropDownListHotel.SelectedValue; Session["HotelNameToSearch"] = uoDropDownListHotel.SelectedItem.Text; //if (uoDropDownListHotel.SelectedValue == "0") //{ // uoBtnExportList.Enabled = false; //} //else //{ // uoBtnExportList.Enabled = true; //} if (uoDropDownListHotel.SelectedValue == "-1") { uoDropDownListPortPerRegion.SelectedValue = "0"; Session["Port"] = "0"; uoDropDownListPortPerRegion.Enabled = false; } else { uoDropDownListPortPerRegion.Enabled = true; } uoHiddenFieldDate.Value = GlobalCode.Field2DateTime(Session["DateFrom"]).ToString("MM/dd/yyyy"); DateTime dDateCurrent = DateTime.Parse(DateTime.Now.ToString("MM/dd/yyyy")); DateTime dDateFrom = GlobalCode.Field2DateTime((uoHiddenFieldDate.Value)); //TimeSpan timeDiff = dDateFrom - dDateCurrent; //int dDays = timeDiff.Days; GetSFHotelTravelDetails(); //Session.Remove("TentativeManifestCalendarDashboard"); }
/// <summary> /// Author: Josephine Gad /// Created Date: 09/Jan/2013 /// Description: Create File for Export /// ============================================ /// Author: Marco Abejar Gad /// Created Date: 26/April/2013 /// Description: Added columns and include aie legs /// ============================================ /// Modified By: Josephine Gad /// CModified Date: 02/Sep/2013 /// Description: Change filename to Crew Admin Manifest + date of manifest + date extracted /// </summary> /// <param name="dt"></param> protected void CreateFile(DataTable dt) { try { string strFileName = ""; string FilePath = Server.MapPath("~/Extract/CrewAdmin/"); string sDateNow = DateTime.Now.ToString(TravelMartVariable.DateTimeFormatFileExtension); string sDate = GlobalCode.Field2DateTime(uoHiddenFieldDate.Value).ToString("MMMddyyy"); string FileName = "CrewAdminManifest_" + sDate + "_" + sDateNow + ".xls"; strFileName = FilePath + FileName; if (File.Exists(strFileName)) { File.Delete(strFileName); } string[] sVesselArr = uoDropDownListVessel.SelectedItem.Text.Split("-".ToCharArray()); CreateExcel(dt, strFileName, sVesselArr[0].ToString().TrimEnd()); OpenExcelFile(FileName, strFileName); } catch (Exception ex) { throw ex; } finally { if (dt != null) { dt.Dispose(); } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["UserName"] == null || GlobalCode.Field2String(Session["UserName"]) == "") { Response.Redirect("Login.aspx"); } Session["strPrevPage"] = Request.RawUrl; if (!IsPostBack) { uoHiddenFieldUser.Value = GlobalCode.Field2String(Session["UserName"]); uoHiddenFieldRole.Value = GlobalCode.Field2String(Session["UserRole"]); uoHiddenFieldDate.Value = Request.QueryString["dt"].ToString(); uoHiddenFieldDate.Value = uoHiddenFieldDate.Value.Replace("_", "/"); string sChangeDate = ""; if (Request.QueryString["chDate"] != null) { sChangeDate = Request.QueryString["chDate"]; } if (sChangeDate == "1") { uoHiddenFieldPortAgentID.Value = GlobalCode.Field2Int(Session["PortAgentID"]).ToString(); } else { uoHiddenFieldPortAgentID.Value = GlobalCode.Field2Int(Request.QueryString["pid"]).ToString(); Session["PortAgentID"] = uoHiddenFieldPortAgentID.Value; } BindPortAgent(); BindNoOfDays(); BindVehicleManifest(0); BindStatus(); } else { string sChangeDate = ""; if (Request.QueryString["chDate"] != null) { sChangeDate = Request.QueryString["chDate"]; } HiddenField uoHiddenFieldPopupCalendar = (HiddenField)Master.FindControl("uoHiddenFieldPopupCalendar"); if (uoHiddenFieldPopupCalendar.Value == "1" || (sChangeDate == "1")) { uoHiddenFieldDate.Value = GlobalCode.Field2DateTime(Session["DateFrom"]).ToString("MM/dd/yyyy"); BindVehicleManifest(0); } } uoListViewVehicleHeader.DataSource = null; uoListViewVehicleHeader.DataBind(); if (uoHiddenFieldVehicleConfirm.Value == "1") { BindVehicleManifest(1); uoHiddenFieldVehicleConfirm.Value = "0"; } }
protected void Page_Load(object sender, EventArgs e) { //uoTextNites.Text = uoHiddenFieldNoOfNites.Value; if (!IsPostBack) { uoHiddenFieldHotelRequestID.Value = Request.QueryString["hrID"].ToString(); uoHiddenFieldTravelRequestID.Value = Request.QueryString["trID"].ToString(); uoHiddenFieldHotelRequestApp.Value = Request.QueryString["App"].ToString(); uoHiddenFieldUser.Value = GlobalCode.Field2String(Session["UserName"]); if (GlobalCode.Field2String(Request.QueryString["dt"]) != "") { uoHiddenFieldDate.Value = Request.QueryString["dt"].ToString(); uoHiddenFieldDate.Value = uoHiddenFieldDate.Value.Replace("_", "/"); } else { uoHiddenFieldDate.Value = GlobalCode.Field2DateTime(Session["DateFrom"]).ToShortDateString(); } //LoadDefaults(0); GetGender(); GetVessel(); GetRank(); GetCurrency(); GetSFInfo(); if (uoHiddenFieldHotelRequestID.Value != "0" && uoHiddenFieldHotelRequestID.Value != "") { GetSFCompanion(); } if (uoDropDownListHotel.SelectedIndex > 0) { GetHotelRoomAmount(); } tblConfirm.Visible = (uoHiddenFieldHotelRequestApp.Value == "2") ? true : false; } //fire room availability check //if (Request["__EVENTARGUMENT"] == "uoTextBoxCheckinDate_TextChanged") //{ // BindRoom(); //} uoCheckBoxAddCompanion.Enabled = (uoHiddenFieldHotelRequestID.Value != "0" && uoHiddenFieldHotelRequestID.Value != ""); //only show to authorized approver uoListViewCompanion.DataSource = null; uoListViewCompanion.DataBind(); //if crew exist if (uoTextBoxRequestNo.Text.Length > 0) { divSFNotExist.Visible = false; divSFExist.Visible = true; } else { divSFNotExist.Visible = true; divSFExist.Visible = false; } }
void GetPortAgentHotelVehicle() { GetPortAgentHotelVehicle(0, uoHiddenFieldPortCode.Value , GlobalCode.Field2Int(uoDropDownListSeaport.SelectedValue) , GlobalCode.Field2Int(uoDropDownListPortAgent.SelectedValue) , GlobalCode.Field2DateTime(uoHiddenFieldRequestDate.Value) , GlobalCode.Field2Int(uoDropDownListDays.SelectedValue)); }
/// <summary> /// Author: Josephine Gad /// Date Created: 07/Dec/2012 /// Descrption: Get Active Exception List (active in PNR but X in Travel Routing) and store in session /// </summary> public static void GetActiveExceptionList(Int16 iFilterBy, string sFilter, string sRecordLocator, int iSequenceNo, int StartRow, int MaxRow) { Database db = ConnectionSetting.GetConnection(); // DatabaseFactory.CreateDatabase(); DbCommand comm = null; DataSet ds = null; List <ActiveExceptionList> list = new List <ActiveExceptionList>(); try { HttpContext.Current.Session["ActiveExceptionList"] = list; HttpContext.Current.Session["ActiveExceptionCount"] = 0; comm = db.GetStoredProcCommand("uspSelectExceptionTravelRouting"); db.AddInParameter(comm, "@pFilterBy", DbType.Int16, iFilterBy); db.AddInParameter(comm, "@pFilterVarchar", DbType.String, sFilter); db.AddInParameter(comm, "@pRecordLocator", DbType.String, sRecordLocator); db.AddInParameter(comm, "@pItinerarySequence", DbType.Int32, iSequenceNo); db.AddInParameter(comm, "@pStartRow", DbType.Int32, StartRow); db.AddInParameter(comm, "@pMaxRow", DbType.Int32, MaxRow); ds = db.ExecuteDataSet(comm); int iCount = GlobalCode.Field2Int(ds.Tables[0].Rows[0][0]); list = (from a in ds.Tables[1].AsEnumerable() select new ActiveExceptionList { RecordLocator = a["colRecordLocatorVarchar"].ToString(), SequenceNo = GlobalCode.Field2Int(a["colItinerarySeqNoSmallint"]), Name = a["Name"].ToString(), E1No = GlobalCode.Field2Int(a["colSeafarerIdInt"]), E1TRNo = GlobalCode.Field2Int(a["colE1TravelReqIdInt"]), Status = a["colStatusVarchar"].ToString(), OnOffDate = GlobalCode.Field2DateTime(a["DateOnOff"]) }).ToList(); HttpContext.Current.Session["ActiveExceptionList"] = list; HttpContext.Current.Session["ActiveExceptionCount"] = iCount; } catch (Exception ex) { throw ex; } finally { if (comm != null) { comm.Dispose(); } if (ds != null) { ds.Dispose(); } } }
/// <summary> /// Date Created: 28/09/2011 /// Created By: Josephine Gad /// (description) Get Manifest List /// --------------------------------------------------------------------------- /// </summary> private void GetRequest() { DataTable dt = null; DataView dv = null; try { string sDateTo = GlobalCode.Field2String(Session["DateTo"]); if (sDateTo == "") { sDateTo = GlobalCode.Field2DateTime(uoHiddenFieldDate.Value).AddDays(double.Parse(uoHiddenFieldDateRange.Value)).ToString("MM/dd/yyyy"); } dt = RequestBLL.GetRequest(uoHiddenFieldDate.Value, sDateTo, uoHiddenFieldUser.Value, GlobalCode.Field2String(Session["Region"]), GlobalCode.Field2String(Session["Country"]), GlobalCode.Field2String(Session["City"]), uoDropDownListStatus.SelectedValue, uoDropDownListFilterBy.SelectedValue, uoTextBoxFilter.Text.Trim(), GlobalCode.Field2String(Session["Port"]), GlobalCode.Field2String(Session["Hotel"]), GlobalCode.Field2String(Session["Vehicle"]), uoDropDownListVessel.SelectedValue, uoDropDownListNationality.SelectedValue, uoDropDownListGender.SelectedValue, uoDropDownListRank.SelectedValue, "", uoHiddenFieldRole.Value); dv = dt.DefaultView; dv.Sort = uoDropDownListGroupBy.SelectedValue + ", Name "; uoListViewRequest.DataSource = dv; uoListViewRequest.DataBind(); HtmlControl VesselHeader = (HtmlControl)uoListViewRequest.FindControl("ucTHVessel"); HtmlControl HotelHeader = (HtmlControl)uoListViewRequest.FindControl("ucTHHotel"); if (VesselHeader != null) { if (uoDropDownListGroupBy.SelectedValue == "VesselName") { VesselHeader.Visible = false; HotelHeader.Visible = true; } else if (uoDropDownListGroupBy.SelectedValue == "HotelName") { VesselHeader.Visible = true; HotelHeader.Visible = false; } } } catch (Exception ex) { throw ex; } finally { if (dt != null) { dt.Dispose(); } if (dv != null) { dv.Dispose(); } } }
/// <summary> /// Author: Josephine Gad /// Date Created: 04/Dec/2012 /// Descrption: Get XML Exception and store in session /// </summary> /// <param name="sUserName"></param> /// <param name="sRole"></param> /// <param name="DateFrom"></param> /// <param name="DateTo"></param> /// <param name="sRecordLocator"></param> /// <param name="iSequenceNo"></param> /// <param name="StartRow"></param> /// <param name="MaxRow"></param> public static void GetXMLExceptionList(string sUserName, string sRole, string DateFrom, string DateTo, string sRecordLocator, int iSequenceNo, int StartRow, int MaxRow) { Database db = ConnectionSetting.GetConnection(); // DatabaseFactory.CreateDatabase(); DbCommand comm = null; DataSet ds = null; List <XMLExceptionList> list = new List <XMLExceptionList>(); try { HttpContext.Current.Session["XMLExceptionList"] = list; HttpContext.Current.Session["XMLExceptionCount"] = 0; comm = db.GetStoredProcCommand("uspSelectExceptionXML"); db.AddInParameter(comm, "@pUserIDVarchar", DbType.String, sUserName); db.AddInParameter(comm, "@pUserRoleVarchar", DbType.String, sRole); db.AddInParameter(comm, "@pDateFrom", DbType.DateTime, GlobalCode.Field2DateTime(DateFrom)); if (DateTo.Trim() != "") { db.AddInParameter(comm, "@pDateTo", DbType.DateTime, GlobalCode.Field2DateTime(DateTo)); } db.AddInParameter(comm, "@pRecordLocator", DbType.String, sRecordLocator); db.AddInParameter(comm, "@pItinerarySequence", DbType.Int32, iSequenceNo); db.AddInParameter(comm, "@pStartRow", DbType.Int32, StartRow); db.AddInParameter(comm, "@pMaxRow", DbType.Int32, MaxRow); ds = db.ExecuteDataSet(comm); int iCount = GlobalCode.Field2Int(ds.Tables[0].Rows[0][0]); list = (from a in ds.Tables[1].AsEnumerable() select new XMLExceptionList { ExceptionID = GlobalCode.Field2Int(a["ExceptionIDBigint"]), RecordLocator = a["FK_ItineraryRefID"].ToString(), SequenceNo = GlobalCode.Field2Int(a["FK_ItinerarySeqNmbr"]), Description = a["Description"].ToString(), DateCreated = GlobalCode.Field2DateTime(a["DateCreatedDatetime"]) }).ToList(); HttpContext.Current.Session["XMLExceptionList"] = list; HttpContext.Current.Session["XMLExceptionCount"] = iCount; } catch (Exception ex) { throw ex; } finally { if (comm != null) { comm.Dispose(); } if (ds != null) { ds.Dispose(); } } }
protected void uoObjectDataSourceAuditTrail_Selecting(object sender, ObjectDataSourceSelectingEventArgs e) { CultureInfo enCulture = new CultureInfo(TravelMartVariable.UserCultureInfo); //e.InputParameters["DateFrom"] = DateTime.ParseExact(GlobalCode.Field2DateTime((uoHiddenFieldDate.Value)).ToString(), TravelMartVariable.DateFormat, enCulture); e.InputParameters["DateFrom"] = GlobalCode.Field2DateTime((uoHiddenFieldDate.Value)).ToString(); //e.InputParameters["DateTo"] = DateTime.ParseExact(GlobalCode.Field2DateTime((uoHiddenFieldDate.Value)).ToString(), TravelMartVariable.DateFormat, enCulture); e.InputParameters["DateTo"] = GlobalCode.Field2DateTime((uoHiddenFieldDate.Value)).ToString(); }
public void OnEndExceptions(IAsyncResult ar) { _PortAgentDeligate.EndInvoke(ar); GetPortAgentHotelVehicle(0, uoHiddenFieldPortCode.Value , GlobalCode.Field2Int(uoDropDownListSeaport.SelectedValue) , GlobalCode.Field2Int(uoDropDownListPortAgent.SelectedValue) , GlobalCode.Field2DateTime(uoHiddenFieldRequestDate.Value) , GlobalCode.Field2Int(uoDropDownListDays.SelectedValue)); }
/// <summary> /// Author: Josephine Monteza /// Date Created: 8/May/2015 /// Description: Bind Days /// </summary> private void BindDayTo() { if (Session["NoOfDays_Forecast"] != null) { int i = GlobalCode.Field2Int(Session["NoOfDays_Forecast"]); uoHiddenFieldTo.Value = GlobalCode.Field2DateTime( uoHiddenFieldFrom.Value).AddDays(i).ToString(); } }
protected void uoCheckBoxShowAll_CheckedChanged(object sender, EventArgs e) { Session["NoOfDays_Forecast_Vendor"] = uoDropDownListDays.SelectedValue; uoHiddenFieldNoOfDays.Value = uoDropDownListDays.SelectedValue; uoHiddenFieldTo.Value = GlobalCode.Field2DateTime( uoHiddenFieldFrom.Value).AddDays(GlobalCode.Field2Int(uoDropDownListDays.SelectedValue)).ToString(); uoHiddenFieldLoadType.Value = "1"; GetSFHotelTravelDetails(); }
private void GetDashboardDetails() { DataView dv = null; DataTable dt = DashboardBLL.GetDashboardDetails(GlobalCode.Field2DateTime((GlobalCode.Field2String(Session["DateFrom"]))).ToString(), GlobalCode.Field2String(Session["DateTo"]), GlobalCode.Field2String(Session["Port"])); dv = dt.DefaultView; dv.Sort = uoDropDownListGroup.SelectedValue; uoListViewDashboard.DataSource = dv; uoListViewDashboard.DataBind(); }
public void OnEnd(IAsyncResult ar) { DriverGreeterVehHotelServProv lst = new DriverGreeterVehHotelServProv(); _dlgtAssign.EndInvoke(ar); lst = DriverGreeterVehHotelServProv(GlobalCode.Field2Int(uoHiddenFieldVendorID.Value), GlobalCode.Field2String(uoHiddenFieldcmfid.Value)); uoDropDownListDriver.Items.Clear(); uoDropDownListDriver.Items.Add(new ListItem("--Select Driver--", "0")); uoDropDownListDriver.DataSource = lst.Driver; uoDropDownListDriver.DataValueField = "ID"; uoDropDownListDriver.DataTextField = "FullName"; uoDropDownListDriver.DataBind(); uoDropDownListGreeter.Items.Clear(); uoDropDownListGreeter.Items.Add(new ListItem("--Select Greeter--", "0")); uoDropDownListGreeter.DataSource = lst.Greeter; uoDropDownListGreeter.DataValueField = "ID"; uoDropDownListGreeter.DataTextField = "FullName"; uoDropDownListGreeter.DataBind(); uoListviewVehicle.DataSource = null; uoListviewVehicle.DataBind(); uoListviewVehicle.DataSource = lst.VehHotelSerProv; uoListviewVehicle.DataBind(); uoListViewManifestConfirm.DataSource = null; uoListViewManifestConfirm.DataBind(); uoListViewManifestConfirm.DataSource = lst.VehicleManifestList; uoListViewManifestConfirm.DataBind(); if (lst.VehicleManifestList.Count > 0) { var l = lst.VehicleManifestList[0]; uoTextBoxPickupDate.Text = GlobalCode.Field2String(l.PickupDate); uoTextBoxPickupTime.Text = GlobalCode.Field2DateTime(l.PickupTime.ToString()).Hour.ToString() + ":" + GlobalCode.Field2Time(l.PickupTime.ToString()).Minute.ToString(); uoTextBoxPickupLocation.Text = GlobalCode.Field2String(l.PickupLocation); uoTextBoxDropupLocation.Text = GlobalCode.Field2String(l.DropOffLocation); uoTextBoxGreeterPickupDate.Text = GlobalCode.Field2String(l.PickupDate); uoTextBoxGreeterPickupTime.Text = GlobalCode.Field2DateTime(l.PickupTime.ToString()).Hour.ToString() + ":" + GlobalCode.Field2Time(l.PickupTime.ToString()).Minute.ToString(); uoTextBoxGreeterLocation.Text = GlobalCode.Field2String(l.PickupLocation); uoTextBoxGreeterDropLocation.Text = GlobalCode.Field2String(l.DropOffLocation); } }
/// <summary> /// Date Modified: 19/03/2012 /// Modified By: Josephine Gad /// (description) Change DataTable to List /// ------------------------------------------- /// Date Modified: 15/09/2012 /// Modified By: Josephine Gad /// (description) Add parameter RegionID, PortID, sPage /// ------------------------------------------- /// </summary> /// <param name="UserId"></param> /// <param name="Date"></param> /// <returns></returns> public List <ManifestOnOffCalendar> LoadOnOffCalendar(string UserId, DateTime Date, Int32 RegionID, Int32 PortID, Int32 VesselID, Int32 HotelID, string sPage, Int16 TypeView) { Database db = ConnectionSetting.GetConnection(); // DatabaseFactory.CreateDatabase(); DbCommand dbCommand = null; DataTable Calendar = null; try { dbCommand = db.GetStoredProcCommand("uspGetOnOffCalendar"); db.AddInParameter(dbCommand, "@pUserId", DbType.String, UserId); db.AddInParameter(dbCommand, "@pDate", DbType.DateTime, Date); db.AddInParameter(dbCommand, "@pRegionID", DbType.Int32, RegionID); db.AddInParameter(dbCommand, "@pPortID", DbType.Int32, PortID); db.AddInParameter(dbCommand, "@pVesselID", DbType.Int32, VesselID); db.AddInParameter(dbCommand, "@pHotelID", DbType.Int32, HotelID); db.AddInParameter(dbCommand, "@pPage", DbType.String, sPage); db.AddInParameter(dbCommand, "@pTypeView", DbType.Int16, TypeView); Calendar = db.ExecuteDataSet(dbCommand).Tables[0]; List <ManifestOnOffCalendar> list = new List <ManifestOnOffCalendar>(); list = (from a in Calendar.AsEnumerable() select new ManifestOnOffCalendar { colDate = GlobalCode.Field2DateTime(a["colDate"]), ONCount = GlobalCode.Field2Int(a["ONCount"]), OffCount = GlobalCode.Field2Int(a["OffCount"]), sDate = GlobalCode.Field2String(a["sDate"]) }).ToList(); return(list); } catch (Exception ex) { throw ex; } finally { if (dbCommand != null) { dbCommand.Dispose(); } if (Calendar != null) { Calendar.Dispose(); } } }
private void GetPortNotInTM() { List <NonTurnPortsList> list = new List <NonTurnPortsList>(); AnalystExceptionBLL.GetNonTurnPortNotInTM(GlobalCode.Field2DateTime(uoHiddenFieldDate.Value), uoHiddenFieldUser.Value, GlobalCode.Field2String(Session["Port"]), uoHiddenFieldSortBy.Value); list = (List <NonTurnPortsList>)Session["PortNotExistExceptionList"]; uoListViewNonTurnPort.DataSource = list; uoListViewNonTurnPort.DataBind(); }
protected void uolistviewHotelInfo_DataBound(object sender, EventArgs e) { ButtonLockSettings(); if (uoHiddenFieldLoadType.Value == "0") { DateTime dDateFrom = GlobalCode.Field2DateTime((uoHiddenFieldDate.Value)); uoTextBoxFrom.Text = dDateFrom.ToString(TravelMartVariable.DateFormat); uoTextBoxTo.Text = dDateFrom.AddDays(TMSettings.NoOfDaysForecast).ToString(TravelMartVariable.DateFormat); } }
protected void uoVendorDropDownType_Click(object sender, EventArgs e) { DataTable dt = null; try { DropDownList dd = (DropDownList)sender; if (dd.ID == "uoDropDownListRequestSource") { return; } uoTextBoxHotelname.Text = ""; uoTextBoxEmailAdd.Text = ""; uoTextBoxRateContract.Text = ""; uoTextBoxRateConfirmed.Text = ""; uoTextBoxCheckInDate.Text = ""; uoDropDownListCurrency.SelectedIndex = 0; uoHiddenFieldContractID.Value = ""; uoHiddenFieldVoucher.Value = ""; DropDownList ddl = (DropDownList)sender; if (ViewState["PortAgenRequestVendor"] != null) { List <PortAgenRequestVendor> ls = (List <PortAgenRequestVendor>)ViewState["PortAgenRequestVendor"]; var lst = ls.Where(n => n.VendorID == GlobalCode.Field2Int(ddl.SelectedItem.Value)).ToList(); if (lst.Count > 0) { DropDownList cbo = (DropDownList)sender; uoTextBoxHotelname.Text = cbo.SelectedItem.Text; uoTextBoxEmailAdd.Text = lst[0].EmailTo; uoTextBoxRateContract.Text = lst[0].DoubleRate.ToString(); uoTextBoxRateConfirmed.Text = lst[0].DoubleRate.ToString(); uoTextBoxCheckInDate.Text = GlobalCode.Field2DateTime(Request.QueryString["dt"]).ToString(); uoDropDownListCurrency.SelectedIndex = GlobalCode.GetselectedIndex(uoDropDownListCurrency, lst[0].CurrentID); uoHiddenFieldContractID.Value = lst[0].VendorContractID.ToString(); uoHiddenFieldVoucher.Value = lst[0].Voucher.ToString(); } } } catch (Exception ex) { throw ex; } finally { if (dt != null) { dt.Dispose(); } } }
/// <summary> /// Author: Charlene Remotigue /// Date Created: 15/11/2011 /// ======================================================== /// Date Modified: 16/03/2012 /// Modified By: Muhallidin G Wali /// (description) Replace Global Variable with Session /// ======================================================== /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Session["strPrevPage"] = Request.RawUrl; uoHiddenFieldEndDate.Value = GlobalCode.Field2String(Session["DateTo"]); uoHiddenFieldStartDate.Value = GlobalCode.Field2DateTime(GlobalCode.Field2String(Session["DateFrom"])).ToString(); uoHiddenFieldPortAgentId.Value = Session["UserBranchID"].ToString(); LoadVehicleBrand(); LoadDashboardDetails(); //UpdatePanelVehicle.Update(); } }