public void Load_Vessel()
{
DataTable dt = objBLL.Get_UserVesselList_DL(0, 0, Convert.ToInt32(Session["USERCOMPANYID"].ToString()), null, Convert.ToInt32(Session["USERCOMPANYID"].ToString()), GetSessionUserID());
ddlVessel.DataSource = dt;
ddlVessel.DataTextField = "Vessel_Name";
ddlVessel.DataValueField = "Vessel_ID";
ddlVessel.DataBind();
ddlVessel.Items.Insert(0, new ListItem("-Select-", "0"));
}
/// <summary>
/// Fill Dropdown of Delivery Port and Vessel.
/// </summary>
protected void FillDDL()
{
try
{
BLL_Infra_VesselLib objVsl = new BLL_Infra_VesselLib();
DataTable dtVessel = objVsl.Get_UserVesselList_DL(0, 0, Convert.ToInt32(Session["USERCOMPANYID"].ToString()), "", Convert.ToInt32(Session["USERCOMPANYID"].ToString()), UDFLib.ConvertToInteger(GetSessionUserID()));
ddlVessel.DataSource = dtVessel;
ddlVessel.DataTextField = "Vessel_name";
ddlVessel.DataValueField = "Vessel_id";
ddlVessel.DataBind();
ddlVessel.Items.Insert(0, new ListItem("-SELECT-", "0"));
using (BLL_PURC_Purchase objTechService = new BLL_PURC_Purchase())
{
DataTable dtPort = objTechService.getDeliveryPort();
ddlDeliveryPort.DataSource = dtPort;
ddlDeliveryPort.DataTextField = "Port_Name";
ddlDeliveryPort.DataValueField = "Id";
ddlDeliveryPort.DataBind();
ddlDeliveryPort.Items.Insert(0, new ListItem("-SELECT-", "0"));
}
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
}
finally
{
}
}
protected void chkAssignement_CheckedChanged(object sender, EventArgs e)
{
try
{
ddlVessel.Items.Clear();
BLL_Infra_VesselLib objVsl = new BLL_Infra_VesselLib();
DataTable dtVessel = new DataTable();
if (chkAssignement.Checked == true)
{
dtVessel = objVsl.Get_UserVesselList_DL(int.Parse(DDLFleet.SelectedValue.ToString()), 0, Convert.ToInt32(Session["USERCOMPANYID"].ToString()), "", Convert.ToInt32(Session["USERCOMPANYID"].ToString()), UDFLib.ConvertToInteger(GetSessionUserID()));
}
else
{
dtVessel = objVsl.Get_VesselList(int.Parse(DDLFleet.SelectedValue.ToString()), 0, Convert.ToInt32(Session["USERCOMPANYID"].ToString()), "", Convert.ToInt32(Session["USERCOMPANYID"].ToString()));
}
ddlVessel.DataSource = dtVessel;
ddlVessel.DataTextField = "Vessel_name";
ddlVessel.DataValueField = "Vessel_id";
ddlVessel.DataBind();
BindPortCall(UDFLib.ConvertIntegerToNull(ddlVessel.SelectedValue));
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
}
}
/// <summary>
/// Fill Vessel according to selected fleet
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void DDLFleet_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
ddlVessel.Items.Clear();
BLL_Infra_VesselLib objVsl = new BLL_Infra_VesselLib();
DataTable dtVessel = new DataTable();
if (chkAssignement.Checked == true)
{
dtVessel = objVsl.Get_UserVesselList_DL(int.Parse(DDLFleet.SelectedValue.ToString()), 0, Convert.ToInt32(Session["USERCOMPANYID"].ToString()), "", Convert.ToInt32(Session["USERCOMPANYID"].ToString()), UDFLib.ConvertToInteger(GetSessionUserID()));
}
else
{
dtVessel = objVsl.Get_VesselList(int.Parse(DDLFleet.SelectedValue.ToString()), 0, Convert.ToInt32(Session["USERCOMPANYID"].ToString()), "", Convert.ToInt32(Session["USERCOMPANYID"].ToString()));
}
if (dtVessel.Rows.Count > 0)
{
ddlVessel.DataSource = dtVessel;
ddlVessel.DataTextField = "Vessel_name";
ddlVessel.DataValueField = "Vessel_id";
ddlVessel.DataBind();
}
else
{
ddlVessel.Items.Insert(0, new ListItem("-SELECT-", "0"));
}
BindPortCall(UDFLib.ConvertIntegerToNull(ddlVessel.SelectedValue));
// Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "CheckValidation()", true);
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
}
finally
{
}
}
/// <summary>
/// Fill DropDownList ,Fleet,POType,AccountType,OwnerName,Urgency,DeliveryPort,ReqsnType,Vessel
/// </summary>
public void FillDDL()
{
try
{
BLL_Infra_VesselLib objVsl = new BLL_Infra_VesselLib();
DataTable FleetDT = objVsl.GetFleetList(Convert.ToInt32(Session["USERCOMPANYID"].ToString()));
DDLFleet.DataSource = FleetDT;
DDLFleet.DataTextField = "Name";
DDLFleet.DataValueField = "Code";
DDLFleet.DataBind();
DDLFleet.Items.Insert(0, new ListItem("-SELECT-", "0"));
DataTable dt = BLL_PURC_Common.PURC_Get_PO_Type(UDFLib.ConvertToInteger(GetSessionUserID()), "PO_Create");
ddlPOType.DataSource = dt;
ddlPOType.DataTextField = "PO_Type";
ddlPOType.DataValueField = "PO_Code";
ddlPOType.DataBind();
ddlPOType.Items.Insert(0, new ListItem("-SELECT-", "0"));
DataTable dtAccountType = BLL_PURC_Common.PURC_Get_Sys_Variable(UDFLib.ConvertToInteger(GetSessionUserID()), "Account_Type");
ddlAccountType.DataSource = dtAccountType;
ddlAccountType.DataTextField = "VARIABLE_NAME";
ddlAccountType.DataValueField = "VARIABLE_CODE";
ddlAccountType.DataBind();
ddlAccountType.Items.Insert(0, new ListItem("-SELECT-", "0"));
DataTable dtOwnerName = BLL_PURC_Common.PURC_Get_Supplier_Type(UDFLib.ConvertToInteger(GetSessionUserID()), "OWNER");
ddlOwnerName.DataSource = dtOwnerName;
ddlOwnerName.DataTextField = "Supplier_Name";
ddlOwnerName.DataValueField = "Supplier_Code";
ddlOwnerName.DataBind();
ddlOwnerName.Items.Insert(0, new ListItem("-SELECT-", "0"));
DataTable dtItem = BLL_PURC_Common.PURC_Get_ItemCategory(UDFLib.ConvertToInteger(GetSessionUserID()), "UrgencyLevel");
ddlUrgency.DataTextField = "Category_Name";
ddlUrgency.DataValueField = "ID";
ddlUrgency.DataSource = dtItem;
ddlUrgency.DataBind();
using (BLL_PURC_Purchase objTechService = new BLL_PURC_Purchase())
{
//DataTable dtPort = objTechService.LibraryGetSystemParameterList("7609", "");
DataTable dtPort = objTechService.getDeliveryPort();
ddlDeliveryPort.DataSource = dtPort;
ddlDeliveryPort.DataTextField = "Port_Name";
ddlDeliveryPort.DataValueField = "Id";
ddlDeliveryPort.DataBind();
ddlDeliveryPort.Items.Insert(0, new ListItem("-SELECT-", "0"));
}
ddlReqsnType.Items.Insert(0, new ListItem("-SELECT-", "0"));
ddlFunction.Items.Insert(0, new ListItem("-SELECT-", "0"));
ddlCatalogue.Items.Insert(0, new ListItem("-SELECT-", "0"));
ddlPortCall.Items.Insert(0, new ListItem("-SELECT-", "0"));
DataTable dtVessel = objVsl.Get_UserVesselList_DL(0, 0, Convert.ToInt32(Session["USERCOMPANYID"].ToString()), "", Convert.ToInt32(Session["USERCOMPANYID"].ToString()), UDFLib.ConvertToInteger(GetSessionUserID()));
if (DDLFleet.SelectedIndex != 0)
{
dtVessel.DefaultView.RowFilter = "Tech_Manager ='" + DDLFleet.SelectedItem.Text + "'";
}
ddlVessel.DataSource = dtVessel;
ddlVessel.DataTextField = "Vessel_name";
ddlVessel.DataValueField = "Vessel_id";
ddlVessel.DataBind();
BindPortCall(UDFLib.ConvertIntegerToNull(ddlVessel.SelectedValue));
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
}
finally
{
}
}
