/// <summary>
/// Author: Josephine Gad
/// Date Created: 25/Oct/2013
/// Descrption: Cancel or Activate Service Request
/// =============================================================
/// </summary>
public void CancelActivateServiceRequest(string sUserName, string sDescription, string sFunction, string sFilename,
string sGMTDate, DataTable dtServiceRequest)
{
Database db = ConnectionSetting.GetConnection(); // DatabaseFactory.CreateDatabase()
DbCommand dbCommand = null;
DbConnection connection = db.CreateConnection();
connection.Open();
DbTransaction trans = connection.BeginTransaction();
try
{
string strTimeZone = TimeZone.CurrentTimeZone.StandardName.ToString();
dbCommand = db.GetStoredProcCommand("uspCancelServiceRequest");
db.AddInParameter(dbCommand, "@pUserId", DbType.String, sUserName);
db.AddInParameter(dbCommand, "@pDescription", DbType.String, sDescription);
db.AddInParameter(dbCommand, "@pFunction", DbType.String, sFunction);
db.AddInParameter(dbCommand, "@pFilename", DbType.String, sFilename);
db.AddInParameter(dbCommand, "@pTimezone", DbType.String, strTimeZone);
db.AddInParameter(dbCommand, "@pGMTDATE", DbType.Date, GlobalCode.Field2Date(sGMTDate));
db.AddInParameter(dbCommand, "@pCreateDate", DbType.DateTime, DateTime.Now);
SqlParameter param = new SqlParameter("@pTblTempServiceRequest", dtServiceRequest);
param.Direction = ParameterDirection.Input;
param.SqlDbType = SqlDbType.Structured;
dbCommand.Parameters.Add(param);
db.ExecuteNonQuery(dbCommand, trans);
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw ex;
}
finally
{
if (connection != null)
{
connection.Close();
connection.Dispose();
}
if (dtServiceRequest != null)
{
dtServiceRequest.Dispose();
}
}
}
protected void uoListViewManifest_ItemCommand(object sender, ListViewCommandEventArgs e)
{
if (e.CommandName == "Select")
{
HiddenField uoHiddenFieldManifestTypeID = (HiddenField)e.Item.FindControl("uoHiddenFieldManifestTypeID");
HiddenField uoHiddenFieldBranchID = (HiddenField)e.Item.FindControl("uoHiddenFieldBranchID");
Label uoLabelDate = (Label)e.Item.FindControl("uoLabelDate");
int iManifestTypeID = GlobalCode.Field2Int(uoHiddenFieldManifestTypeID.Value);
int iBranchID = GlobalCode.Field2Int(uoHiddenFieldBranchID.Value);
string sDate = GlobalCode.Field2Date(uoLabelDate.Text);
Session["ManifestHrs"] = iManifestTypeID;
Session["Hotel"] = iBranchID;
Session["DateFrom"] = sDate;
string URLString = "HotelManifest3.aspx?ufn=" + Request.QueryString["ufn"] + "&dt=" + sDate + "&chDate=1";
Response.Redirect(URLString);
}
}
/// <summary>
/// Date Created: 14/Jan/2015
/// Created By: Josephine Monteza
/// (description) get list of calendar for room needed per day, hotel as column
/// ---------------------------------------------------------------
/// </summary>
public DataTable GetCalendarRoomNeeded_Forecast(string UserId, DateTime Date, string sDateTo,
Int32 RegionID, Int32 PortID, Int32 BranchID)
{
Database db = ConnectionSetting.GetConnection(); // DatabaseFactory.CreateDatabase();
DbCommand dbCommand = null;
DataTable Calendar = null;
try
{
dbCommand = db.GetStoredProcCommand("uspSelectCalendarRoomCount_Forecast");
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, "@pBranchID", DbType.Int32, BranchID);
if (sDateTo != "")
{
db.AddInParameter(dbCommand, "@pDateTo", DbType.DateTime, GlobalCode.Field2Date(sDateTo));
}
Calendar = db.ExecuteDataSet(dbCommand).Tables[0];
return(Calendar);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dbCommand != null)
{
dbCommand.Dispose();
}
if (Calendar != null)
{
Calendar.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();
}
}
}
/// <summary>
/// Date Created: 07/11/2012
/// Created By: Josephine Gad
/// (description) get list of calendar for room needed per day
/// ---------------------------------------------------------------
/// Date Modified: 04/Feb/2013
/// Modified By: Josephine Gad
/// (description) Add Contract Room Count, Override, Total and Emergency room counts
/// ---------------------------------------------------------------
///
/// </summary>
public List <CalendarRoomNeeded> GetCalendarRoomNeeded(string UserId, DateTime Date, string sDateTo,
Int32 RegionID, Int32 PortID, Int32 BranchID)
{
Database db = ConnectionSetting.GetConnection(); // DatabaseFactory.CreateDatabase();
DbCommand dbCommand = null;
DataTable Calendar = null;
try
{
dbCommand = db.GetStoredProcCommand("uspSelectCalendarRoomCount");
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, "@pBranchID", DbType.Int32, BranchID);
if (sDateTo != "")
{
db.AddInParameter(dbCommand, "@pDateTo", DbType.DateTime, GlobalCode.Field2Date(sDateTo));
}
Calendar = db.ExecuteDataSet(dbCommand).Tables[0];
List <CalendarRoomNeeded> list = new List <CalendarRoomNeeded>();
list = (from a in Calendar.AsEnumerable()
select new CalendarRoomNeeded
{
colDate = GlobalCode.Field2DateTime(a["colDate"]),
sDate = GlobalCode.Field2String(a["sDate"]),
SingleCount = GlobalCode.Field2Int(a["SingleCount"]),
DoubleCount = GlobalCode.Field2Int(a["DoubleCount"]),
TotalNeededRoom = GlobalCode.Field2Int(a["TotalNeededRoom"]),
//ContractRoomSingle = GlobalCode.Field2Int(a["ContractRoomSingle"]),
//ContractRoomDouble = GlobalCode.Field2Int(a["ContractRoomDouble"]),
TotalContractRoom = GlobalCode.Field2Int(a["TotalContractRoom"]),
//OverrideRoomSingle = GlobalCode.Field2Int(a["OverrideRoomSingle"]),
//OverrideRoomDouble = GlobalCode.Field2Int(a["OverrideRoomDouble"]),
TotalOverrideRoom = GlobalCode.Field2Int(a["TotalOverrideRoom"]),
//TotalRoomsSingle = GlobalCode.Field2Int(a["TotalRoomsSingle"]),
//TotalRoomDouble = GlobalCode.Field2Int(a["TotalRoomDouble"]),
TotalRoom = GlobalCode.Field2Int(a["TotalRoom"]),
//EmergencyRoomSingle = GlobalCode.Field2Int(a["EmergencyRoomSingle"]),
//EmergencyRoomDouble = GlobalCode.Field2Int(a["EmergencyRoomDouble"]),
//TotalEmergencyRoom = GlobalCode.Field2Int(a["TotalEmergencyRoom"]),
}).ToList();
return(list);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dbCommand != null)
{
dbCommand.Dispose();
}
if (Calendar != null)
{
Calendar.Dispose();
}
}
}
/// <summary>
/// Date Created: 27/Nov/2012
/// Created By: Josephine Gad
/// (description) Get users menu by UserName using session
/// ----------------------------------------------------------------
/// Date Modified: 25/Apr/2013
/// Modified By: Josephine Gad
/// (description) Change Hotel Vendor's Page to HotelConfirmManifest.aspx Page
/// ----------------------------------------------------------------
/// Date Modified: 7/May/2013
/// Modified By: Marco Abejar
/// (description) Change Crew Assist Page to HotelDashboardRoomType5.aspx Page
///----------------------------------------------
/// Date Modified: 07/Mar/2014
/// Modified By: Josephine Gad
/// (description) Change class of menu if Service Provider
///----------------------------------------------
/// </summary>
private void BindMenu()
{
string URLString = "";
string MenuString = "";
string UserName = GlobalCode.Field2String(Session["UserName"]); //MUser.GetUserName();
string UserRole = GlobalCode.Field2String(Session["UserRole"]);; //MUser.GetUserRole();
if (Session["UserMenu"] == null)
{
if (Request.QueryString["ufn"] != null)
{
Session["DateFrom"] = Request.QueryString["dt"];
URLString = "?ufn=" + Request.QueryString["ufn"] + "&dt=" + Request.QueryString["dt"]; //gelo
}
MenuString = "<ul id =\"nav\">";
if (UserRole == TravelMartVariable.RoleAdministrator)
{
MenuString += "<li><a runat=\"server\" id=\"uoAHome\" href=\"../HotelDashboardRoomType5.aspx" + URLString + "\">Home</a></li>";
}
else if (UserRole == TravelMartVariable.RoleHotelSpecialist)
{
MenuString += "<li><a runat=\"server\" id=\"uoAHome\" href=\"../HotelDashboardRoomType5.aspx" + URLString + "\">Home</a></li>";
}
else if (UserRole == TravelMartVariable.RolePortSpecialist)
{
MenuString += "<li><a runat=\"server\" id=\"uoAHome\" href=\"../PortAgent/PortAgentDashboard.aspx" + URLString + "\">Home</a></li>";
}
else if (UserRole == TravelMartVariable.RoleMeetGreet)
{
MenuString += "<li><a runat=\"server\" id=\"uoAHome\" href=\"../MeetAndGreet/MeetAndGreet.aspx" + URLString + "\">Home</a></li>";
}
else if (UserRole == TravelMartVariable.RoleCrewAdmin)
{
MenuString += "<li><a runat=\"server\" id=\"uoAHome\" href=\"../CrewAdmin/CrewAdmin.aspx" + URLString + "\">Home</a></li>";
}
else if (UserRole == TravelMartVariable.RoleHotelVendor)
{
MenuString += "<li><a runat=\"server\" id=\"uoAHome\" href=\"../Hotel/HotelConfirmManifest.aspx" + URLString + "\">Home</a></li>";
}
else if (UserRole == TravelMartVariable.RoleSystemAnalyst)
{
MenuString += "<li><a runat=\"server\" id=\"uoAHome\" href=\"../SystemAnalyst/ExceptionPNR.aspx" + URLString + "\">Home</a></li>";
}
else if (UserRole == TravelMartVariable.RoleCrewAssist || UserRole == TravelMartVariable.RoleCrewAssistTeamLead)
{
MenuString += "<li><a runat=\"server\" id=\"uoAHome\" href=\"../CrewAssist/CrewAssist.aspx" + URLString + "\">Home</a></li>";
}
else if (UserRole == TravelMartVariable.RoleVehicleVendor)
{
MenuString += "<li><a runat=\"server\" id=\"uoAHome\" href=\"../Vehicle/VehicleManifestByVendor.aspx" + URLString + "\">Home</a></li>";
}
else if (UserRole == TravelMartVariable.RoleFinance || UserRole == TravelMartVariable.RoleCrewMedical)
{
MenuString += "<li><a runat=\"server\" id=\"uoAHome\" href=\"../ManifestSearchFilterPage.aspx" + URLString + "\">Home</a></li>";
}
else if (UserRole == TravelMartVariable.RoleImmigration)
{
MenuString += "<li><a runat=\"server\" id=\"uoAHome\" href=\"../Immigration/CrewVerification.aspx" + URLString + "\">Home</a></li>";
}
else
{
MenuString += "<li><a runat=\"server\" id=\"uoAHome\" href=\"../Manifest.aspx" + URLString + "\">Home</a></li>";
}
string PageUrlString = "";
string SubMenuString = "";
string SubMenuString2 = "";
try
{
List <UserMenus> menuList = new List <UserMenus>();
List <UserSubMenus> subMenuList = new List <UserSubMenus>();
if (Session["UserMenuList"] != null)
{
menuList = (List <UserMenus>)Session["UserMenuList"];
subMenuList = (List <UserSubMenus>)Session["UserSubMenuList"];
}
else
{
menuList = UserRightsBLL.GetMenuListByUser(UserName);
subMenuList = (List <UserSubMenus>)Session["UserSubMenuList"];
}
if (menuList.Count > 0)
{
int menuMaxCount = menuList.Count;
for (int i = 0; i < menuMaxCount; i++)
{
PageUrlString = menuList[i].PageName;//MenuRow["colPageNameVarchar"].ToString();
PageUrlString = (PageUrlString == "" ? "#" : "../" + PageUrlString + URLString);
MenuString += "<li><a href=\"" + PageUrlString + "\">" + menuList[i].DisplayName + "</a>";
List <UserSubMenus> subMenuList1stLevel = new List <UserSubMenus>();
subMenuList1stLevel = (from a in subMenuList
where a.ParentIDInt == menuList[i].PageIDInt
select new UserSubMenus
{
ParentIDInt = a.ParentIDInt,
PageIDInt = a.PageIDInt,
ModuleName = a.ModuleName,
PageName = a.PageName,
DisplayName = a.DisplayName,
Sequence = a.Sequence
}).ToList();
subMenuList1stLevel = subMenuList1stLevel.OrderBy(a => a.Sequence).ToList();
if (subMenuList1stLevel.Count > 0)
{
SubMenuString = "<ul>";
for (int i1st = 0; i1st < subMenuList1stLevel.Count; i1st++)
{
PageUrlString = subMenuList1stLevel[i1st].PageName;
PageUrlString = (PageUrlString == "" ? "#" : "../" + PageUrlString + URLString);
SubMenuString += "<li><a href=\"" + PageUrlString + "\">" + subMenuList1stLevel[i1st].DisplayName + "</a>";
List <UserSubMenus> subMenuList2ndLevel = new List <UserSubMenus>();
subMenuList2ndLevel = (from a in subMenuList
where a.ParentIDInt == subMenuList1stLevel[i1st].PageIDInt
select new UserSubMenus
{
ParentIDInt = a.ParentIDInt,
PageIDInt = a.PageIDInt,
ModuleName = a.ModuleName,
PageName = a.PageName,
DisplayName = a.DisplayName,
Sequence = a.Sequence
}).ToList();
subMenuList2ndLevel = subMenuList2ndLevel.OrderBy(a => a.Sequence).ToList();
if (subMenuList2ndLevel.Count > 0)
{
SubMenuString2 = "<ul>";
for (int i2nd = 0; i2nd < subMenuList2ndLevel.Count; i2nd++)
{
PageUrlString = subMenuList2ndLevel[i2nd].PageName;
PageUrlString = (PageUrlString == "" ? "#" : "../" + PageUrlString + URLString);
SubMenuString2 += "<li><a href=\"" + PageUrlString + "\">" + subMenuList2ndLevel[i2nd].DisplayName + "</a></li>";
}
SubMenuString2 += "</ul>";
SubMenuString += SubMenuString2;
}
SubMenuString += "</li>";
}
SubMenuString += "</ul>";
MenuString += SubMenuString;
}
MenuString += "</li>";
}
}
}
catch (Exception ex)
{
throw ex;
}
if ((UserRole != TravelMartVariable.RoleFinance) && (UserRole != TravelMartVariable.RoleCrewMedical) && (UserRole != TravelMartVariable.RoleImmigration))
{
MenuString += "<li><a runat=\"server\" id=\"uoASearch\" href=\"../ManifestSearchFilter.aspx" + URLString + "\">Search</a></li>";
}
MenuString += "</ul>";
Session["UserMenu"] = MenuString;
//Store menu string in Cache for 10 minutes
//Cache.Insert("UserMenu", MenuString, null, System.Web.Caching.Cache.NoAbsoluteExpiration, TimeSpan.FromMinutes(10));
}
if (Session["CurrentDate"] == null)
{
Session["CurrentDate"] = Request.QueryString["dt"].ToString();
//Store menu string in Cache for 10 minutes
//Cache.Insert("CurrentDate", Request.QueryString["dt"].ToString(), null, System.Web.Caching.Cache.NoAbsoluteExpiration, TimeSpan.FromMinutes(10));
}
if (Session["UserMenu"] != null && Session["CurrentDate"] != null)
{
string sMenu = Session["UserMenu"].ToString();
string sDate = Session["CurrentDate"].ToString();
if (sDate == "")
{
sDate = GlobalCode.Field2Date(DateTime.Now);
}
string sDateNew = Request.QueryString["dt"].ToString();
//sDate = sDate.Replace("_", "/");
if (!sDateNew.Contains("-"))
{
sDateNew = sDateNew.Replace("_", "/");
sMenu = sMenu.Replace(sDate, sDateNew);
Session["UserMenu"] = sMenu;
Session["CurrentDate"] = sDateNew;
//Store menu string in Cache for 10 minutes
//Cache.Insert("UserMenu", sMenu, null, System.Web.Caching.Cache.NoAbsoluteExpiration, TimeSpan.FromMinutes(10));
//Store menu selected date in Cache for 10 minutes
//Cache.Insert("CurrentDate", sDateNew, null, System.Web.Caching.Cache.NoAbsoluteExpiration, TimeSpan.FromMinutes(10));
}
}
MenuString = GlobalCode.Field2String(Session["UserMenu"]);
ucLiteralMenu.Text = MenuString;
}
void GetCrewAssistHotelInformation(object obj)
{
SF = new CrewAssistBLL();
Session["ContactPerson"] = null;
Session["ContractRate"] = null;
Session["HotelEmailTo"] = null;
DateTime starDate = DateTime.Now;
DateTime enddate = DateTime.Now.AddDays(1);
List <CrewAssistHotelInformation> _HotelInformationList = new List <CrewAssistHotelInformation>();
_HotelInformationList = SF.CrewAssistHotelInformation(0,
GlobalCode.Field2Int(((System.Web.UI.WebControls.ListBox)obj).SelectedValue),
"", "", starDate, 0);
uoTextContractedRate.Text = "";
uoTextBoxMealVoucher.Text = "";
uoTextBoxComfirmRate.Text = "";
CheckBoxEmail.Checked = false;
uoTextBoxEmail.Text = "";
//CheckBoxFax.Checked = false;
//CheckBoxFax.Text = "Fax : ";
//CheckBoxCopycrewassist.Checked = false;
//CheckBoxCopycrewhotels.Checked = false;
//if (uoTextBoxStatus.Text.ToString() == "ON")
//{
// if (uoHiddenFieldRequestDate.Value == "")
// {
// starDate = GlobalCode.Field2DateTime(GlobalCode.Field2DateTime(uoHiddenFieldRequestDate.Value));
// enddate = GlobalCode.Field2DateTime(GlobalCode.Field2DateTime(uoHiddenFieldRequestDate.Value).AddDays(+1));
// }
// else
// {
// starDate = GlobalCode.Field2DateTime(GlobalCode.Field2DateTime(uoHiddenFieldRequestDate.Value).AddDays(-1));
// enddate = GlobalCode.Field2DateTime(uoHiddenFieldRequestDate.Value);
// }
//}
//else
//{
// if (uoHiddenFieldRequestDate.Value == "")
// {
// starDate = GlobalCode.Field2DateTime(GlobalCode.Field2DateTime(uoHiddenFieldRequestDate.Value));
// enddate = GlobalCode.Field2DateTime(GlobalCode.Field2DateTime(uoHiddenFieldRequestDate.Value).AddDays(+1));
// }
// else
// {
// enddate = GlobalCode.Field2DateTime(GlobalCode.Field2DateTime(uoHiddenFieldRequestDate.Value).AddDays(+1));
// starDate = GlobalCode.Field2DateTime(uoHiddenFieldRequestDate.Value);
// }
//}
uoTextBoxCheckinDate.Text = GlobalCode.Field2Date(starDate);
uoTextBoxCheckoutDate.Text = GlobalCode.Field2Date(enddate);
uoTextBoxDuration.Text = "1";
uoTxtBoxTimeOut.Text = DateTime.Now.Hour.ToString() + ":00";
uoTxtBoxTimeIn.Text = DateTime.Now.Hour.ToString() + ":00";
uoDropDownListCurrency.SelectedIndex = GlobalCode.GetselectedIndex(uoDropDownListCurrency, _HotelInformationList[0].CurrencyID);
if (_HotelInformationList.Count > 0)
{
//uoLabelAdress.Text = _HotelInformationList[0].Address;
//uoLabelTelephone.Text = _HotelInformationList[0].ContactNo;
uoHiddenFieldCityCode.Value = _HotelInformationList[0].CityCode;
uoTextContractedRate.Text = _HotelInformationList[0].ContractedRate;
uoTextBoxMealVoucher.Text = _HotelInformationList[0].MealVoucher;
uoTextBoxComfirmRate.Text = _HotelInformationList[0].ContractRoomRateTaxPercentage;
uoTextBoxEmail.Text = _HotelInformationList[0].EmailTo;
//CheckBoxFax.Text = "Fax : " + _HotelInformationList[0].FaxNo;
//TextBoxWhoConfirm.Text = _HotelInformationList[0].ContactPerson;
if (uoTextBoxEmail.Text.ToString().Length > 0)
{
CheckBoxEmail.Checked = true;
uoTextBoxEmail.Enabled = true;
}
uoCheckboxBreakfast.Checked = _HotelInformationList[0].IsBreakfast;
uoCheckboxLunch.Checked = _HotelInformationList[0].IsLunch;
uoCheckboxDinner.Checked = _HotelInformationList[0].IsDinner;
uoCheckBoxIsWithShuttle.Checked = _HotelInformationList[0].IsWithShuttle;
//if (_HotelInformationList[0].ATTEMail.Count > 0)
//{
// uoHiddenFieldHotelEmail.Value = _HotelInformationList[0].ATTEMail[0].Email;
//}
Session["ContactPerson"] = _HotelInformationList[0].ContactPerson;
Session["ContractRate"] = _HotelInformationList[0].ContractedRate;
Session["HotelEmailTo"] = _HotelInformationList[0].EmailTo;
uoHiddenFieldContractStart.Value = _HotelInformationList[0].ContractDateStarted;
uoHiddenFieldContractEnd.Value = _HotelInformationList[0].ContractDateEnd;
uoDropDownListRoomeType.SelectedValue = GlobalCode.Field2String(_HotelInformationList[0].RoomTypeID);
}
//ScriptManager.RegisterStartupScript(Page, GetType(), "key", "HighLightTab();", true);
}
void GetCrewAssistPAHotelInformation(long ID)
{
try
{
uoHiddenFieldContractStart.Value = "";
uoHiddenFieldContractEnd.Value = "";
SF = new CrewAssistBLL();
Session["ContactPerson"] = null;
Session["ContractRate"] = null;
Session["HotelEmailTo"] = null;
DateTime starDate = DateTime.Now;
DateTime enddate = DateTime.Now;
List <CrewAssistHotelInformation> _HotelInformationList = new List <CrewAssistHotelInformation>();
_HotelInformationList = SF.GetPortAgentHotelVendor(0, ID,
0,
0, "");
uoTextContractedRate.Text = "";
uoTextBoxMealVoucher.Text = "";
uoTextBoxComfirmRate.Text = "";
CheckBoxEmail.Checked = false;
uoTextBoxEmail.Text = "";
//CheckBoxFax.Checked = false;
//CheckBoxFax.Text = "Fax : ";
//CheckBoxCopycrewassist.Checked = false;
//CheckBoxCopycrewhotels.Checked = false;
//if (uoTextBoxStatus.Text.ToString() == "ON")
//{
// if (uoHiddenFieldRequestDate.Value == "")
// {
// starDate = GlobalCode.Field2DateTime(GlobalCode.Field2DateTime(uoHiddenFieldRequestDate.Value));
// enddate = GlobalCode.Field2DateTime(GlobalCode.Field2DateTime(uoHiddenFieldRequestDate.Value).AddDays(+1));
// }
// else
// {
// starDate = GlobalCode.Field2DateTime(GlobalCode.Field2DateTime(uoHiddenFieldRequestDate.Value).AddDays(-1));
// enddate = GlobalCode.Field2DateTime(uoHiddenFieldRequestDate.Value);
// }
//}
//else
//{
// if (uoHiddenFieldRequestDate.Value == "")
// {
// starDate = GlobalCode.Field2DateTime(GlobalCode.Field2DateTime(uoHiddenFieldRequestDate.Value));
// enddate = GlobalCode.Field2DateTime(GlobalCode.Field2DateTime(uoHiddenFieldRequestDate.Value).AddDays(+1));
// }
// else
// {
// enddate = GlobalCode.Field2DateTime(GlobalCode.Field2DateTime(uoHiddenFieldRequestDate.Value).AddDays(+1));
// starDate = GlobalCode.Field2DateTime(uoHiddenFieldRequestDate.Value);
// }
//}
uoTextBoxCheckinDate.Text = GlobalCode.Field2Date(starDate);
uoTextBoxCheckoutDate.Text = GlobalCode.Field2Date(enddate);
uoTextBoxDuration.Text = "1";
uoTxtBoxTimeOut.Text = DateTime.Now.Hour.ToString() + ":00";
uoTxtBoxTimeIn.Text = DateTime.Now.Hour.ToString() + ":00";
if (_HotelInformationList.Count > 0)
{
//uoLabelAdress.Text = _HotelInformationList[0].Address;
//uoLabelTelephone.Text = _HotelInformationList[0].ContactNo;
uoHiddenFieldCityCode.Value = _HotelInformationList[0].CityCode;
uoTextContractedRate.Text = _HotelInformationList[0].ContractedRate;
uoTextBoxMealVoucher.Text = _HotelInformationList[0].MealVoucher;
uoTextBoxComfirmRate.Text = _HotelInformationList[0].ContractRoomRateTaxPercentage;
uoTextBoxEmail.Text = _HotelInformationList[0].EmailTo;
//CheckBoxFax.Text = "Fax : " + _HotelInformationList[0].FaxNo;
//TextBoxWhoConfirm.Text = _HotelInformationList[0].ContactPerson;
if (uoTextBoxEmail.Text.ToString().Length > 0)
{
CheckBoxEmail.Checked = true;
uoTextBoxEmail.Enabled = true;
}
uoCheckboxBreakfast.Checked = _HotelInformationList[0].IsBreakfast;
uoCheckboxLunch.Checked = _HotelInformationList[0].IsLunch;
uoCheckboxDinner.Checked = _HotelInformationList[0].IsDinner;
uoCheckBoxIsWithShuttle.Checked = _HotelInformationList[0].IsWithShuttle;
uoDropDownListCurrency.SelectedIndex = GlobalCode.GetselectedIndex(uoDropDownListCurrency, _HotelInformationList[0].CurrencyID);
//uoHiddenFieldHotelEmail.Value = "";
//if (_HotelInformationList[0].ATTEMail.Count > 0)
//{
// uoHiddenFieldHotelEmail.Value = _HotelInformationList[0].ATTEMail[0].Email;
// Session["HotelEmailTo"] = _HotelInformationList[0].ATTEMail;
//}
Session["ContactPerson"] = _HotelInformationList[0].ContactPerson;
Session["ContractRate"] = _HotelInformationList[0].ContractedRate;
Session["HotelEmailTo"] = _HotelInformationList[0].EmailTo;
uoHiddenFieldContractStart.Value = _HotelInformationList[0].ContractDateStarted;
uoHiddenFieldContractEnd.Value = _HotelInformationList[0].ContractDateEnd;
uoDropDownListRoomeType.SelectedValue = GlobalCode.Field2String(_HotelInformationList[0].RoomTypeID);
}
}
catch (Exception ex)
{
AlertMessage("DownListPort: " + ex.Message);
}
}
/// <summary>
/// Author: Muhallidin G Wali
/// Date Created: 12/Apr/2015
/// Description: Get the hotel to confirm from Non Turn Port Page
/// </summary>
private void GetVehicleManifestToConfirm()
{
try
{
ViewState["NonTurnTransportation"] = null;
DataTable table = new DataTable();
table = CreateTableCancelled();
string dt = GlobalCode.Field2String(Request.QueryString["dt"]);
var qRecLocRow = Request.QueryString["RecLoc"];
var qTReqIDRow = Request.QueryString["TReqID"];
var qTransIDRow = Request.QueryString["TransID"];
int PortID = GlobalCode.Field2Int(Request.QueryString["pID"]);
int row = GlobalCode.Field2Int(Request.QueryString["pRow"]);
int PortAgentID = GlobalCode.Field2Int(Request.QueryString["pPAID"]);
string userID = uoHiddenFieldUser.Value;
string[] TRTableRow = null;
string[] ReclocTableRow = null;
string[] TransTableRow = null;
if (qTReqIDRow != null)
{
TRTableRow = qTReqIDRow.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
}
if (qRecLocRow != null)
{
ReclocTableRow = qRecLocRow.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
}
if (qTransIDRow != null)
{
TransTableRow = qTransIDRow.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
}
DataRow dr;
//if (TRTableRow != null)
//{
for (var i = 0; i < row; i++)
{
dr = table.NewRow();
dr["TransVehicleID"] = TransTableRow[i] == null ? 0 : GlobalCode.Field2Long(TransTableRow[i]);
dr["IDBigint"] = ReclocTableRow[i] == null ? 0 : GlobalCode.Field2Long(ReclocTableRow[i]);
dr["TravelReqID"] = TRTableRow[i] == null ? 0 : GlobalCode.Field2Long(TRTableRow[i]);
dr["SeqNoInt"] = 0;
dr["ReqDate"] = GlobalCode.Field2Time(dt);
dr["PortID"] = PortID;
dr["UserID"] = userID;
table.Rows.Add(dr);
}
PortAgentBLL PortBLL = new PortAgentBLL();
List <NonTurnportGenericList> lst = new List <NonTurnportGenericList>();
lst = PortBLL.GetPortNonTurnTransportationRequest(2, GlobalCode.Field2Time(dt), PortID, userID, table);
uoVendorDropDownList.DataSource = lst[0].NonTurnTransportation;
uoVendorDropDownList.DataTextField = "VendorName";
uoVendorDropDownList.DataValueField = "VendorID";
uoVendorDropDownList.DataBind();
uoVendorDropDownList.Items.Insert(0, new ListItem("--Select Vendor--", "0"));
uoVendorDropDownList.SelectedIndex = GlobalCode.GetselectedIndex(uoVendorDropDownList, PortAgentID);
if (lst[0].NonTurnTransportation.Count > 0)
{
var res = lst[0].NonTurnTransportation.Where(e => e.VendorID == PortAgentID).ToList();
if (res.Count > 0)
{
uoTextBoxEmailAdd.Text = res[0].Email.ToString();
}
}
uoDropDownListCurrency.DataSource = lst[0].Currency;
uoDropDownListCurrency.DataTextField = "Name";
uoDropDownListCurrency.DataValueField = "ID";
uoDropDownListCurrency.DataBind();
uoDropDownListCurrency.Items.Insert(0, new ListItem("--Select Currency--", "0"));
uoDropDownListVehicleType.DataSource = lst[0].VehicleType;
uoDropDownListVehicleType.DataTextField = "VehicleTypeName";
uoDropDownListVehicleType.DataValueField = "VehicleTypeID";
uoDropDownListVehicleType.DataBind();
uoDropDownListVehicleType.Items.Insert(0, new ListItem("--Select Vehicle Type--", "0"));
uoDropDownListRequestSource.DataSource = lst[0].Requestor;
uoDropDownListRequestSource.DataTextField = "Name";
uoDropDownListRequestSource.DataValueField = "ID";
uoDropDownListRequestSource.DataBind();
uoDropDownListRequestSource.Items.Insert(0, new ListItem("--Select Request Source--", "0"));
uoDropDownListRequestSource.SelectedIndex = 2;
ViewState["NonTurnTransportation"] = lst[0].NonTurnTransportation;
uoListviewVehicleInfo.DataSource = lst[0].PortAgentVehicleManifestList;
uoListviewVehicleInfo.DataBind();
uoButtonEmail.Text = "Cancel";
RadioButtonList1.Visible = false;
if (lst[0].PortAgentVehicleManifestList.Count > 0)
{
uoTextBoxPickupDate.Text = GlobalCode.Field2Date(lst[0].PortAgentVehicleManifestList[0].PickupDate);
uoTextBoxPickupTime.Text = GlobalCode.Field2String(lst[0].PortAgentVehicleManifestList[0].PickupTime);
uoTextBoxRateContract.Text = GlobalCode.Field2String(lst[0].PortAgentVehicleManifestList[0].RateContracted);
uoDropDownListTFrom.SelectedIndex = GlobalCode.GetselectedIndex(uoDropDownListTFrom, lst[0].PortAgentVehicleManifestList[0].RouteFromID);
uoDropDownListTTo.SelectedIndex = GlobalCode.GetselectedIndex(uoDropDownListTTo, lst[0].PortAgentVehicleManifestList[0].RouteToID);
uoDropDownListCurrency.SelectedIndex = GlobalCode.GetselectedIndex(uoDropDownListCurrency, lst[0].PortAgentVehicleManifestList[0].CurrencyID);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Author: Muhallidin G Wali
/// Date Created: 12/Apr/2015
/// Description: Get the hotel to confirm from Non Turn Port Page
/// </summary>
private void GetVehicleManifestToAdd()
{
try
{
//ViewState["NonTurnTransportation"] = null;
DataTable table = new DataTable();
table = CreateTable();
string dt = GlobalCode.Field2String(Request.QueryString["dt"]);
var qRow = Request.QueryString["qTravelReqID"];
int PortID = GlobalCode.Field2Int(Request.QueryString["pID"]);
int PortAgentID = GlobalCode.Field2Int(Request.QueryString["paID"]);
int st = GlobalCode.Field2Int(Request.QueryString["st"]);
int row = GlobalCode.Field2Int(Request.QueryString["pRow"]);
//document.getEl6ementById("uoNonTurnPageRoute").href = "../PortAgent/PortAgentVehicleEditor2.aspx?Action=Add&AddCancel=Add" +
// "&dt=" + chdate + "&qTravelReqID=" + mydata + "&pID=" + 0 + "&pRow=" + n + "&paID=" + getQuerystringData("PA") + "&st=" + getQuerystringData("st");
//document.getElementById("uoNonTurnPageRoute").click();
string userID = uoHiddenFieldUser.Value;
string[] TableRow = null;
if (qRow != null)
{
TableRow = qRow.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
}
DataRow dr;
int c1 = 0; int c2 = 1; int c3 = 2; int c4 = 3;
if (TableRow != null)
{
for (var i = 0; i < row; i++)
{
dr = table.NewRow();
dr["TransVehicleID"] = TableRow[c4];
dr["IDBigint"] = TableRow[c1];
dr["TravelReqID"] = TableRow[c2];
dr["SeqNo"] = TableRow[c3];
dr["ReqDate"] = GlobalCode.Field2Time(dt);
dr["PortID"] = PortID;
dr["UserID"] = userID;
table.Rows.Add(dr);
c1 = c1 + 4;
c2 = c2 + 4;
c3 = c3 + 4;
c4 = c4 + 4;
}
}
PortAgentBLL PortBLL = new PortAgentBLL();
List <NonTurnportGenericList> lst = new List <NonTurnportGenericList>();
lst = PortBLL.GetPortNonTurnTransportationRequest(0, GlobalCode.Field2Time(dt), PortID, PortAgentID, userID, table);
//=======================
uoVendorDropDownList.DataSource = lst[0].NonTurnTransportation;
uoVendorDropDownList.DataTextField = "VendorName";
uoVendorDropDownList.DataValueField = "VendorID";
uoVendorDropDownList.DataBind();
uoVendorDropDownList.Items.Insert(0, new ListItem("--Select Vendor--", "0"));
uoVendorDropDownList.SelectedIndex = GlobalCode.GetselectedIndex(uoVendorDropDownList, PortAgentID);
if (lst[0].NonTurnTransportation.Count > 0)
{
var res = lst[0].NonTurnTransportation.Where(e => e.VendorID == PortAgentID).ToList();
if (res.Count > 0)
{
uoTextBoxEmailAdd.Text = res[0].Email.ToString();
}
}
uoDropDownListCurrency.DataSource = lst[0].Currency;
uoDropDownListCurrency.DataTextField = "Name";
uoDropDownListCurrency.DataValueField = "ID";
uoDropDownListCurrency.DataBind();
uoDropDownListCurrency.Items.Insert(0, new ListItem("--Select Currency--", "0"));
uoDropDownListVehicleType.DataSource = lst[0].VehicleType;
uoDropDownListVehicleType.DataTextField = "VehicleTypeName";
uoDropDownListVehicleType.DataValueField = "VehicleTypeID";
uoDropDownListVehicleType.DataBind();
uoDropDownListVehicleType.Items.Insert(0, new ListItem("--Select Vehicle Type--", "0"));
uoDropDownListRequestSource.DataSource = lst[0].Requestor;
uoDropDownListRequestSource.DataTextField = "Name";
uoDropDownListRequestSource.DataValueField = "ID";
uoDropDownListRequestSource.DataBind();
uoDropDownListRequestSource.Items.Insert(0, new ListItem("--Select Request Source--", "0"));
uoDropDownListRequestSource.SelectedIndex = 2;
ViewState["NonTurnTransportation"] = lst[0].NonTurnTransportation;
uoListviewVehicleInfo.DataSource = lst[0].PortAgentVehicleManifestList;
uoListviewVehicleInfo.DataBind();
RadioButtonList1.Visible = false;
if (lst[0].PortAgentVehicleManifestList.Count > 0)
{
uoTextBoxPickupDate.Text = GlobalCode.Field2Date(lst[0].PortAgentVehicleManifestList[0].PickupDate);
uoTextBoxPickupTime.Text = GlobalCode.Field2String(lst[0].PortAgentVehicleManifestList[0].PickupTime);
uoTextBoxRateContract.Text = GlobalCode.Field2String(lst[0].PortAgentVehicleManifestList[0].RateContracted);
uoDropDownListTFrom.SelectedIndex = GlobalCode.GetselectedIndex(uoDropDownListTFrom, lst[0].PortAgentVehicleManifestList[0].RouteFromID);
uoDropDownListTTo.SelectedIndex = GlobalCode.GetselectedIndex(uoDropDownListTTo, lst[0].PortAgentVehicleManifestList[0].RouteToID);
uoDropDownListCurrency.SelectedIndex = GlobalCode.GetselectedIndex(uoDropDownListCurrency, lst[0].PortAgentVehicleManifestList[0].CurrencyID);
}
//ViewState["NonTurnTransportation"] = lst[0].NonTurnTransportation;
uoListviewVehicleInfo.DataSource = lst[0].PortAgentVehicleManifestList;
uoListviewVehicleInfo.DataBind();
}
catch
{
}
}