/// <summary>
/// Date Created: 30/09/2011
/// Created By: Josephine Gad
/// (description) Get vessel list
/// ---------------------------------------------------------------------------
/// </summary>
private void GetVessel()
{
DataTable VesselDataTable = null;
try
{
VesselDataTable = VesselBLL.GetVessel(uoHiddenFieldUser.Value, uoHiddenFieldDate.Value,
uoHiddenFieldDate.Value, GlobalCode.Field2String(Session["Region"]), GlobalCode.Field2String(Session["Country"]),
GlobalCode.Field2String(Session["City"]), GlobalCode.Field2String(Session["Port"]), uoHiddenFieldUserRole.Value);
uoDropDownListVessel.Items.Clear();
ListItem item = new ListItem("--Select Ship--", "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>
/// Date Created: 05/10/2011
/// Created By: Josephine Gad
/// (description) Get vessel details by Vessel ID
/// ---------------------------------------------
/// Date Modified: 28/11/2011
/// Modified By: Charlene Remotigue
/// (description) optimization (use datareader instead of datatable
/// </summary>
public void GetVesselDetails()
{
IDataReader dr = null;
try
{
dr = VesselBLL.GetVesselPortDetails(uoDropDownListVessel.SelectedValue,
uoTextBoxDate.Text, uoTextBoxDate.Text);
if (dr.Read())
{
uoTextBoxPort.Text = dr["PortName"].ToString();
//uoTextBoxCity.Text = dr["CityName"].ToString();
uoTextBoxCountry.Text = dr["CountryName"].ToString();
uoHiddenFieldPortID.Value = dr["PortID"].ToString();
// uoHiddenFieldCityID.Value = dr["CityID"].ToString();
uoHiddenFieldCountryID.Value = dr["CountryID"].ToString();
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dr != null)
{
dr.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>
/// Date Created: 04/10/2011
/// Created By: Josephine Gad
/// (description) Get Vessel list
/// ---------------------------------------------
/// Date Modified: 14/02/2011
/// Modified By: Josephine Gad
/// (description) Use class VesselDTOList.VesselList instead of calling function VesselBLL.GetVessel again
/// ---------------------------------------------
/// </summary>
/// <param name="vesselID"></param>
private void GetVessel(string vesselID)
{
List <VesselDTO> vesselList = null;
try
{
//VesselDTOList.VesselList
uoDropDownListVessel.Items.Clear();
uoDropDownListVessel.Items.Add(new ListItem("--SELECT SHIP--", "0"));
if (VesselDTOList.VesselList != null)
{
vesselList = VesselDTOList.VesselList;
}
else
{
vesselList = VesselBLL.GetVesselList(GlobalCode.Field2String(Session["UserName"]), uoTextBoxDate.Text,
uoTextBoxDate.Text, "0", "0", "0", "0", uoHiddenFieldRole.Value, false);
}
var listVessel = (from a in vesselList
select new
{
VesselName = a.VesselNameString,
VesselID = a.VesselIDString
}
).ToList();
uoDropDownListVessel.DataSource = listVessel;
uoDropDownListVessel.DataTextField = "VesselName";
uoDropDownListVessel.DataValueField = "VesselID";
uoDropDownListVessel.DataBind();
uoDropDownListVessel.SelectedValue = vesselID;
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (vesselList != null)
{
vesselList = null;
}
}
}
/// <summary>
/// Date Created: 30/09/2011
/// Created By: Josephine Gad
/// (description) Get vessel list
/// ---------------------------------------------------------------------------
/// </summary>
private void GetVessel()
{
//DataTable VesselDataTable = null;
List <VesselDTO> vesselList = null;
try
{
string sDateTo = GlobalCode.Field2String(Session["DateTo"]);
if (sDateTo == "")
{
sDateTo = GlobalCode.Field2DateTime(uoHiddenFieldDate.Value).AddDays(double.Parse(uoHiddenFieldDateRange.Value)).ToString("MM/dd/yyyy");
}
vesselList = VesselBLL.GetVesselList(uoHiddenFieldUser.Value, uoHiddenFieldDate.Value,
sDateTo, GlobalCode.Field2String(Session["Region"]), GlobalCode.Field2String(Session["Country"]),
GlobalCode.Field2String(Session["City"]), GlobalCode.Field2String(Session["Port"]), uoHiddenFieldRole.Value, false);
uoDropDownListVessel.Items.Clear();
ListItem item = new ListItem("--Select Ship--", "0");
uoDropDownListVessel.Items.Add(item);
var listVessel = (from a in vesselList
select new
{
VesselName = a.VesselNameString,
VesselID = a.VesselIDString
}).ToList();
uoDropDownListVessel.DataSource = listVessel;
uoDropDownListVessel.DataTextField = "VesselName";
uoDropDownListVessel.DataValueField = "VesselID";
uoDropDownListVessel.DataBind();
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (vesselList != null)
{
vesselList = null;
}
}
}
