public void FillDDL()
{
try
{
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--", null));
}
catch (Exception ex)
{
}
finally
{
}
}
public void Load_VesselList()
{
int UserCompanyID = UDFLib.ConvertToInteger(Session["USERCOMPANYID"].ToString());
int Vessel_Manager = UDFLib.ConvertToInteger(Session["USERCOMPANYID"].ToString());
if (Session["UTYPE"].ToString() == "VESSEL MANAGER")
{
Vessel_Manager = UserCompanyID;
}
ddlVessel.DataSource = objVessel.Get_VesselList(0, 0, Vessel_Manager, "", UserCompanyID);
ddlVessel.DataTextField = "VESSEL_NAME";
ddlVessel.DataValueField = "VESSEL_ID";
ddlVessel.DataBind();
ddlVessel.Items.Insert(0, new ListItem("-SELECT ALL-", "0"));
ddlVesselMain.DataSource = objVessel.Get_VesselList(0, 0, Vessel_Manager, "", UserCompanyID);
ddlVesselMain.DataTextField = "VESSEL_NAME";
ddlVesselMain.DataValueField = "VESSEL_ID";
ddlVesselMain.DataBind();
ddlVesselMain.Items.Insert(0, new ListItem("-SELECT ALL-", "0"));
ddlVessel.SelectedIndex = 0;
ddlVesselMain.SelectedIndex = 0;
}
protected void DDLFleet_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
int Vessel_Manager = 0;
if (Session["COMPANYTYPE"].ToString().ToUpper() == "SURVEYOR")
{
Vessel_Manager = Convert.ToInt32(ddlVessel_Manager.SelectedValue);
}
DataTable dtVessel = objVsl.Get_VesselList(UDFLib.ConvertToInteger(DDLFleet.SelectedValue), 0, Vessel_Manager, "", 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--", "0");
DDLVessel.Items.Insert(0, li);
Load_Current_Schedules();
}
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 FillGridViewAfterSearch()
{
int UserCompanyID = UDFLib.ConvertToInteger(Session["USERCOMPANYID"].ToString());
DataTable dt = objBLL.Get_VesselList(UDFLib.ConvertToInteger(DDLFleet.SelectedValue), UDFLib.ConvertToInteger(DDLVessel.SelectedValue), UDFLib.ConvertToInteger(ddlFilterVesselManager.SelectedValue), txtfilter.Text, UserCompanyID);
VesselGridView.DataSource = dt;
VesselGridView.DataBind();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
string SearchText = txtSearchVesselList.Text;
DataTable dt = objBLLVessel.Get_VesselList(0, 0, UDFLib.ConvertToInteger(Session["USERCOMPANYID"]), SearchText, UDFLib.ConvertToInteger(Session["USERCOMPANYID"]));
lstVesselList.DataSource = dt;
lstVesselList.DataBind();
lstVesselList.Items.Insert(0, new ListItem("--VESSELS--", "0"));
}
public void Load_VesselList()
{
int Fleet_ID = int.Parse(ddlFleet.SelectedValue);
int UserCompanyID = UDFLib.ConvertToInteger(Session["USERCOMPANYID"].ToString());
ddlVesselList.DataSource = objVessel.Get_VesselList(Fleet_ID, 0, UserCompanyID, "", UserCompanyID);
ddlVesselList.DataTextField = "VESSEL_NAME";
ddlVesselList.DataValueField = "VESSEL_ID";
ddlVesselList.DataBind();
ddlVesselList.Items.Insert(0, new ListItem("-SELECT ALL-", "0"));
}
public void Load_VesselList()
{
int Fleet_ID = int.Parse(ddlFleet.SelectedValue);
int UserCompanyID = UDFLib.ConvertToInteger(getSessionString("USERCOMPANYID"));
int Vessel_Manager = UDFLib.ConvertToInteger(getSessionString("USERCOMPANYID"));
ddlVessel.DataSource = objVessel.Get_VesselList(Fleet_ID, 0, Vessel_Manager, "", UserCompanyID);
ddlVessel.DataTextField = "VESSEL_SHORT_NAME";
ddlVessel.DataValueField = "VESSEL_ID";
ddlVessel.DataBind();
ddlVessel.Items.Insert(0, new ListItem("-SELECT ALL-", "0"));
ddlVessel.SelectedIndex = 0;
}
/// <summary>
/// Bind Vessel dropdown as per vessel assign to the specific user
/// </summary>
public void BindVesselDDL()
{
try
{
BLL_Infra_VesselLib objVsl = new BLL_Infra_VesselLib();
BLL_VET_VettingLib objBLLVetLib = new BLL_VET_VettingLib();
if (chkVesselAssign.Checked == true)
{
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();
DataTable dtUserVessel = objBLLVetLib.VET_Get_UserVesselList(0, 0, Convert.ToInt32(Session["USERCOMPANYID"].ToString()), "", Convert.ToInt32(Session["USERCOMPANYID"].ToString()), GetSessionUserID());
if (dtUserVessel.Rows.Count > 0)
{
CheckBoxList chk = (CheckBoxList)DDLVessel.Controls[0].Controls[0].FindControl("CheckBoxListItems");
for (int j = 0; j < chk.Items.Count; j++)
{
for (int i = 0; i < dtUserVessel.Rows.Count; i++)
{
if (chk.Items[j].Value == dtUserVessel.Rows[i]["Vessel_ID"].ToString())
{
((CheckBoxList)DDLVessel.Controls[0].Controls[0].FindControl("CheckBoxListItems")).Items[j].Selected = true;
break;
}
}
}
}
}
else
{
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();
}
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
string js = "alert('" + UDFLib.GetException("SystemError/ GeneralMessage") + "');";
ScriptManager.RegisterStartupScript(this, this.GetType(), "error", js, true);
}
}
public void Load_VesselList()
{
try
{
int Fleet_ID = int.Parse(ddlFleetList.SelectedValue);
int UserCompanyID = UDFLib.ConvertToInteger(Session["USERCOMPANYID"].ToString());
int Vessel_Manager = UDFLib.ConvertToInteger(Session["USERCOMPANYID"].ToString());
if (Session["UTYPE"].ToString() == "VESSEL MANAGER")
{
Vessel_Manager = UserCompanyID;
}
ddlVessels.DataSource = objBLLVessel.Get_VesselList(Fleet_ID, 0, Vessel_Manager, "", UserCompanyID);
ddlVessels.DataTextField = "VESSEL_NAME";
ddlVessels.DataValueField = "VESSEL_ID";
ddlVessels.DataBind();
ddlVessels.Items.Insert(0, new ListItem("-SELECT ALL-", "0"));
ddlVessels.SelectedIndex = 0;
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
}
}
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)
{
}
}
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 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;
}
}
public void FillDDL()
{
try
{
BLL_Infra_VesselLib objVsl = new BLL_Infra_VesselLib();
DataTable FleetDT = objVsl.GetFleetList(Convert.ToInt32(Session["USERCOMPANYID"].ToString()));
DDLFleet.Items.Clear();
DDLFleet.DataSource = FleetDT;
DDLFleet.DataTextField = "Name";
DDLFleet.DataValueField = "code";
DDLFleet.DataBind();
DDLFleet.Items.Insert(0, new ListItem("--SELECT ALL--", "0"));
DataTable dtVessel = objVsl.Get_VesselList(0, 0, Convert.ToInt32(Session["USERCOMPANYID"].ToString()), "", Convert.ToInt32(Session["USERCOMPANYID"].ToString()));
ucf_DDLVessel.DataTextField = "Vessel_name";
ucf_DDLVessel.DataValueField = "Vessel_id";
ucf_DDLVessel.DataSource = dtVessel;
}
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 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)
{
}
}
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 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();
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 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
{
}
}
public void Load_VesselList()
{
int Fleet_ID = int.Parse(ddlFleet.SelectedValue);
int UserCompanyID = UDFLib.ConvertToInteger(Session["USERCOMPANYID"].ToString());
int Vessel_Manager = UDFLib.ConvertToInteger(Session["USERCOMPANYID"].ToString());
if (Session["UTYPE"].ToString() == "VESSEL MANAGER")
{
Vessel_Manager = UserCompanyID;
}
lstVessel.DataSource = objVessel.Get_VesselList(Fleet_ID, 0, Vessel_Manager, "", UserCompanyID);
lstVessel.DataTextField = "VESSEL_NAME";
lstVessel.DataValueField = "VESSEL_ID";
lstVessel.DataBind();
}
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));
}
public void Load_VesselList()
{
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();
}
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_VesselList()
{
DataTable dt = objBLL.Get_VesselList(0, 0, 0, "", 1);
ddlCrewVessel.DataSource = dt;
ddlCrewVessel.DataTextField = "VESSEL_NAME";
ddlCrewVessel.DataValueField = "VESSEL_ID";
ddlCrewVessel.DataBind();
ddlCrewVessel.Items.Insert(0, new ListItem("--Select--", "0"));
}
protected void Load_VesselList()
{
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"));
}
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();
}
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"));
}
