public void FillVesselDDL()
{
try
{
BLL_Infra_VesselLib objVsl = new BLL_Infra_VesselLib();
DataTable dtVessel = objVsl.Get_VesselList(0, 0, Convert.ToInt32(Session["USERCOMPANYID"].ToString()), "", Convert.ToInt32(Session["USERCOMPANYID"].ToString()));
DDLVessel.DataTextField = "Vessel_name";
DDLVessel.DataValueField = "Vessel_id";
DDLVessel.DataSource = dtVessel;
DDLVessel.DataBind();
DDLVessel.Items.Insert(0, new ListItem("-SELECT ALL-", "0"));
DDLVessel.SelectedIndex = 0;
DDLFromVessel.DataTextField = "Vessel_name";
DDLFromVessel.DataValueField = "Vessel_id";
DDLFromVessel.DataSource = dtVessel;
DDLFromVessel.DataBind();
DDLFromVessel.Items.Insert(0, new ListItem("-SELECT ALL-", "0"));
DDLFromVessel.SelectedIndex = 0;
}
catch (Exception ex)
{
}
}
protected void DDLFleet_SelectedIndexChanged()
{
BLL_Infra_VesselLib objVsl = new BLL_Infra_VesselLib();
StringBuilder sbFilterFlt = new StringBuilder();
string VslFilter = "";
foreach (DataRow dr in DDLFleet.SelectedValues.Rows)
{
sbFilterFlt.Append(dr[0]);
sbFilterFlt.Append(",");
}
DataTable dtVessel = objVsl.Get_VesselList(0, 0, Convert.ToInt32(Session["USERCOMPANYID"].ToString()), "", Convert.ToInt32(Session["USERCOMPANYID"].ToString()));
if (sbFilterFlt.Length > 1)
{
sbFilterFlt.Remove(sbFilterFlt.Length - 1, 1);
VslFilter = string.Format("fleetCode in (" + sbFilterFlt.ToString() + ")");
dtVessel.DefaultView.RowFilter = VslFilter;
}
DDLVessel.DataSource = dtVessel;
DDLVessel.DataTextField = "Vessel_name";
DDLVessel.DataValueField = "Vessel_id";
DDLVessel.DataBind();
Session["sVesselCode"] = DDLVessel.SelectedValues;
Session["sFleet"] = DDLFleet.SelectedValues;
}
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);
}
}
protected void btnViewAssignment_Click(object s, EventArgs e)
{
try
{
btnSplitItems_Click(null, null);
if ((chkVesselList.Items.Cast <ListItem>().Count(li => li.Selected)) == 1)
{
BLL_Infra_VesselLib objVSL = new BLL_Infra_VesselLib();
DataTable dtVessel = objVSL.Get_VesselList(0, 0, Convert.ToInt32(Session["USERCOMPANYID"].ToString()), "", Convert.ToInt32(Session["USERCOMPANYID"].ToString()));
dtVessel.PrimaryKey = new DataColumn[] { dtVessel.Columns["Vessel_ID"] };
dtVessel.Rows.Remove(dtVessel.Rows.Find(chkVesselList.SelectedValue));
chkNotAssignedVessels.DataSource = dtVessel;
chkNotAssignedVessels.DataTextField = "Vessel_Short_Name";
chkNotAssignedVessels.DataValueField = "Vessel_ID";
chkNotAssignedVessels.DataBind();
String msgmodal = String.Format("showModal('dvCopyfromVessels',false);");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msgonFinalmodal", msgmodal, true);
}
else
{
String msgmodal = String.Format("alert('Please select only one vessel in vessel list');");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msgonFinalmodal", msgmodal, true);
}
}
catch (Exception ex)
{
lblmsg.Text = ex.Message;
}
}
protected void BindVesselList()
{
// DataTable dt = objKPI.Get_KPI_DetailGoals(-1).Tables[0];
BLL_Infra_VesselLib bll_Vessel = new BLL_Infra_VesselLib();
BLL_TMSA_KPI bll_KPI = new BLL_TMSA_KPI();
DataTable dt = bll_Vessel.GetFleetList(Convert.ToInt32(Session["USERCOMPANYID"].ToString()));
dt.Columns.Remove("code");
dt.Columns.Remove("name");
dt.Columns.Remove("fleetname");
dt.Columns.Remove("Super_MailID");
dt.Columns.Remove("TechTeam_MailID");
dt.Columns.Remove("Vessel_Owner");
dt.Columns.Remove("Vessel_Manager");
DataTable dtable = bll_KPI.Get_Fleet_Vessel_List(dt, 0, Convert.ToInt32(Session["USERCOMPANYID"].ToString()), GetSessionUserID());
ddlvessel.DataSource = dtable;
ddlvessel.DataTextField = "VESSEL_NAME";
ddlvessel.DataValueField = "VESSEL_ID";
ddlvessel.DataBind();
ddlvessel.Items.Insert(0, new ListItem("--Select--", "0"));
if (dtable != null && dtable.Rows.Count > 0)
{
ddlvessel.SelectedIndex = 1;
hiddenVessel.Value = "1";
}
}
protected 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();
DataTable dtVessel = objVsl.Get_VesselList(0, 0, Convert.ToInt32(Session["USERCOMPANYID"].ToString()), "", Convert.ToInt32(Session["USERCOMPANYID"].ToString()));
DDLVessel.DataSource = dtVessel;
DDLVessel.DataTextField = "Vessel_name";
DDLVessel.DataValueField = "Vessel_id";
DDLVessel.DataBind();
ListItem li = new ListItem("--ALL--", "0");
DDLVessel.Items.Insert(0, li);
}
catch (Exception ex)
{
//.WriteError(this.GetType().Name.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name.ToString(), ex);
}
finally
{
}
}
public void BindFleetDLL()
{
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();
if (FleetDT.Rows.Count > 0)
{
if (Session["USERFLEETID"] != null && Session["USERFLEETID"].ToString() != "0")
{
DDLFleet.SelectItems(new string[] { Session["USERFLEETID"].ToString() });
}
else
{
foreach (DataRow dr in FleetDT.Rows)
{
DDLFleet.SelectItems(new string[] { dr["code"].ToString() });
}
}
}
Session["sFleet"] = DDLFleet.SelectedValues;
}
catch (Exception ex)
{
}
}
public void BindVesselDDL()
{
try
{
BLL_Infra_VesselLib objVsl = new BLL_Infra_VesselLib();
DataTable dtVessel = objVsl.Get_VesselList(UDFLib.ConvertToInteger(DDLFleet.SelectedValue), 0, Convert.ToInt32(Session["USERCOMPANYID"].ToString()), "", Convert.ToInt32(Session["USERCOMPANYID"].ToString()));
DDLVessel.DataTextField = "Vessel_name";
DDLVessel.DataValueField = "Vessel_id";
DDLVessel.DataSource = dtVessel;
DDLVessel.DataBind();
ListItem li = new ListItem("--SELECT ALL--", "0");
DDLVessel.Items.Insert(0, li);
DDLVessel.SelectedIndex = 0;
if (Request.QueryString["Vessel_ID"] != null)
{
DDLVessel.SelectedValue = Request.QueryString["Vessel_ID"].ToString();
}
}
catch (Exception ex)
{
}
}
protected void DDLFleet_SelectedIndexChanged(object sender, EventArgs e)
{
BLL_Infra_VesselLib objVsl = new BLL_Infra_VesselLib();
if (DDLFleet.SelectedValue.ToString() == "0")
{
Session["sFleet"] = "0";
DataTable dtVessel = objVsl.Get_VesselList(0, 0, Convert.ToInt32(Session["USERCOMPANYID"].ToString()), "", Convert.ToInt32(Session["USERCOMPANYID"].ToString()));
DDLVessel.DataSource = dtVessel;
DDLVessel.DataTextField = "Vessel_name";
DDLVessel.DataValueField = "Vessel_id";
DDLVessel.DataBind();
ListItem li = new ListItem("--Select--", "0");
DDLVessel.Items.Insert(0, li);
Session["sVesselCode"] = "0";
}
else
{
Session["sFleet"] = DDLFleet.SelectedValue;
DDLVessel.Items.Clear();
DataTable dtVessel = objVsl.Get_VesselList(int.Parse(DDLFleet.SelectedValue.ToString()), 0, Convert.ToInt32(Session["USERCOMPANYID"].ToString()), "", Convert.ToInt32(Session["USERCOMPANYID"].ToString()));
//DataTable dtVessel = objVsl.GetVesselsByFleetID(int.Parse(DDLFleet.SelectedValue.ToString()));
DDLVessel.DataSource = dtVessel;
DDLVessel.DataTextField = "Vessel_name";
DDLVessel.DataValueField = "Vessel_ID";
DDLVessel.DataBind();
ListItem li = new ListItem("--Select--", "0");
DDLVessel.Items.Insert(0, li);
}
}
protected void DDLFleet_SelectedIndexChanged(object sender, EventArgs e)
{
BLL_Infra_VesselLib objVsl = new BLL_Infra_VesselLib();
ddlvessel.Items.Clear();
//DataTable dtVessel = objVsl.GetVesselsByFleetID(int.Parse(DDLFleet.SelectedValue.ToString()));
DataTable dtVessel = objVsl.Get_VesselList(UDFLib.ConvertToInteger(DDLFleet.SelectedValue), 0, Convert.ToInt32(Session["USERCOMPANYID"].ToString()), "", Convert.ToInt32(Session["USERCOMPANYID"].ToString()));
ddlvessel.DataSource = dtVessel;
ddlvessel.DataTextField = "Vessel_name";
ddlvessel.DataValueField = "Vessel_ID";
ddlvessel.DataBind();
ListItem li = new ListItem("--SELECT ALL--", "0");
ddlvessel.Items.Insert(0, li);
ViewState["sReportType"] = "NDA";
ViewState["iVesselID"] = int.Parse(ddlvessel.SelectedValue);
ViewState["iFleetID"] = DDLFleet.SelectedValue;
ViewState["iLocationID"] = int.Parse(ddllocation.SelectedValue);
ViewState["sFromDT"] = txtfrom.Text;
ViewState["sToDT"] = txtto.Text;
BindItems();
}
public void Load_VesselList()
{
if (Session["sFleet"] == null)
{
DataTable dtable = new DataTable();
dtable.Columns.Add("PKID");
BLL_Infra_VesselLib objVsl = new BLL_Infra_VesselLib();
DataTable FleetDT = objVsl.GetFleetList(Convert.ToInt32(Session["USERCOMPANYID"].ToString()));
for (int i = 0; i < FleetDT.Rows.Count; i++)
{
DataRow dr = dtable.NewRow();
dr["PKID"] = FleetDT.Rows[i]["code"].ToString();
dtable.Rows.Add(dr);
}
Session["sFleet"] = dtable;
}
DataTable dt = objPortCall.Get_PortCall_VesselList((DataTable)Session["sFleet"], 0, 0, "", Convert.ToInt32(Session["USERCOMPANYID"].ToString()));
ddlvessel.DataSource = dt;
ddlvessel.DataTextField = "VESSEL_NAME";
ddlvessel.DataValueField = "VESSEL_ID";
ddlvessel.DataBind();
ddlvessel.Items.Insert(0, new ListItem("--Select--", "0"));
}
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();
ListItem li = new ListItem("--SELECT ALL--", "0");
DDLFleet.Items.Insert(0, li);
DataTable dtVessel = objVsl.Get_VesselList(0, 0, Convert.ToInt32(Session["USERCOMPANYID"].ToString()), "", Convert.ToInt32(Session["USERCOMPANYID"].ToString()));
DDLVessel.DataSource = dtVessel;
DDLVessel.DataTextField = "Vessel_name";
DDLVessel.DataValueField = "Vessel_id";
DDLVessel.DataBind();
DDLVessel.Items.Insert(0, new ListItem("--SELECT ALL--", null));
}
catch (Exception ex)
{
}
finally
{
}
}
/// <summary>
/// Method to load fleet and vessels
/// </summary>
protected void BindVessel()
{
try
{
BLL_Infra_VesselLib bll_Vessel = new BLL_Infra_VesselLib();
BLL_TMSA_KPI bll_KPI = new BLL_TMSA_KPI();
DataTable dt = bll_Vessel.GetFleetList(Convert.ToInt32(Session["USERCOMPANYID"].ToString()));
dt.Columns.Remove("code");
dt.Columns.Remove("name");
dt.Columns.Remove("fleetname");
dt.Columns.Remove("Super_MailID");
dt.Columns.Remove("TechTeam_MailID");
dt.Columns.Remove("Vessel_Owner");
dt.Columns.Remove("Vessel_Manager");
DataTable dtable = bll_KPI.Get_Fleet_Vessel_List(dt, 0, Convert.ToInt32(Session["USERCOMPANYID"].ToString()), GetSessionUserID());
ddlVessel.DataSource = dtable;
ddlVessel.DataTextField = "Vessel_Name";
ddlVessel.DataValueField = "Vessel_Id";
ddlVessel.DataBind();
ddlVessel.Items.Insert(0, new ListItem("--Select--", "0"));
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
}
}
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();
DataTable dtVessel = objVsl.Get_VesselList(0, 0, Convert.ToInt32(Session["USERCOMPANYID"].ToString()), "", Convert.ToInt32(Session["USERCOMPANYID"].ToString()));
ddlVessel.DataSource = dtVessel;
ddlVessel.DataTextField = "Vessel_name";
ddlVessel.DataValueField = "Vessel_id";
ddlVessel.DataBind();
}
catch (Exception ex)
{
}
finally
{
}
}
protected void DDLFleet_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
BLL_Infra_VesselLib objVsl = new BLL_Infra_VesselLib();
DataTable dtVessel = objVsl.Get_VesselList(UDFLib.ConvertToInteger(DDLFleet.SelectedValue), 0, Convert.ToInt32(Session["USERCOMPANYID"].ToString()), "", Convert.ToInt32(Session["USERCOMPANYID"].ToString()));
DDLVessel.Items.Clear();
DDLVessel.DataSource = dtVessel;
DDLVessel.DataTextField = "Vessel_name";
DDLVessel.DataValueField = "Vessel_id";
DDLVessel.DataBind();
ListItem li = new ListItem("--SELECT ALL--", "0");
DDLVessel.Items.Insert(0, li);
try
{
DDLVessel.SelectedValue = Request.QueryString["Vessel_Id"].ToString();
Session["DetVessel_Id"] = Request.QueryString["Vessel_Id"].ToString();
}
catch (Exception)
{
DDLVessel.SelectedIndex = 1;
Session["DetVessel_Id"] = DDLVessel.SelectedValue;
BindSlider();
}
BindSlider();
}
catch (Exception ex)
{
}
}
public DataTable Get_VesselList()
{
BLL_Infra_VesselLib objBLL = new BLL_Infra_VesselLib();
return(objBLL.Get_VesselList(0, 0, 1, "", 1));
//return SqlHelper.ExecuteDataset(connection, CommandType.StoredProcedure, "SP_INF_Get_VesselList").Tables[0];
}
protected void Page_Load(object sender, EventArgs e)
{
if (GetSessionUserID() == 0)
{
Response.Redirect("~/account/login.aspx");
}
if (!IsPostBack)
{
ucAsyncPager1.BindMethodName = "BindNextPageJobs";
ucAsyncPager2.BindMethodName = "BindNextPageItems";
// ucAsyncLocPager.BindMethodName = "onGetLocation";
// UserAccessValidation();
BLL_Infra_VesselLib objBLLVessel = new BLL_Infra_VesselLib();
DataTable dtvsl = objBLLVessel.Get_VesselList(0, 0, UDFLib.ConvertToInteger(Session["USERCOMPANYID"]), "", UDFLib.ConvertToInteger(Session["USERCOMPANYID"]));
DDlVessel_List.DataSource = dtvsl;
DDlVessel_List.DataBind();
DDlVessel_List.Items.Insert(0, new ListItem("--SELECT VESSEL--", "0"));
// BindLocationGrid();
hdnUserID.Value = Session["userid"].ToString();
hdnCompanyID.Value = Session["USERCOMPANYID"].ToString();
hdnAppName.Value = System.Configuration.ConfigurationManager.AppSettings["APP_NAME"].ToString();
BindDeptOptList();
Session["Image"] = "";
Session["DetailsImage"] = "";
Session["ItemOperationMode"] = "";
Session["AppAttach_" + hdnItemID.Value] = "";
}
}
protected void InitialVesselBind()
{
BLL_Infra_VesselLib objBLL = new BLL_Infra_VesselLib();
int UserCompanyID = UDFLib.ConvertToInteger(Session["USERCOMPANYID"].ToString());
if (Session["sFleet"] == null)
{
DataTable FleetDT = objBLL.GetFleetList(UserCompanyID);
FleetDT.Columns.RemoveAt(1);
FleetDT.Columns.RemoveAt(1);
FleetDT.Columns.RemoveAt(1);
FleetDT.Columns.RemoveAt(1);
FleetDT.Columns.RemoveAt(1);
FleetDT.Columns.RemoveAt(1);
FleetDT.Columns.RemoveAt(1);
Session["sFleet"] = FleetDT;
}
DataTable dt = objPortCall.Get_PortCall_VesselList((DataTable)Session["sFleet"], 0, 0, "", UserCompanyID);
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
{
}
}
public void FillDDLSupplier()
{
try
{
using (BLL_PURC_Purchase objTechService = new BLL_PURC_Purchase())
{
BLL_Infra_VesselLib objVsl = new BLL_Infra_VesselLib();
string ReqCode = "";
//if (!string.IsNullOrEmpty(Session["AttRequistionCode"].ToString()))
//{
// ReqCode = Session["AttRequistionCode"].ToString();
//}
DataSet SupplDs = objTechService.GetSuupplierHavingAttachment(ReqCode);
DDLSupplier.DataSource = SupplDs.Tables[0];
DDLSupplier.DataTextField = "SHORT_NAME";
DDLSupplier.DataValueField = "SUPPLIER";
DDLSupplier.DataBind();
DataTable CatDt = objTechService.GetCategory_FileType();
DDLCategory.DataSource = CatDt;
DDLCategory.DataTextField = "Description";
DDLCategory.DataValueField = "code";
DDLCategory.DataBind();
}
}
catch (Exception ex)
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
UserAccessValidation();
BindFleetDLL();
DDLFleet.SelectedValue = Session["USERFLEETID"].ToString();
BindVesselDDL();
BLL_Infra_VesselLib objVessel = new BLL_Infra_VesselLib();
ViewState["iVesselID"] = ddlvessel.SelectedValue;
ViewState["iLocationID"] = "0";
ViewState["sFromDT"] = DateTime.Now.AddDays(-5).ToString("dd/MM/yyyy");
ViewState["sToDT"] = DateTime.Now.ToString("dd/MM/yyyy");
ViewState["iFleetID"] = DDLFleet.SelectedValue;
txtfrom.Text = DateTime.Now.AddDays(-5).ToString("dd/MM/yyyy");
txtto.Text = DateTime.Now.ToString("dd/MM/yyyy");
BindItems();
}
// Bind("NDA",0,0);
}
protected void BindCombos()
{
JRA_Lib lObjWC = new JRA_Lib();
lObjWC.Work_Categ_Parent_ID = null;
lObjWC.Mode = 0;
DataTable dt = BLL_JRA_Work_Category.JRA_GET_WORK_CATEGORY_LIST(lObjWC);
DataView dv = dt.DefaultView;
DataTable dtCloned = dt.Clone();
dtCloned.Columns["Work_Categ_Value"].DataType = typeof(float);
foreach (DataRow row in dt.Rows)
{
dtCloned.ImportRow(row);
}
dv = dtCloned.DefaultView;
dv.Sort = "Work_Categ_Value";
dt = dv.ToTable();
ddlParentWorkCateg.DataSource = dt;
ddlParentWorkCateg.DataTextField = "Work_Category_Display";
ddlParentWorkCateg.DataValueField = "Work_Categ_ID";
ddlParentWorkCateg.DataBind();
ddlParentWorkCateg.Items.Insert(0, new ListItem("-SELECT ALL-", "0"));
lObjWC = new JRA_Lib();
lObjWC.Work_Categ_Parent_ID = null;
lObjWC.Mode = 3;
DataTable dtAllChilds = BLL_JRA_Work_Category.JRA_GET_WORK_CATEGORY_LIST(lObjWC);
DataTable dtAllChildsCloned = dtAllChilds.Clone();
dtAllChildsCloned.Columns["Work_Categ_Value"].DataType = typeof(float);
foreach (DataRow row in dtAllChilds.Rows)
{
dtAllChildsCloned.ImportRow(row);
}
dv = dtAllChildsCloned.DefaultView;
dv.Sort = "Work_Categ_Value";
dtAllChilds = dv.ToTable();
ddlChildWorkCateg.DataSource = dtAllChilds;
ddlChildWorkCateg.DataTextField = "Work_Category_Display";
ddlChildWorkCateg.DataValueField = "Work_Categ_ID";
ddlChildWorkCateg.DataBind();
ddlChildWorkCateg.Items.Insert(0, new ListItem("-SELECT ALL-", "0"));
BLL_Infra_VesselLib objVsl = new BLL_Infra_VesselLib();
DataTable dtVessel = objVsl.Get_VesselList(0, 0, Convert.ToInt32(Session["USERCOMPANYID"].ToString()), "", Convert.ToInt32(Session["USERCOMPANYID"].ToString()));
DDLVessel.DataSource = dtVessel;
DDLVessel.DataTextField = "Vessel_name";
DDLVessel.DataValueField = "Vessel_id";
DDLVessel.DataBind();
DDLVessel.Items.Insert(0, new ListItem("--SELECT ALL--", null));
}
protected void Page_Load(object sender, EventArgs e)
{
UserAccessValidation();
lblMessageOnSendApproval.Text = "";
lblMessageOnSendApproval.Visible = false;
//UserAccessValidation();
try
{
hdf_UserID.Value = Session["userid"].ToString();
if (!IsPostBack)
{
ListItem li = cmbFleet.Items.FindByValue(Convert.ToString(Session["USERFLEETID"]));
if (li != null)
{
li.Selected = true;
}
BLL_Infra_VesselLib objBLLVessel = new BLL_Infra_VesselLib();
DataTable dtvsl = objBLLVessel.Get_VesselList(int.Parse(cmbFleet.SelectedValue), 0, UDFLib.ConvertToInteger(Session["USERCOMPANYID"]), "", UDFLib.ConvertToInteger(Session["USERCOMPANYID"]));
DDlVessel_List.DataSource = dtvsl;
DDlVessel_List.DataBind();
DDlVessel_List.Items.Insert(0, new ListItem("--VESSELS--", "0"));
ViewState["Status"] = "NEW";
BindRequestList();
txtSelMenu.Value = lnkMenu1.ClientID;
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "selectNode", "selMe('" + txtSelMenu.Value + "');", true);
BLL_Infra_UserCredentials objUser = new BLL_Infra_UserCredentials();
chklistUser.DataSource = objUser.Get_UserList(1);
chklistUser.DataTextField = "USERNAME";
chklistUser.DataValueField = "USERID";
chklistUser.DataBind();
}
chkShowAllPendingApproval.Visible = false;
string js = "bindClientEvents();";
ScriptManager.RegisterStartupScript(this, this.GetType(), "bindEvents", js, true);
string js1 = "bindPaxsName();";
ScriptManager.RegisterStartupScript(this, this.GetType(), "bindPaxsName", js1, true);
string js2 = "bindRoutInfo();";
ScriptManager.RegisterStartupScript(this, this.GetType(), "bindRoutInfo", js2, true);
string js3 = "bindVesselPortCall();";
ScriptManager.RegisterStartupScript(this, this.GetType(), "bindVesselPortCall", js3, true);
string js4 = "bindselectors();";
ScriptManager.RegisterStartupScript(this, this.GetType(), "bindselectors", js4, true);
}
catch { throw; }
}
public void Load_FleetList()
{
BLL_Infra_VesselLib objVessel = new BLL_Infra_VesselLib();
int UserCompanyID = UDFLib.ConvertToInteger(Session["USERCOMPANYID"].ToString());
ddlFleet.DataTextField = "NAME";
ddlFleet.DataValueField = "CODE";
ddlFleet.DataSource = objVessel.GetFleetList(UserCompanyID);
ddlFleet.DataBind();
}
//Methods Declaration
#region Page Methods
private void BindFleets()
{
BLL_Infra_VesselLib objVessel = new BLL_Infra_VesselLib();
int UserCompanyID = UDFLib.ConvertToInteger(Session["USERCOMPANYID"].ToString());
ddlFleet.DataSource = objVessel.GetFleetList(UserCompanyID);
ddlFleet.DataTextField = "NAME";
ddlFleet.DataValueField = "CODE";
ddlFleet.DataBind();
ddlFleet.Items.Insert(0, new ListItem("-SELECT ALL-", "0"));
}
public void Load_VesselList()
{
BLL_Infra_VesselLib objBLL = new BLL_Infra_VesselLib();
DataTable dt = objBLL.Get_VesselList(0, 0, 0, "", 1);
ddlVessel.DataSource = dt;
ddlVessel.DataTextField = "VESSEL_NAME";
ddlVessel.DataValueField = "VESSEL_ID";
ddlVessel.DataBind();
ddlVessel.Items.Insert(0, new ListItem("All Vessel", "0"));
}
public void Load_VesselList()
{
BLL_Infra_VesselLib objBLL = new BLL_Infra_VesselLib();
DataTable dt = objBLL.Get_VesselList(0, 0, 0, "", Convert.ToInt32(GetCompanyID()));
ddlVessel.DataSource = dt;
ddlVessel.DataTextField = "VESSEL_NAME";
ddlVessel.DataValueField = "VESSEL_ID";
ddlVessel.DataBind();
ddlVessel.Items.Insert(0, new ListItem("-All Vessels-", "0"));
}
public void Load_VesselList()
{
BLL_Infra_VesselLib objVsl = new BLL_Infra_VesselLib();
DataTable dtVessel = objVsl.Get_VesselList(0, 0, Convert.ToInt32(Session["USERCOMPANYID"].ToString()), "", Convert.ToInt32(Session["USERCOMPANYID"].ToString()));
lstVesselList.DataSource = dtVessel;
lstVesselList.DataTextField = "Vessel_Name";
lstVesselList.DataValueField = "Vessel_ID";
lstVesselList.DataBind();
lstVesselList.Items.Insert(0, new ListItem("-SELECT-", "0"));
}
protected void BindVessels()
{
BLL_Infra_VesselLib objBLL = new BLL_Infra_VesselLib();
DataTable dt = objBLL.Get_VesselList(0, 0, 0, "", Convert.ToInt32(Session["USERCOMPANYID"].ToString()));
ddlVessel.DataSource = dt;
ddlVessel.DataTextField = "VESSEL_NAME";
ddlVessel.DataValueField = "VESSEL_ID";
ddlVessel.DataBind();
ddlVessel.Items.Insert(0, new ListItem("-Select-", "0"));
}
protected void BindVesselGrid()
{
int Fleet_ID = 0;
int UserCompanyID = UDFLib.ConvertToInteger(getSessionString("USERCOMPANYID"));
int Vessel_Manager = 1;
BLL_Infra_VesselLib objVessel = new BLL_Infra_VesselLib();
gvVessel.DataSource = objVessel.Get_VesselList(Fleet_ID, 0, Vessel_Manager, "", UserCompanyID);
gvVessel.DataBind();
}
