private void InsertDriverTransaction() { try { VehicleManifestBLL BLL = new VehicleManifestBLL(); DriverTransaction d = new DriverTransaction(); DataTable dtparam = DriverTransaction(); DataTable gtparam = GreeterTransaction(); DataRow dr; HiddenField ConfirmedManifestID; HiddenField DriverRequestID; HiddenField uodfDriverPickupLatitude; HiddenField uodfDriverPickupLongitude; HiddenField uodfDriverDropOffLatitude; HiddenField uodfDriverDropOffLongitude; HiddenField uodfDriverParkingLatitude; HiddenField uodfDriverParkingLongitude; Label Pickupdate; TextBox PickupTime; TextBox PickupLocation; TextBox DropOffLocation; foreach (ListViewDataItem list in uoListViewManifestConfirm.Items) { ConfirmedManifestID = (HiddenField)list.FindControl("uoHiddenFieldConfirmedManifestID"); DriverRequestID = (HiddenField)list.FindControl("uoHiddenFieldDriverRequestID"); uodfDriverPickupLatitude = (HiddenField)list.FindControl("uodfDriverPickupLatitude"); uodfDriverPickupLongitude = (HiddenField)list.FindControl("uodfDriverPickupLongitude"); uodfDriverDropOffLatitude = (HiddenField)list.FindControl("uodfDriverDropOffLatitude"); uodfDriverDropOffLongitude = (HiddenField)list.FindControl("uodfDriverDropOffLongitude"); uodfDriverParkingLatitude = (HiddenField)list.FindControl("uodfDriverParkingLatitude"); uodfDriverParkingLongitude = (HiddenField)list.FindControl("uodfDriverParkingLongitude"); Pickupdate = (Label)list.FindControl("lblPickupDate"); PickupTime = (TextBox)list.FindControl("txtPickupTime"); PickupLocation = (TextBox)list.FindControl("txtPickupLocation"); DropOffLocation = (TextBox)list.FindControl("txtDropOffLocation"); if (GlobalCode.Field2Int(uoDropDownListDriver.SelectedIndex) > 0) { dr = dtparam.NewRow(); dr["DriverRequestID"] = GlobalCode.Field2Long(DriverRequestID.Value); dr["UserID"] = uoDropDownListDriver.SelectedItem.Value; dr["PickupDate"] = GlobalCode.Field2DateTime(Pickupdate.Text); dr["PickupTime"] = GlobalCode.Field2DateTime(PickupTime.Text); dr["ParkingLocation"] = GlobalCode.Field2String(uoTextBoxPakingLocation.Text); dr["ParkingLatitude"] = GlobalCode.Field2Double(uodfDriverParkingLatitude.Value); dr["ParkingLongitude"] = GlobalCode.Field2Double(uodfDriverParkingLongitude.Value); dr["PickupLocation"] = GlobalCode.Field2String(PickupLocation.Text); dr["PickupLatitude"] = GlobalCode.Field2Double(uodfDriverPickupLatitude.Value); dr["PickupLongitude"] = GlobalCode.Field2Double(uodfDriverPickupLongitude.Value); dr["DropOffLocation"] = GlobalCode.Field2String(DropOffLocation.Text); dr["DropOffLatitude"] = GlobalCode.Field2Double(uodfDriverDropOffLatitude.Value); dr["DropOffLongitude"] = GlobalCode.Field2Double(uodfDriverParkingLongitude); dr["VehicleDetailID"] = GlobalCode.Field2Int(uoHiddenFieldVehicleHotelSPID.Value); dr["ConfirmedManifestID"] = GlobalCode.Field2Long(ConfirmedManifestID.Value); dtparam.Rows.Add(dr); } if (GlobalCode.Field2Int(uoDropDownListGreeter.SelectedIndex) > 0) { dr = gtparam.NewRow(); dr["GreeterRequestID"] = GlobalCode.Field2Long(DriverRequestID.Value); dr["UserID"] = uoDropDownListGreeter.SelectedItem.Value; dr["PickupDate"] = GlobalCode.Field2DateTime(Pickupdate.Text); dr["PickupTime"] = GlobalCode.Field2DateTime(PickupTime.Text); dr["PickupLocation"] = GlobalCode.Field2String(PickupLocation.Text); dr["PickupLatitude"] = GlobalCode.Field2Double(uodfGreeterPickupLatitude.Value); dr["PickupLongitude"] = GlobalCode.Field2Double(uodfGreeterPickupLongitude.Value); dr["DropOffLocation"] = GlobalCode.Field2String(DropOffLocation.Text); dr["DropOffLatitude"] = GlobalCode.Field2Double(uodfGreeterDropOffLatitude.Value); dr["DropOffLongitude"] = GlobalCode.Field2Double(uodfGreterDropOffLongitude.Value); dr["ConfirmedManifestID"] = GlobalCode.Field2Long(ConfirmedManifestID.Value); gtparam.Rows.Add(dr); } } BLL.SaveDriverTransaction(GlobalCode.Field2Int(uoHiddenFieldVendorID.Value), uoHiddenFieldsUserID.Value, uoHiddenFieldcmfid.Value, dtparam, gtparam); OpenParentPage("Created successfully."); } catch (Exception ex) { throw ex; } }
/// ---------------------------------------------- /// Modified By: Marco Abejar /// Date Modified: 26/03/2013 /// Description: Get seafarer's info /// ---------------------------------------------- /// Modified By: Josephine Gad /// Date Modified: 30/May/2013 /// Description: Add Shuttle, LunchDinner, and Tax /// ---------------------------------------------- /// </summary> private void GetSFInfo() { IDataReader dtSFInfo = null; try { dtSFInfo = GetSfInfoDataTable(); if (dtSFInfo.Read()) { ClearDropdown(); uoHiddenFieldHotelRequestID.Value = dtSFInfo["RequestId"].ToString(); uoHiddenFieldSFStatus.Value = dtSFInfo["STATUS"].ToString(); uoTextBoxE1ID.Text = dtSFInfo["colSeafarerIdInt"].ToString(); uoTextBoxRequestNo.Text = dtSFInfo["RequestNo"].ToString(); uoTextBoxLastname.Text = dtSFInfo["Lastname"].ToString(); uoTextBoxFirstname.Text = dtSFInfo["Firstname"].ToString(); string st = dtSFInfo["Gender"].ToString(); if (dtSFInfo["Gender"].ToString().Length > 0) { uoDropDownListGender.Items.FindByValue(dtSFInfo["Gender"].ToString()).Selected = true; } if (dtSFInfo["Vessel"].ToString().Length > 0) { uoDropDownListVessel.SelectedIndex = -1; uoDropDownListVessel.Items.FindByValue(dtSFInfo["Vessel"].ToString()).Selected = true; } if (dtSFInfo["Rank"].ToString().Length > 0) { uoDropDownListRank.Items.FindByValue(dtSFInfo["Rank"].ToString()).Selected = true; GetCostCenter(); } uoTextBoxCostCenter.Text = dtSFInfo["CostCenter"].ToString(); uoTextBoxCheckinDate.Text = dtSFInfo["Checkin"].ToString(); uoTextBoxCheckoutDate.Text = dtSFInfo["Checkout"].ToString(); uoCheckboxBreakfast.Checked = Convert.ToBoolean(dtSFInfo["Breakfast"].ToString()); uoCheckboxLunch.Checked = Convert.ToBoolean(dtSFInfo["Lunch"].ToString()); uoCheckboxDinner.Checked = Convert.ToBoolean(dtSFInfo["Dinner"].ToString()); uoCheckBoxLunchDinner.Checked = GlobalCode.Field2Bool(dtSFInfo["LUNCHDINNER"]); uoCheckBoxIsWithShuttle.Checked = GlobalCode.Field2Bool(dtSFInfo["SHUTTLE"]); uoTextNites.Text = dtSFInfo["Nites"].ToString(); uoHiddenFieldNoOfNites.Value = uoTextNites.Text; uoTextBoxRemarks.Text = dtSFInfo["Comment"].ToString(); if (dtSFInfo["CheckInTime"] != null && dtSFInfo["CheckInTime"].ToString() != "") { DateTime CheckInTime = DateTime.Parse(dtSFInfo["CheckInTime"].ToString()); string CInTime = String.Format("{0:HH:mm}", CheckInTime); uoTxtBoxTimeIn.Text = CInTime; } if (dtSFInfo["CheckOutTime"] != null && dtSFInfo["CheckOutTime"].ToString() != "") { DateTime CheckOutTime = DateTime.Parse(dtSFInfo["CheckOutTime"].ToString()); string COutTime = String.Format("{0:HH:mm}", CheckOutTime); uoTxtBoxTimeOut.Text = COutTime; } if (dtSFInfo["RoomAmount"] != null && dtSFInfo["RoomAmount"].ToString() != "") { Decimal fAmount = GlobalCode.Field2Decimal(dtSFInfo["RoomAmount"]); uoTextBoxAmount.Text = fAmount.ToString("0.00"); } uoHiddenFieldRoomAmount.Value = dtSFInfo["RoomAmount"].ToString(); uoTextBoxTaxPercent.Text = GlobalCode.Field2Double(dtSFInfo["colRoomRateTaxPercentage"]).ToString(); uoCheckContractBoxTaxInclusive.Checked = GlobalCode.Field2Bool(dtSFInfo["colRoomRateTaxInclusive"].ToString()); if (dtSFInfo["Currency"].ToString().Length > 0) { uoDropDownListCurrency.SelectedIndex = -1; uoDropDownListCurrency.Items.FindByValue(dtSFInfo["Currency"].ToString()).Selected = true; } BindRegionList(); if (dtSFInfo["Region"].ToString().Length > 0) { uoDropDownListRegion.SelectedIndex = -1; uoDropDownListRegion.Items.FindByValue(dtSFInfo["Region"].ToString()).Selected = true; } BindPortList(); if (dtSFInfo["Port"].ToString().Length > 0 && dtSFInfo["Region"].ToString().Length > 0) { if (uoDropDownListPort.Items.FindByValue(dtSFInfo["Port"].ToString()) != null) { uoDropDownListPort.SelectedValue = dtSFInfo["Port"].ToString(); } } GetAirport(); if (dtSFInfo["AIRPORT"].ToString().Length > 0 && dtSFInfo["Region"].ToString().Length > 0) { if (uoDropDownListAirport.Items.FindByValue(dtSFInfo["AIRPORT"].ToString()) != null) { uoDropDownListAirport.SelectedValue = dtSFInfo["AIRPORT"].ToString(); } } GetHotelFilter(); if (dtSFInfo["Hotel"].ToString() != "0") { //uoDropDownListHotel.SelectedIndex = -1; //GetHotelFilter(); if (uoDropDownListHotel.Items.FindByValue(dtSFInfo["Hotel"].ToString()) != null) { uoDropDownListHotel.SelectedValue = dtSFInfo["Hotel"].ToString(); } uoLabelMessage.Visible = false; } else { uoLabelMessage.Visible = true; } if (dtSFInfo["RoomType"].ToString().Length > 0) { //BindRoom(); uoDropdownRoomOccupancy.Items.FindByValue(dtSFInfo["RoomType"].ToString()).Selected = true; } uoHiddenFieldContractID.Value = GlobalCode.Field2String(dtSFInfo["colContractIdInt"]); } } catch (Exception ex) { AlertMessage(ex.Message); } finally { if (dtSFInfo != null) { dtSFInfo.Close(); dtSFInfo.Dispose(); } } }
/// <summary> /// Date Created: 22/Oct/2013 /// Created By: Josephine Gad /// (description) GetServiceRequestEmail /// --------------------------------------- /// Date Modified: 25/Oct/2013 /// Modified By: Josephine Gad /// (description) Add Service Provider Email /// </summary> public void GetServiceRequestEmail(Int32 iHotelRequestID, Int32 iVehicleRequestID, int iPortAgentRequestID, Int32 iMeetGreetRequestID, Int16 iLoadType) { List <ServiceRequestEmailList> list = new List <ServiceRequestEmailList>(); List <CrewAssistEmailDetail> hotelEmail = new List <CrewAssistEmailDetail>(); List <CrewAssistTranspo> vehicleEmail = new List <CrewAssistTranspo>(); List <CrewAssistMeetAndGreet> meetGreetEmail = new List <CrewAssistMeetAndGreet>(); List <CopyEmail> copyMail = new List <CopyEmail>(); Database db = ConnectionSetting.GetConnection(); // DatabaseFactory.CreateDatabase() DbCommand dbComm = null; DataSet ds = null; DataTable dt = null; DataTable dtCopy = null; DataTable dtHotel = null; DataTable dtVehicle = null; DataTable dtMeetGreet = null; DataTable dtAirDetail = null; if (iLoadType == 0) { HttpContext.Current.Session["ServiceRequestEmail_EmailList"] = list; HttpContext.Current.Session["ServiceRequestEmail_CopyMailList"] = copyMail; } HttpContext.Current.Session["ServiceRequestEmail_HotelEmailDetails"] = hotelEmail; HttpContext.Current.Session["ServiceRequestEmail_VehicleEmailDetails"] = vehicleEmail; HttpContext.Current.Session["ServiceRequestEmail_MeetGreetEmailDetails"] = meetGreetEmail; try { dbComm = db.GetStoredProcCommand("uspGetServiceRequestEmail"); db.AddInParameter(dbComm, "@pHotelRequestID", DbType.Int32, iHotelRequestID); db.AddInParameter(dbComm, "@pVehicleRequestID", DbType.Int32, iVehicleRequestID); db.AddInParameter(dbComm, "@pMeetGreetRequestID", DbType.Int32, iMeetGreetRequestID); db.AddInParameter(dbComm, "@pPortAgentRequestID", DbType.Int32, iPortAgentRequestID); db.AddInParameter(dbComm, "@pLoadType", DbType.Int16, iLoadType); ds = db.ExecuteDataSet(dbComm); if (iLoadType == 0) { dt = ds.Tables[0]; list = (from a in dt.AsEnumerable() select new ServiceRequestEmailList { HotelID = GlobalCode.Field2Int(a["HotelID"]), HotelEmailTo = a.Field <string>("HotelEmailTo"), HotelName = a.Field <string>("HotelName"), VehicleID = GlobalCode.Field2Int(a["VehicleID"]), VehicleEmailTo = a.Field <string>("VehicleEmailTo"), VehicleName = a.Field <string>("VehicleName"), MeetGreetID = GlobalCode.Field2Int(a["MeetGreetID"]), MeetGreetEmailTo = a.Field <string>("MeetGreetEmailTo"), MeetGreetName = a.Field <string>("MeetGreetName"), PortAgentID = GlobalCode.Field2Int(a["MeetGreetID"]), PortAgentName = a.Field <string>("PortAgentName"), PortAgentEmailTo = a.Field <string>("PortAgentEmailTo"), VesselID = GlobalCode.Field2Int(a["VesselID"]), VesselEmailTo = a.Field <string>("VesselEmail") }).ToList(); dtCopy = ds.Tables[1]; dtHotel = ds.Tables[2]; dtVehicle = ds.Tables[3]; dtMeetGreet = ds.Tables[4]; dtAirDetail = ds.Tables[5]; copyMail = (from a in dtCopy.AsEnumerable() select new CopyEmail { EmailName = GlobalCode.Field2String(a["EmailType"]), EmailType = GlobalCode.Field2Int(a["EmailID"]), Email = GlobalCode.Field2String(a["Email"]), }).ToList(); HttpContext.Current.Session["ServiceRequestEmail_EmailList"] = list; HttpContext.Current.Session["ServiceRequestEmail_CopyMailList"] = copyMail; } else if (iLoadType == 1) { dtHotel = ds.Tables[0]; dtVehicle = ds.Tables[1]; dtMeetGreet = ds.Tables[2]; dtAirDetail = ds.Tables[3]; } //----------------------------------Get the request details to be emailed---------------------------------- if (dtHotel != null) { hotelEmail = (from a in dtHotel.AsEnumerable() select new CrewAssistEmailDetail { SeafarerID = GlobalCode.Field2String(a["colSeafarerIDInt"]), LastName = GlobalCode.Field2String(a["LastName"]), FirstName = GlobalCode.Field2String(a["FirstName"]), GenderDiscription = GlobalCode.Field2String(a["Gender"]), BrandCode = GlobalCode.Field2String(a["Branch"]), RankName = GlobalCode.Field2String(a["Rank"]), SFStatus = GlobalCode.Field2String(a["Status"]), Nationality = GlobalCode.Field2String(a["Nationality"]), VesselName = GlobalCode.Field2String(a["Vessel"]), VesselId = GlobalCode.Field2Int(a["colVesselIdInt"]), CostCenterCode = GlobalCode.Field2String(a["CostCenter"]), RoomDesc = GlobalCode.Field2String(a["RoomType"]), SharingWith = GlobalCode.Field2String(a["SharingWith"]), TimeSpanStartDate = GlobalCode.Field2Date(a["TimeSpanStartDate"]), TimeSpanEndDate = GlobalCode.Field2Date(a["TimeSpanStartDate"]), TimeSpanStartTime = GlobalCode.Field2String(a["TimeSpanStartTime"]), TimeSpanEndTime = GlobalCode.Field2String(a["TimeSpanEndTime"]), Mealvoucheramount = GlobalCode.Field2Double(a["Mealvoucheramount"]).ToString("n2"), //Confirmedbyhotelvendor = GlobalCode.Field2Double(a["Confirmedbyhotelvendor"]).ToString(), ConfirmedbyRCCL = GlobalCode.Field2String(a["ConfirmedbyRCCL"]), VendorBranch = GlobalCode.Field2String(a["colVendorBranchNameVarchar"]), Roomrate = GlobalCode.Field2Double(a["Roomrate"]).ToString("n2"), // GlobalCode.Field2String(a["Roomrate"]) Comment = GlobalCode.Field2String(a["colCommentsVarchar"]), Confirmedbyhotelvendor = GlobalCode.Field2String(a["colConfirmName"]), CrewAssistEmailAirDetail = (from n in dtAirDetail.AsEnumerable() select new CrewAssistEmailAirDetail { AirDetail = GlobalCode.Field2String(n["AirDetail"]) }).ToList() }).ToList(); HttpContext.Current.Session["ServiceRequestEmail_HotelEmailDetails"] = hotelEmail; } if (dtVehicle != null) { vehicleEmail = (from a in dtVehicle.AsEnumerable() select new CrewAssistTranspo { VehicleTransID = GlobalCode.Field2Int(a["colTransVehicleIDBigint"]), IdBigint = GlobalCode.Field2Long(a["colIdBigint"]), TravelReqIDInt = GlobalCode.Field2Long(a["colTravelReqIDInt"]), SeqNoInt = GlobalCode.Field2TinyInt(a["colSeqNoInt"]), RecordLocatorVarchar = GlobalCode.Field2String(a["colRecordLocatorVarchar"]), VehicleVendorIDInt = GlobalCode.Field2Long(a["colVehicleVendorIDInt"]), VehicleVendor = GlobalCode.Field2String(a["colVehicleVendorNameVarchar"]), VehiclePlateNoVarchar = GlobalCode.Field2String(a["colVehiclePlateNoVarchar"]), PickUpDate = GlobalCode.Field2DateTime(a["colPickUpDate"]), PickUpTime = GlobalCode.Field2DateTime(a["colPickUpTime"]), DropOffDate = GlobalCode.Field2DateTime(a["colDropOffDate"]), DropOffTime = GlobalCode.Field2DateTime(a["colDropOffTime"]), ConfirmationNoVarchar = GlobalCode.Field2String(a["colConfirmationNoVarchar"]), VehicleStatusVarchar = GlobalCode.Field2String(a["colVehicleStatusVarchar"]), VehicleTypeIdInt = GlobalCode.Field2Int(a["colVehicleTypeIdInt"]), SFStatus = GlobalCode.Field2String(a["colSFStatus"]), RouteIDFromInt = GlobalCode.Field2Int(a["colRouteIDFromInt"]), RouteIDToInt = GlobalCode.Field2Int(a["colRouteIDToInt"]), FromVarchar = GlobalCode.Field2String(a["colFromVarchar"]), ToVarchar = GlobalCode.Field2String(a["colToVarchar"]), Comment = GlobalCode.Field2String(a["colRemarksForAuditVarchar"]), //TransSender = UserID, SeaparerID = GlobalCode.Field2Long(a["colSeafarerIdInt"]), FirstName = GlobalCode.Field2String(a["colFirstNameVarchar"]), LastName = GlobalCode.Field2String(a["colLastNameVarchar"]), RankName = GlobalCode.Field2String(a["RankName"]), Gender = GlobalCode.Field2String(a["colGenderDiscription"]), NationalityName = GlobalCode.Field2String(a["Nationality"]), }).ToList(); HttpContext.Current.Session["ServiceRequestEmail_VehicleEmailDetails"] = vehicleEmail; } if (dtMeetGreet != null) { meetGreetEmail = (from Q in dtMeetGreet.AsEnumerable() select new CrewAssistMeetAndGreet { ReqMeetAndGreetID = GlobalCode.Field2Long(Q["colReqMeetAndGreetIDBigint"]), IdBigint = GlobalCode.Field2Long(Q["colIdBigint"]), TravelReqID = GlobalCode.Field2Long(Q["colTravelReqIDInt"]), SeqNo = GlobalCode.Field2Int(Q["colSeqNoInt"]), RecordLocator = GlobalCode.Field2String(Q["colRecordLocatorVarchar"]), MeetAndGreetVendorID = GlobalCode.Field2Int(Q["colMeetAndGreetVendorIDInt"]), MeetAndGreetVendor = GlobalCode.Field2String(Q["colMeetAndGreetVendorNameVarchar"]), ConfirmationNo = GlobalCode.Field2String(Q["colConfirmationNoVarchar"]), AirportID = GlobalCode.Field2Int(Q["colAirportInt"]), FligthNo = GlobalCode.Field2String(Q["colFligthNoVarchar"]), ServiceDate = GlobalCode.Field2DateTime(Q["colServiceDatetime"]), Rate = GlobalCode.Field2Double(Q["colRateFloat"]), SFStatus = GlobalCode.Field2String(Q["colSFStatus"]), Comment = GlobalCode.Field2String(Q["colCommentVarchar"]), IsAir = GlobalCode.Field2Bool(Q["colIsAirBit"]), Email = GlobalCode.Field2String(Q["colEmailToVarchar"]) }).ToList(); HttpContext.Current.Session["ServiceRequestEmail_MeetGreetEmailDetails"] = meetGreetEmail; } } catch (Exception ex) { throw ex; } finally { if (dbComm != null) { dbComm.Dispose(); } if (dt != null) { dt.Dispose(); } if (dtCopy != null) { dtCopy.Dispose(); } if (dtHotel != null) { dtHotel.Dispose(); } if (dtVehicle != null) { dtVehicle.Dispose(); } if (dtMeetGreet != null) { dtMeetGreet.Dispose(); } if (ds != null) { ds.Dispose(); } if (dtAirDetail != null) { dtAirDetail.Dispose(); } } }
void insertHotelrequest(string spName, string status) { int?StatusID = null; List <NonTurnRequestBooking> PAH = new List <NonTurnRequestBooking>(); foreach (ListViewDataItem item in uolistviewHotelInfo.Items) { if (status == "Cancel") { StatusID = 5; } else { StatusID = GlobalCode.Field2Int(((HiddenField)item.FindControl("uoHiddenFieldStatusID")).Value); } PAH.Add(new NonTurnRequestBooking { TransHotelID = GlobalCode.Field2Long(((HiddenField)item.FindControl("uoHiddenFieldTransHotelID")).Value), TravelReqID = GlobalCode.Field2Long(((HiddenField)item.FindControl("uoHiddenFieldListTRID")).Value), SeafarerID = GlobalCode.Field2Long(((Label)item.FindControl("uoLblSfID")).Text), IdBigint = GlobalCode.Field2Long(((HiddenField)item.FindControl("uoHiddenFieldListRecLocID")).Value), RecordLocator = GlobalCode.Field2String(((Label)item.FindControl("uoLblRecLoc")).Text), SeqNo = GlobalCode.Field2Int(((HiddenField)item.FindControl("uoHiddenFieldSeqNo")).Value), VendorID = GlobalCode.Field2Int(uoVendorDropDownList.SelectedItem.Value), RoomTypeID = ((Label)item.FindControl("uoLblRoom")).Text == "double" ? 2 : 1, CheckIn = GlobalCode.Field2DateTime(uoTextBoxCheckInDate.Text), CheckOut = GlobalCode.Field2DateTime(((Label)item.FindControl("uoLblCheckOut")).Text), Duration = GlobalCode.Field2Int(((Label)item.FindControl("uoLblNites")).Text) <= 0 ? 1 : GlobalCode.Field2Int(((Label)item.FindControl("uoLblNites")).Text), VoucherAmount = GlobalCode.Field2Double(uoHiddenFieldVoucher.Value), ContractID = GlobalCode.Field2Int(uoHiddenFieldContractID.Value), ApprovedBy = GlobalCode.Field2String(uoTextBoxConfirmedBy.Text), ApprovedDate = DateTime.Now.Date, RoomCount = GlobalCode.Field2Float((((Label)item.FindControl("uoLblRoom"))).Text == "double" ? 0.5 : 1.0), HotelName = GlobalCode.Field2String(uoTextBoxHotelname.Text), //ConfirmRateMoney = GlobalCode.Field2Double(uoTextBoxRateConfirmed.Text), //ContractedRateMoney = GlobalCode.Field2Double(uoTextBoxRateContract.Text), ConfirmRateMoney = GlobalCode.Field2Double(((TextBox)item.FindControl("txtContractedRate")).Text), ContractedRateMoney = GlobalCode.Field2Double(((Label)item.FindControl("lblContractedRate")).Text), EmailTo = GlobalCode.Field2String(uoTextBoxEmailAdd.Text), EmailCC = GlobalCode.Field2String(uoTextBoxCopy.Text), Comment = GlobalCode.Field2String(uoTextBoxComment.Text), Currency = GlobalCode.Field2Int(uoDropDownListCurrency.SelectedItem.Value), ConfirmBy = GlobalCode.Field2String(uoTextBoxConfirmedBy.Text), StatusID = StatusID,//GlobalCode.Field2Int(((HiddenField)item.FindControl("uoHiddenFieldStatusID")).Value),// == 1 ? 2 : 4 , IsMedical = GlobalCode.Field2Bool(((HiddenField)item.FindControl("uoHiddenFieldIsMedical")).Value), UserID = uoHiddenFieldUser.Value }); } GlobalCode gc = new GlobalCode(); DataTable dt = new DataTable(); dt = gc.getDataTable(PAH); PortBLL = new PortAgentBLL(); PortBLL.InsertNonTurnTransactionRequestBooking(dt, spName, uoHiddenFieldUser.Value, uoTextBoxEmailAdd.Text, uoTextBoxCopy.Text); }
/// Date Modified: 26/03/2013 /// Modified By: Marco Abejar /// (description) Save SF Hotel Request /// ------------------------------------------- /// Date Modified: 30/May/2013 /// Modified By: Josephine Gad /// (description) Add Shuttle, MealLunchDinner, Tax Bit and Tax Percent /// Add fields for audit trail use /// ------------------------------------------- /// </summary> public static string SeafarerSaveRequest(string RequestNo, string SfID, string LastName, string FirstName, string Gender, string RegionID, string PortID, string AirportID, string HotelID, string CheckinDate, string CheckoutDate, string NoNites, string RoomType, bool MealBreakfast, bool MealLunch, bool MealDinner, bool MealLunchDinner, bool WithShuttle, string RankID, string VesselInt, string CostCenter, string Comments, string SfStatus, string TimeIn, string TimeOut, string RoomAmount, bool IsRoomTax, string RoomTaxPercent, string UserID, string TrID, string Currency, string strLogDescription, string strFunction, string strPageName, DateTime DateGMT, DateTime CreatedDate) { Database SFDatebase = ConnectionSetting.GetConnection(); // DatabaseFactory.CreateDatabase() DbCommand SFDbCommand = null; DbConnection connection = SFDatebase.CreateConnection(); connection.Open(); DbTransaction trans = connection.BeginTransaction(); try { string strTimeZone = TimeZone.CurrentTimeZone.StandardName.ToString(); SFDbCommand = SFDatebase.GetStoredProcCommand("uspInsertSFHotelRequest"); SFDatebase.AddInParameter(SFDbCommand, "@pRequestNo", DbType.String, RequestNo); SFDatebase.AddInParameter(SFDbCommand, "@pSeafarerIDInt", DbType.Int32, Int32.Parse(SfID)); SFDatebase.AddInParameter(SFDbCommand, "@pLastNameVarchar", DbType.String, LastName); SFDatebase.AddInParameter(SFDbCommand, "@pFirstNameVarchar", DbType.String, FirstName); SFDatebase.AddInParameter(SFDbCommand, "@pGender", DbType.Int32, Int32.Parse(Gender)); SFDatebase.AddInParameter(SFDbCommand, "@pRegionIDInt", DbType.Int32, Int32.Parse(RegionID)); SFDatebase.AddInParameter(SFDbCommand, "@pPortIDInt", DbType.Int32, Int32.Parse(PortID)); SFDatebase.AddInParameter(SFDbCommand, "@pAirportIDInt", DbType.Int32, Int32.Parse(AirportID)); SFDatebase.AddInParameter(SFDbCommand, "@pHotelIDInt", DbType.Int32, Int32.Parse(HotelID)); SFDatebase.AddInParameter(SFDbCommand, "@pCheckinDate", DbType.DateTime, CheckinDate); SFDatebase.AddInParameter(SFDbCommand, "@pCheckoutDate", DbType.DateTime, CheckoutDate); SFDatebase.AddInParameter(SFDbCommand, "@pNoNitesInt", DbType.Int32, Int32.Parse(NoNites)); SFDatebase.AddInParameter(SFDbCommand, "@pRoomTypeId", DbType.String, RoomType); SFDatebase.AddInParameter(SFDbCommand, "@pMealBreakfastBit", DbType.Boolean, MealBreakfast); SFDatebase.AddInParameter(SFDbCommand, "@pMealLunchBit", DbType.Boolean, MealLunch); SFDatebase.AddInParameter(SFDbCommand, "@pMealDinnerBit", DbType.Boolean, MealDinner); SFDatebase.AddInParameter(SFDbCommand, "@pMealLunchDinnerBit", DbType.Boolean, MealLunchDinner); SFDatebase.AddInParameter(SFDbCommand, "@pWithShuttleBit", DbType.Boolean, WithShuttle); SFDatebase.AddInParameter(SFDbCommand, "@pRankIDInt", DbType.Int32, Int32.Parse(RankID)); SFDatebase.AddInParameter(SFDbCommand, "@pVesselInt", DbType.Int32, Int32.Parse(VesselInt)); SFDatebase.AddInParameter(SFDbCommand, "@pCostCenterInt", DbType.Int32, Int32.Parse(CostCenter)); SFDatebase.AddInParameter(SFDbCommand, "@pCommentsVarchar", DbType.String, Comments); SFDatebase.AddInParameter(SFDbCommand, "@pSfStatus", DbType.String, SfStatus); SFDatebase.AddInParameter(SFDbCommand, "@pTimeIn", DbType.String, TimeIn); SFDatebase.AddInParameter(SFDbCommand, "@pTimeOut", DbType.String, TimeOut); SFDatebase.AddInParameter(SFDbCommand, "@pRoomAmount", DbType.String, RoomAmount); SFDatebase.AddInParameter(SFDbCommand, "@pRoomRateTaxInclusive", DbType.Boolean, IsRoomTax); SFDatebase.AddInParameter(SFDbCommand, "@pRoomRateTaxPercentage", DbType.Double, GlobalCode.Field2Double(RoomTaxPercent)); SFDatebase.AddInParameter(SFDbCommand, "@pUserID", DbType.String, UserID); SFDatebase.AddInParameter(SFDbCommand, "@pTrID", DbType.String, TrID); SFDatebase.AddInParameter(SFDbCommand, "@pCurrency", DbType.String, Currency); SFDatebase.AddInParameter(SFDbCommand, "@pDescription", DbType.String, strLogDescription); SFDatebase.AddInParameter(SFDbCommand, "@pFunction", DbType.String, strFunction); SFDatebase.AddInParameter(SFDbCommand, "@pFileName", DbType.String, strPageName); SFDatebase.AddInParameter(SFDbCommand, "@pTimezone", DbType.String, strTimeZone); SFDatebase.AddInParameter(SFDbCommand, "@pGMTDATE", DbType.DateTime, DateGMT); SFDatebase.AddInParameter(SFDbCommand, "@pCreateDate", DbType.DateTime, CreatedDate); string sHRID = SFDatebase.ExecuteScalar(SFDbCommand).ToString(); trans.Commit(); return(sHRID); } catch (Exception ex) { trans.Rollback(); throw ex; } finally { if (connection != null) { connection.Close(); connection.Dispose(); } if (SFDbCommand != null) { SFDbCommand.Dispose(); } if (trans != null) { trans.Dispose(); } } }
void insertTransportationRequest(string spName, string Status) { short statusID = GlobalCode.Field2TinyInt(Request.QueryString["st"]); Label uoLblSfID; Label uoLabelLast; LinkButton SeafarerLinkButton; Label uoLblCheckOut; Label uoLblNites; Label uoLblRoom; Label uoLblVessel; Label uoLblRank; Label uoLblCostCenter; Label uoLblRecLoc; HiddenField RecLocID; HiddenField TravelReqID; HiddenField SeqNo; Label lblSFStatus; Label lblRoutFrom; Label lblRoutTo; HiddenField uoHiddenFieldRouteFrom; HiddenField uoHiddenFieldRouteTo; HiddenField TransVehicleID; TextBox TextBoxRateConfirmedPerSeafarer; List <NonTurnTransportationRequest> PAH = new List <NonTurnTransportationRequest>(); foreach (ListViewDataItem item in uoListviewVehicleInfo.Items) { uoLblSfID = (Label)item.FindControl("uoLblSfID"); uoLabelLast = (Label)item.FindControl("uoLabelLast"); SeafarerLinkButton = (LinkButton)item.FindControl("SeafarerLinkButton"); uoLblCheckOut = (Label)item.FindControl("uoLblCheckOut"); uoLblNites = (Label)item.FindControl("uoLblNites"); uoLblRoom = (Label)item.FindControl("uoLblRoom"); lblSFStatus = (Label)item.FindControl("lblStatus"); uoLblVessel = (Label)item.FindControl("uoLblVessel"); uoLblRank = (Label)item.FindControl("uoLblRank"); uoLblCostCenter = (Label)item.FindControl("Label1"); uoLblRecLoc = (Label)item.FindControl("uoLblRecLoc"); RecLocID = (HiddenField)item.FindControl("uoHiddenFieldListRecLocID"); TravelReqID = (HiddenField)item.FindControl("uoHiddenFieldListTRID"); SeqNo = (HiddenField)item.FindControl("uoHiddenFieldSeqNo"); lblRoutFrom = (Label)item.FindControl("lblRouteFrom"); lblRoutTo = (Label)item.FindControl("lblRouteTo"); uoHiddenFieldRouteFrom = (HiddenField)item.FindControl("uoHiddenFieldRouteFrom"); uoHiddenFieldRouteTo = (HiddenField)item.FindControl("uoHiddenFieldRouteTo"); lblRoutFrom.Text = lblRoutFrom.Text == "" ? uoHiddenFieldRouteFrom.Value : lblRoutFrom.Text; lblRoutTo.Text = lblRoutFrom.Text == "" ? uoHiddenFieldRouteTo.Value : lblRoutTo.Text; TransVehicleID = (HiddenField)item.FindControl("uoHiddenFieldTransID"); TextBoxRateConfirmedPerSeafarer = (TextBox)item.FindControl("uoTextBoxRateConfirmedPerSeafarer"); PAH.Add(new NonTurnTransportationRequest { TransVehicleID = GlobalCode.Field2Long(TransVehicleID.Value), TravelReqID = GlobalCode.Field2Long(TravelReqID.Value), SeafarerID = GlobalCode.Field2Long(uoLblSfID.Text), IdBigint = GlobalCode.Field2Long(RecLocID.Value), RecordLocator = GlobalCode.Field2String(uoLblRecLoc.Text), SeqNoInt = GlobalCode.Field2Int(SeqNo.Value), VehicleVendorID = GlobalCode.Field2Int(uoVendorDropDownList.SelectedItem.Value), VehiclePlateNo = "", PickUpDate = GlobalCode.Field2DateTime(uoTextBoxPickupDate.Text), PickUpTime = GlobalCode.Field2DateTime(uoTextBoxPickupTime.Text), DropOffDate = GlobalCode.Field2DateTime(uoTextBoxPickupDate.Text), DropOffTime = GlobalCode.Field2DateTime(uoTextBoxPickupTime.Text), ConfirmationNo = GlobalCode.Field2String(uoTextBoxConfirmation.Text), VehicleStatus = "Open", VehicleTypeId = GlobalCode.Field2Int(uoDropDownListVehicleType.SelectedItem.Value), RouteIDFrom = GlobalCode.Field2Int(uoDropDownListTFrom.SelectedItem.Value), RouteIDTo = GlobalCode.Field2Int(uoDropDownListTTo.SelectedItem.Value), RouteFromVarchar = GlobalCode.Field2String(lblRoutFrom.Text), RouteToVarchar = GlobalCode.Field2String(lblRoutTo.Text), ContractId = GlobalCode.Field2Int(uoHiddenFieldContractID.Value), DriverID = 0, SFStatus = GlobalCode.Field2String(lblSFStatus.Text), ConfirmBy = uoTextBoxConfirmedBy.Text, Comments = uoTextBoxComment.Text, StatusID = statusID, //(short)(Status == "Cancel" ? 5 : statusID), ConfirmedRateMoney = GlobalCode.Field2Double(TextBoxRateConfirmedPerSeafarer.Text) }); } GlobalCode gc = new GlobalCode(); DataTable dt = new DataTable(); dt = gc.getDataTable(PAH); PortAgentBLL PortBLL = new PortAgentBLL(); PortBLL.InsertNonTurnTransactionRequestBooking(dt, spName, uoHiddenFieldUser.Value, uoTextBoxEmailAdd.Text, uoTextBoxCopy.Text); }
public List <VehicleTransactionMedical> InsertVehicleTransactionMedical(List <VehicleTransactionMedical> Medical) { Database SFDatebase = ConnectionSetting.GetConnection(); // DatabaseFactory.CreateDatabase() DbCommand SFDbCommand = null; try { List <VehicleTransactionMedical> VehicleTransMedical = new List <VehicleTransactionMedical>(); GlobalCode gc = new GlobalCode(); DataTable dt = new DataTable(); DataSet ds = new DataSet(); dt = gc.getDataTable(Medical); dt.Columns.Remove("ColorCode"); dt.Columns.Remove("ForeColor"); string strTimeZone = TimeZone.CurrentTimeZone.StandardName.ToString(); SFDbCommand = SFDatebase.GetStoredProcCommand("uspVehicleTransactionMedicalIns"); SqlParameter param = new SqlParameter("@pVehicleTransactionMedical", dt); param.Direction = ParameterDirection.Input; param.SqlDbType = SqlDbType.Structured; SFDbCommand.Parameters.Add(param); ds = SFDatebase.ExecuteDataSet(SFDbCommand); VehicleTransMedical = (from n in ds.Tables[0].AsEnumerable() select new VehicleTransactionMedical { TransVehicleID = GlobalCode.Field2Long(n["colTransVehicleIDBigint"]), SeafarerID = GlobalCode.Field2Long(n["colSeafarerIDBigint"]), IdBigint = GlobalCode.Field2Long(n["colIdBigint"]), TravelReqID = GlobalCode.Field2Long(n["colTravelReqIDInt"]), RecordLocator = GlobalCode.Field2String(n["colRecordLocatorVarchar"]), TranspoVendorID = GlobalCode.Field2Long(n["colTranspoVendorIDInt"]), VehiclePlateNo = GlobalCode.Field2String(n["colVehiclePlateNoVarchar"]), PickUpDate = GlobalCode.Field2DateTime(n["colPickUpDate"]), PickUpTime = GlobalCode.Field2DateTime(n["colPickUpTime"]), DropOffDate = GlobalCode.Field2DateTime(n["colDropOffDate"]), DropOffTime = GlobalCode.Field2DateTime(n["colDropOffTime"]), ConfirmationNo = GlobalCode.Field2String(n["colConfirmationNoVarchar"]), VehicleStatus = GlobalCode.Field2String(n["colVehicleStatusVarchar"]), VehicleTypeId = GlobalCode.Field2Int(n["colVehicleTypeIdInt"]), SFStatus = GlobalCode.Field2String(n["colSFStatus"]), RouteIDFrom = GlobalCode.Field2Int(n["colRouteIDFromInt"]), RouteIDTo = GlobalCode.Field2Int(n["colRouteIDToInt"]), From = GlobalCode.Field2String(n["colFromVarchar"]), To = GlobalCode.Field2String(n["colToVarchar"]), DateCreated = GlobalCode.Field2DateTime(n["colDateCreatedDatetime"]), DateModified = GlobalCode.Field2DateTime(n["colDateModifiedDatetime"]), CreatedBy = GlobalCode.Field2String(n["colCreatedByVarchar"]), Modifiedby = GlobalCode.Field2String(n["colModifiedbyVarchar"]), IsActive = GlobalCode.Field2Bool(n["colIsActiveBit"]), RemarksForAudit = GlobalCode.Field2String(n["colRemarksForAuditVarchar"]), HotelID = GlobalCode.Field2Int(n["colHotelIDInt"]), IsVisible = GlobalCode.Field2Bool(n["colIsVisibleBit"]), ContractId = GlobalCode.Field2Int(n["colContractIdInt"]), IsSeaport = GlobalCode.Field2Bool(n["colIsSeaportBit"]), SeqNo = GlobalCode.Field2Int(n["colSeqNoInt"]), Driver = GlobalCode.Field2String(n["colDriverVarchar"]), VehicleDispatchTime = GlobalCode.Field2String(n["colVehicleDispatchTime"]), RouteFrom = GlobalCode.Field2String(n["colRouteFromVarchar"]), RouteTo = GlobalCode.Field2String(n["colRouteToVarchar"]), VehicleUnset = GlobalCode.Field2Bool(n["colVehicleUnset"]), VehicleUnsetBy = GlobalCode.Field2String(n["colVehicleUnsetBy"]), VehicleUnsetDate = GlobalCode.Field2DateTime(n["colVehicleUnsetDate"]), ConfirmBy = GlobalCode.Field2String(n["colConfirmByVarchar"]), Comments = GlobalCode.Field2String(n["colCommentsVarchar"]), VehicleVendor = GlobalCode.Field2String(n["colVehicleVendorName"]), ContractedRateMoney = GlobalCode.Field2Double(n["colContractedRateMoney"]), ConfirmRateMoney = GlobalCode.Field2Double(n["colConfirmRateMoney"]), CurrencyInt = GlobalCode.Field2Int(n["colCurrencyInt"]), StatusID = GlobalCode.Field2TinyInt(n["colStatusIDTinyint"]), ApprovedBy = GlobalCode.Field2String(n["colApprovedByVarchar"]), ApprovedDate = GlobalCode.Field2DateTime(n["colApprovedDate"]), EmailTo = GlobalCode.Field2String(n["colEmailTovarchar"]), RequestSourceID = GlobalCode.Field2TinyInt(n["colRequestSourceIDInt"]), TransportationDetails = GlobalCode.Field2String(n["colTransportationDetails"]), IsPortAgent = GlobalCode.Field2Bool(n["colIsPortAgentBit"]), ColorCode = GlobalCode.Field2String(n["ColorCode"]), ForeColor = GlobalCode.Field2String(n["ForeColor"]), }).ToList(); return(VehicleTransMedical); } catch (Exception ex) { throw ex; } finally { if (SFDbCommand != null) { SFDbCommand.Dispose(); } } }
private List <CrewMemberInformation> ProcessSeafarerInfo(DataSet ds, string UserID) { List <CrewMemberInformation> SeafarerInfo = new List <CrewMemberInformation>(); try { if (ds != null) { if (ds.Tables.Count > 0) { return((from a in ds.Tables[0].AsEnumerable() select new CrewMemberInformation { SeafarerID = GlobalCode.Field2Long(a["colSeafarerIdInt"]), FirstName = GlobalCode.Field2String(a["colFirstNameVarchar"]), LastName = GlobalCode.Field2String(a["colLastNameVarchar"]), Name = GlobalCode.Field2String(a["FullName"]), Gender = GlobalCode.Field2String(a["colGenderDiscription"]), NationalityID = GlobalCode.Field2Int(a["colNatioalityIdInt"]), NationalityCode = GlobalCode.Field2String(a["colNationalityCodeVarchar"]), Nationality = GlobalCode.Field2String(a["colNationalityDescriptionVarchar"]), CrewSchedule = (from n in ds.Tables[1].AsEnumerable() select new CrewSchedule { TravelRequestID = n.Field <long?>("TravelRequestID"), IDBigint = n.Field <long?>("colIDBigInt"), SeqNo = n.Field <int?>("SeqNo"), RecordLocator = n.Field <string>("colRecordLocatorVarchar"), VesselID = n.Field <int?>("colVesselIdInt"), Vessel = n.Field <string>("colVesselLongCodeVarchar"), VesselCode = n.Field <string>("colVesselCodeVarchar"), Status = n.Field <string>("colStatusVarchar"), SignOnOffDate = n.Field <DateTime?>("RequestDate"), PortID = n.Field <int?>("colPortIdInt"), Port = n.Field <string>("colPortNameVarchar"), PortCode = n.Field <string>("colPortCodeVarchar"), ReasonCode = n.Field <string>("colReasonCodeVarchar"), CostcenterID = n.Field <int?>("colCostCenterIDInt"), Costcenter = n.Field <string>("colCostCenterNameVarchar"), RankID = n.Field <int?>("colRankIDInt"), Rank = n.Field <string>("colRankNameVarchar"), RankCode = n.Field <string>("colRankCodeVarchar"), BrandID = n.Field <int?>("colBrandIdInt"), Brand = n.Field <string>("colBrandNameVarchar"), LOEStatus = GlobalCode.Field2String(n["LOEStatus"]), LOEDate = n.Field <DateTime?>("LOEDate"), LOEImmigrationOfficer = GlobalCode.Field2String(n["LOEImmigrationOfficer"]), LOEImmigrationPlace = GlobalCode.Field2String(n["LOEImmigrationPlace"]), LOEReason = GlobalCode.Field2String(n["Reason"]), }).ToList(), Remark = (from n in ds.Tables[2].AsEnumerable() select new CrewAssisRemark { TravelRequestID = n.Field <long?>("TravelRequestID"), RemarkID = n.Field <long?>("RemarkID"), Remark = n.Field <string>("Remark"), RemarkBy = n.Field <string>("RemarkBy"), RemarkDate = n.Field <DateTime?>("RemarkDate"), Visible = n.Field <string>("Visible"), //n.Field<string>("CreatedBy") == UserID ? "True" : "False", ReqResourceID = GlobalCode.Field2TinyInt(n["colRemarkSourceID"]), Resource = n.Field <string>("colRemarkSource"), IDBigInt = n.Field <long?>("IDBigInt"), RecordLocator = n.Field <string>("RecordLocator") }).ToList(), HotelTransactionMedical = (from n in ds.Tables[3].AsEnumerable() select new HotelTransactionMedical { TransHotelID = GlobalCode.Field2Long(n["colTransHotelIDBigInt"]), SeafarerID = GlobalCode.Field2Long(n["colSeafarerIDBigInt"]), FullName = GlobalCode.Field2String(n["colFullNameVarchar"]), TravelReqID = GlobalCode.Field2Long(n["colTravelReqIDInt"]), IdBigint = GlobalCode.Field2Long(n["colIdBigint"]), RecordLocator = GlobalCode.Field2String(n["colRecordLocatorVarchar"]), SeqNo = GlobalCode.Field2Int(n["colSeqNoInt"]), PortAgentVendorID = GlobalCode.Field2Long(n["colPortAgentVendorIDInt"]), RoomTypeID = GlobalCode.Field2Int(n["colRoomTypeIDInt"]), RoomType = GlobalCode.Field2String(n["RoomType"]), ReserveUnderName = GlobalCode.Field2String(n["colReserveUnderNameVarchar"]), TimeSpanStartDate = GlobalCode.Field2DateTime(n["colTimeSpanStartDate"]), TimeSpanStartTime = GlobalCode.Field2DateTime(n["colTimeSpanStartTime"]), TimeSpanEndDate = GlobalCode.Field2DateTime(n["colTimeSpanEndDate"]), TimeSpanEndTime = GlobalCode.Field2DateTime(n["colTimeSpanEndTime"]), TimeSpanDuration = GlobalCode.Field2Int(n["colTimeSpanDurationInt"]), ConfirmationNo = GlobalCode.Field2String(n["colConfirmationNoVarchar"]), HotelStatus = GlobalCode.Field2String(n["colHotelStatusVarchar"]), DateCreatedDatetime = GlobalCode.Field2DateTime(n["colDateCreatedDatetime"]), CreatedBy = GlobalCode.Field2String(n["colCreatedByVarchar"]), IsActive = GlobalCode.Field2Bool(n["colIsActiveBit"]), VoucherAmount = GlobalCode.Field2Long(n["colVoucherAmountMoney"]), ContractID = GlobalCode.Field2Long(n["colContractIDInt"]), ApprovedBy = GlobalCode.Field2String(n["colApprovedByVarchar"]), ApprovedDate = GlobalCode.Field2DateTime(n["colApprovedDate"]), ContractFrom = GlobalCode.Field2String(n["colContractFromVarchar"]), RemarksForAudit = GlobalCode.Field2String(n["colRemarksForAuditVarchar"]), HotelCity = GlobalCode.Field2String(n["colHotelCityVarchar"]), RoomCount = GlobalCode.Field2Float(n["colRoomCountFloat"]), HotelName = GlobalCode.Field2String(n["colHotelNameVarchar"]), ConfirmRateMoney = GlobalCode.Field2Decimal(n["colConfirmRateMoney"]), ContractedRateMoney = GlobalCode.Field2Decimal(n["colContractedRateMoney"]), EmailTo = GlobalCode.Field2String(n["colEmailToVarchar"]), Comment = GlobalCode.Field2String(n["colCommentVarchar"]), CurrencyID = GlobalCode.Field2Int(n["colCurrencyInt"]), ConfirmBy = GlobalCode.Field2String(n["colConfirmByVarchar"]), StatusID = GlobalCode.Field2TinyInt(n["colStatusIDTinyint"]), ColorCode = GlobalCode.Field2String(n["ColorCode"]), ForeColor = GlobalCode.Field2String(n["ForeColor"]), IsMedical = GlobalCode.Field2Bool(n["IsMedical"]), CancellationTermsInt = GlobalCode.Field2String(n["CancellationTermsInt"]), HotelTimeZoneID = GlobalCode.Field2String(n["HotelTimeZoneID"]), CutOffTime = GlobalCode.Field2String(n["CutOffTime"]), IsConfirmed = GlobalCode.Field2String(n["IsConfirmed"]), Address = GlobalCode.Field2String(n["Address"]), ContactNo = GlobalCode.Field2String(n["ContactNo"]), Breakfast = GlobalCode.Field2Bool(n["colBreakfastBit"]), IsBilledToCrew = GlobalCode.Field2Bool(n["colIsBilledToCrewBit"]), Lunch = GlobalCode.Field2Bool(n["colLunchBit"]), Dinner = GlobalCode.Field2Bool(n["colDinnerBit"]), LunchOrDinner = GlobalCode.Field2Bool(n["colLunchOrDinnerBit"]), WithShuttle = GlobalCode.Field2Bool(n["colWithShuttleBit"]), VendorName = GlobalCode.Field2String(n["VendorName"]), IsPortAgent = GlobalCode.Field2Bool(n["IsPortAgent"]), }).ToList(), VehicleTransactionMedical = (from n in ds.Tables[4].AsEnumerable() select new VehicleTransactionMedical { TransVehicleID = GlobalCode.Field2Long(n["colTransVehicleIDBigint"]), SeafarerID = GlobalCode.Field2Long(n["colSeafarerIDBigint"]), IdBigint = GlobalCode.Field2Long(n["colIdBigint"]), TravelReqID = GlobalCode.Field2Long(n["colTravelReqIDInt"]), RecordLocator = GlobalCode.Field2String(n["colRecordLocatorVarchar"]), TranspoVendorID = GlobalCode.Field2Long(n["colTranspoVendorIDInt"]), VehiclePlateNo = GlobalCode.Field2String(n["colVehiclePlateNoVarchar"]), PickUpDate = GlobalCode.Field2DateTime(n["colPickUpDate"]), PickUpTime = GlobalCode.Field2DateTime(n["colPickUpTime"]), DropOffDate = GlobalCode.Field2DateTime(n["colDropOffDate"]), DropOffTime = GlobalCode.Field2DateTime(n["colDropOffTime"]), ConfirmationNo = GlobalCode.Field2String(n["colConfirmationNoVarchar"]), VehicleStatus = GlobalCode.Field2String(n["colVehicleStatusVarchar"]), VehicleTypeId = GlobalCode.Field2Int(n["colVehicleTypeIdInt"]), SFStatus = GlobalCode.Field2String(n["colSFStatus"]), RouteIDFrom = GlobalCode.Field2Int(n["colRouteIDFromInt"]), RouteIDTo = GlobalCode.Field2Int(n["colRouteIDToInt"]), From = GlobalCode.Field2String(n["colFromVarchar"]), To = GlobalCode.Field2String(n["colToVarchar"]), DateCreated = GlobalCode.Field2DateTime(n["colDateCreatedDatetime"]), DateModified = GlobalCode.Field2DateTime(n["colDateModifiedDatetime"]), CreatedBy = GlobalCode.Field2String(n["colCreatedByVarchar"]), Modifiedby = GlobalCode.Field2String(n["colModifiedbyVarchar"]), IsActive = GlobalCode.Field2Bool(n["colIsActiveBit"]), RemarksForAudit = GlobalCode.Field2String(n["colRemarksForAuditVarchar"]), HotelID = GlobalCode.Field2Int(n["colHotelIDInt"]), IsVisible = GlobalCode.Field2Bool(n["colIsVisibleBit"]), ContractId = GlobalCode.Field2Int(n["colContractIdInt"]), IsSeaport = GlobalCode.Field2Bool(n["colIsSeaportBit"]), SeqNo = GlobalCode.Field2Int(n["colSeqNoInt"]), Driver = GlobalCode.Field2String(n["colDriverVarchar"]), VehicleDispatchTime = GlobalCode.Field2String(n["colVehicleDispatchTime"]), RouteFrom = GlobalCode.Field2String(n["colRouteFromVarchar"]), RouteTo = GlobalCode.Field2String(n["colRouteToVarchar"]), VehicleUnset = GlobalCode.Field2Bool(n["colVehicleUnset"]), VehicleUnsetBy = GlobalCode.Field2String(n["colVehicleUnsetBy"]), VehicleUnsetDate = GlobalCode.Field2DateTime(n["colVehicleUnsetDate"]), ConfirmBy = GlobalCode.Field2String(n["colConfirmByVarchar"]), Comments = GlobalCode.Field2String(n["colCommentsVarchar"]), ContractedRateMoney = GlobalCode.Field2Double(n["colContractedRateMoney"]), ConfirmRateMoney = GlobalCode.Field2Double(n["colConfirmRateMoney"]), CurrencyInt = GlobalCode.Field2Int(n["colCurrencyInt"]), StatusID = GlobalCode.Field2TinyInt(n["colStatusIDTinyint"]), ApprovedBy = GlobalCode.Field2String(n["colApprovedByVarchar"]), ApprovedDate = GlobalCode.Field2DateTime(n["colApprovedDate"]), EmailTo = GlobalCode.Field2String(n["colEmailTovarchar"]), RequestSourceID = GlobalCode.Field2TinyInt(n["colRequestSourceIDInt"]), TransportationDetails = GlobalCode.Field2String(n["colTransportationDetails"]), IsPortAgent = GlobalCode.Field2Bool(n["colIsPortAgentBit"]), VehicleVendor = GlobalCode.Field2String(n["VendorName"]), ColorCode = GlobalCode.Field2String(n["ColorCode"]), ForeColor = GlobalCode.Field2String(n["ForeColor"]), }).ToList() }).ToList()); } } } catch (Exception ex) { throw ex; } finally { if (ds != null) { ds.Dispose(); } } return(SeafarerInfo); }