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
{
}
}
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
{
}
}
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";
}
}
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"));
}
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"));
}
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 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)
{
}
}
/// <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);
}
}
//Method to load Fleet Dropdown
public void Load_FleetList()
{
ddlFleet.DataSource = objVessel.GetFleetList(UserCompanyID);
ddlFleet.DataTextField = "NAME";
ddlFleet.DataValueField = "CODE";
ddlFleet.DataBind();
ddlFleet.Items.Insert(0, new ListItem("-SELECT ALL-", "0"));
}
public void Get_PortCall_Search_DPL()
{
string FromDate;
try
{
if (Session["sFleet"] == null || Session["sVesselCode"] != null)
{
DataTable FleetDT = objBLL.GetFleetList(Convert.ToInt32(Session["USERCOMPANYID"].ToString()));
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 dtVessel = objPortCall.Get_PortCall_VesselList(FleetDT, 0, Convert.ToInt32(Session["USERCOMPANYID"].ToString()), "", Convert.ToInt32(Session["USERCOMPANYID"].ToString()));
dtVessel.Columns.RemoveAt(1);
dtVessel.Columns.RemoveAt(1);
dtVessel.Columns.RemoveAt(1);
dtVessel.Columns.RemoveAt(1);
Session["sVesselCode"] = dtVessel;
}
String ToDate = System.DateTime.Now.AddMonths(6).ToString("dd-MM-yyyy");
if (Session["FromDate"] != null)
{
FromDate = Session["FromDate"].ToString();
}
else
{
FromDate = System.DateTime.Now.ToString("dd-MM-yyyy");
}
if (Session["sFleet"] != null && Session["sVesselCode"] != null)
{
DataSet ds = objPortCall.Get_PortCall_Search_DPL((DataTable)Session["sFleet"], (DataTable)Session["sVesselCode"], Convert.ToDateTime(FromDate.ToString()));
ds.Relations.Add(new DataRelation("NestedCat", ds.Tables[1].Columns["Vessel_ID"], ds.Tables[0].Columns["Vessel_ID"]));
ds.Tables[1].TableName = "Members";
rpt1.DataSource = ds.Tables[1];
rpt1.DataBind();
rpt1.DataSource = ds.Tables[1];
rpt1.DataBind();
}
}
catch (Exception ex)
{
}
}
public void FillDDL()
{
try
{
BLL_Infra_InspectionType onjInsp = new BLL_Infra_InspectionType();
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);
BLL_Infra_Company objInfra = new BLL_Infra_Company();
ddlVessel_Manager.DataSource = objInfra.Get_Company_Parent_Child(1, 0, 0);
ddlVessel_Manager.DataTextField = "COMPANY_NAME";
ddlVessel_Manager.DataValueField = "ID";
ddlVessel_Manager.DataBind();
ddlVessel_Manager.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()));
DDLVessel.DataSource = dtVessel;
DDLVessel.DataTextField = "Vessel_name";
DDLVessel.DataValueField = "Vessel_id";
DDLVessel.DataBind();
DDLVessel.Items.Insert(0, new ListItem("--SELECT--", null));
DataTable dtSup = objInsp.Get_Supritendent_Users(null, null);
DDLInspector.DataSource = dtSup;
DDLInspector.DataTextField = "Name";
DDLInspector.DataValueField = "UserID";
DDLInspector.DataBind();
DDLInspector.Items.Insert(0, new ListItem("--SELECT--", null));
DDLInspectorA.DataSource = dtSup;
DDLInspectorA.DataTextField = "Name";
DDLInspectorA.DataValueField = "UserID";
DDLInspectorA.DataBind();
DDLInspectorA.Items.Insert(0, new ListItem("--SELECT--", null));
DataTable dtInsp = onjInsp.Get_InspectionTypeList();
ddlInspectionType.DataSource = dtInsp;
ddlInspectionType.DataTextField = "InspectionTypeName";
ddlInspectionType.DataValueField = "InspectionTypeId";
ddlInspectionType.DataBind();
ddlInspectionType.Items.Insert(0, new ListItem("--SELECT--", null));
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
}
}
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();
}
public void Load_FleetList()
{
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"));
}
//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_FleetList()
{
BLL_Infra_VesselLib objVessel = new BLL_Infra_VesselLib();
int Vessel_Manager = 0;
int UserCompanyID = UDFLib.ConvertToInteger(Session["USERCOMPANYID"].ToString());
ddlFleet.DataSource = objVessel.GetFleetList(UserCompanyID, Vessel_Manager);
ddlFleet.DataTextField = "NAME";
ddlFleet.DataValueField = "CODE";
ddlFleet.DataBind();
ddlFleet.Items.Insert(0, new ListItem("- SELECT -", "0"));
}
protected void Page_Load(object sender, EventArgs e)
{
UserAccessValidation();
lblErrorMessage.Text = "";
lblmsg.Text = "";
if (!IsPostBack)
{
try
{
BindSubcatalogue();
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()));
chkVesselList.DataSource = dtVessel;
chkVesselList.DataBind();
SelectSavedVessels();
BindSplittedItems();
BLL_Infra_VesselLib objVsl = new BLL_Infra_VesselLib();
DataTable FleetDT = objVsl.GetFleetList(Convert.ToInt32(Session["USERCOMPANYID"].ToString()));
DataRow drselect = FleetDT.NewRow();
drselect["code"] = "0";
drselect["Name"] = "-- All Fleet --";
FleetDT.Rows.InsertAt(drselect, 0);
ddlFleet.DataSource = FleetDT;
ddlFleet.DataTextField = "Name";
ddlFleet.DataValueField = "code";
ddlFleet.DataBind();
}
catch (Exception ex)
{
lblmsg.Text = ex.Message;
}
}
if ((chkVesselList.Items.Cast <ListItem>().Count(li => li.Selected)) == 1)
{
btnAssign.Enabled = true;
btnViewAssignment.Enabled = true;
}
else
{
btnAssign.Enabled = false;
btnViewAssignment.Enabled = false;
}
}
/// <summary>
/// Description: This method binds the vessel list.
/// <summary>
protected void BindKPIGoals()
{
try
{
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());
DataTable dtable = objKPI.Get_KPI_DetailGoals(UDFLib.ConvertIntegerToNull(ViewState["KPID"].ToString()), dt, 0, Convert.ToInt32(Session["USERCOMPANYID"].ToString()), GetSessionUserID(), "VE").Tables[0];
rgdItems.DataSource = dtable;
rgdItems.DataBind();
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
}
}
protected void FillDDL()
{
if (Session["USERCOMPANYID"] != null)
{
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--", "0");
ddlFleet.Items.Insert(0, li);
}
}
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();
}
catch (Exception ex)
{
}
}
protected void LoadData()
{
try
{
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("- ALL -", "0"));
DataSet dsVessel = objInsp.FMS_Get_VesselSchInfo(UDFLib.ConvertToInteger(Request.QueryString["DocId"].ToString()), UDFLib.ConvertToInteger(Session["USERCOMPANYID"].ToString()), null); /* This Function in DAL is to be used*/
if (dsVessel.Tables.Count > 0)
{
gvVesselSch.DataSource = dsVessel.Tables[0];
gvVesselSch.DataBind();
}
txtStartDate.Enabled = true;
rdoFrequency.Enabled = true;
ViewState["ScheduleID"] = 0;
txtStartDate.Text = DateTime.Now.Date.ToString("dd/MMM/yy");
txtEndDate.Text = "";
txtOneTime.Text = DateTime.Now.Date.ToString("dd/MMM/yy");
chkMonthWise.ClearSelection();
chkWeekDays.ClearSelection();
txtWeek.Text = "1";
rdoFrequency.SelectedIndex = 0;
ddlDuration.SelectedValue = "7";
rdoFrequency_SelectedIndexChanged(null, null);
Guid l = Guid.NewGuid();
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
}
}
public void Load_FleetList_Filter()
{
try
{
int UserCompanyID = UDFLib.ConvertToInteger(Session["USERCOMPANYID"].ToString());
DataTable dt = objVessel.GetFleetList(UserCompanyID);
ddlFleetFilter.DataSource = dt;
ddlFleetFilter.DataTextField = "NAME";
ddlFleetFilter.DataValueField = "CODE";
ddlFleetFilter.DataBind();
ddlFleetFilter.Items.Insert(0, new ListItem("-SELECT ALL-", "0"));
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
}
}
public void BindFleetDLL()
{
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();
ListItem li = new ListItem("--SELECT ALL--", "0");
DDLFleet.Items.Insert(0, li);
}
catch (Exception ex)
{
}
}
/// <summary>
/// Bind fleet
/// </summary>
public void BindFleetDLL()
{
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();
ListItem li = new ListItem("-Select-", "0");
DDLFleet.Items.Insert(0, li);
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
string js = "alert('" + UDFLib.GetException("SystemError/ GeneralMessage") + "');";
ScriptManager.RegisterStartupScript(this, this.GetType(), "error", js, true);
}
}
protected void BindVesselList()
{
// DataTable dt = objKPI.Get_KPI_DetailGoals(-1).Tables[0];
BLL_Infra_VesselLib bll_Vessel = new BLL_Infra_VesselLib();
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 = objKPI.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"));
}
public void Load_VesselList()
{
if (Session["sFleet"] == null)
{
DataTable FleetDT = objBLL.GetFleetList(Convert.ToInt32(Session["USERCOMPANYID"].ToString()));
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, "", 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 LoadData()
{
try
{
ViewState["AddEditFlag"] = "Add";
grvChecklist.DataSource = null;
grvChecklist.DataBind();
tblChecklist.Visible = false;
BLL_Infra_Company objCom = new BLL_Infra_Company();
DataSet dtCompany = objCom.Get_Company_Parent_Child(1, 0, 0);;
DDLCompany.DataSource = dtCompany.Tables[0];
DDLCompany.DataTextField = "Company_Name";
DDLCompany.DataValueField = "ID";
DDLCompany.DataBind();
DDLCompany.Items.Insert(0, new ListItem("-- ALL --", null));
BLL_Infra_InspectionType onjInsp = new BLL_Infra_InspectionType();
DataTable FleetDT = objVsl.GetFleetList(Convert.ToInt32(Session["USERCOMPANYID"].ToString()));
DDLFleetP.DataSource = FleetDT;
DDLFleetP.DataTextField = "Name";
DDLFleetP.DataValueField = "code";
DDLFleetP.DataBind();
DDLFleetP.Items.Insert(0, new ListItem("-- ALL --", null));
DataTable dtVessel = objVsl.Get_VesselList(0, 0, 0, "", Convert.ToInt32(Session["USERCOMPANYID"].ToString()));
DDLVesselP.DataSource = dtVessel;
DDLVesselP.DataTextField = "Vessel_name";
DDLVesselP.DataValueField = "Vessel_id";
DDLVesselP.DataBind();
DDLVesselP.Items.Insert(0, new ListItem("-- Select --", null));
DataTable dtInsp = onjInsp.Get_InspectionTypeList();
ddlInspectionTypeP.DataSource = dtInsp;
ddlInspectionTypeP.DataTextField = "InspectionTypeName";
ddlInspectionTypeP.DataValueField = "InspectionTypeId";
ddlInspectionTypeP.DataBind();
ddlInspectionTypeP.Items.Insert(0, new ListItem("--SELECT--", null));
DataTable dtPort = objInfra.Get_PortList();
if (dtPort.Rows.Count > 0)
{
drpPort.DataSource = dtPort;
drpPort.DataValueField = "PORT_ID";
drpPort.DataTextField = "PORT_NAME";
drpPort.DataBind();
}
drpPort.Items.Insert(0, new ListItem()
{
Value = "0", Text = "-Select-"
});
txtStartDate.Enabled = true;
DDLFleetP.Enabled = true;
DDLVesselP.Enabled = true;
ddlInspectionTypeP.Enabled = true;
rdoFrequency.Enabled = true;
drpPort.Visible = true;
ViewState["ScheduleID"] = 0;
ViewState["ScheduleID"] = "0";
txtStartDate.Text = DateTime.Now.Date.ToString("dd/MMM/yy");
txtEndDate.Text = "";
txtOneTime.Text = DateTime.Now.Date.ToString("dd/MMM/yy");
chkMonthWise.ClearSelection();
chkWeekDays.ClearSelection();
txtWeek.Text = "1";
chkSendEmail.Checked = false;
chkImages.Checked = false;
txtInspRemark.Text = "";
DDLFleetP.SelectedIndex = 0;
DDLVesselP.SelectedIndex = 0;
DDLInspectorP.SelectedIndex = 0;
ddlDaysBefore.SelectedIndex = 6;
rdoFrequency.SelectedIndex = 0;
ddlInspectionTypeP.SelectedIndex = 0;
ddlDuration.SelectedValue = "7";
rdoFrequency_SelectedIndexChanged(null, null);
txtDurJobs.Text = "1";
Guid l = Guid.NewGuid();
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
}
}
/// <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
{
}
}
public DataTable GetFleetList()
{
BLL_Infra_VesselLib objBLL = new BLL_Infra_VesselLib();
return(objBLL.GetFleetList(1));
}
protected void Requisition_Count()
{
BLL_Infra_VesselLib objVsl = new BLL_Infra_VesselLib();
BLL_PURC_Purchase objTechService = new BLL_PURC_Purchase();
BLL_Infra_UserCredentials objUserFlt = new BLL_Infra_UserCredentials();
DataTable dtEmptyTable = new DataTable();
DataTable FleetDT = objVsl.GetFleetList(Convert.ToInt32(Session["USERCOMPANYID"].ToString()));
DataTable DeptDt = objTechService.GetDeptType();
dtEmptyTable.Columns.Add("Message");
DataRow drEmpty = dtEmptyTable.NewRow();
drEmpty[0] = "No record found !";
dtEmptyTable.Rows.Add(drEmpty);
DataTable dtUserFleet = objUserFlt.Get_Fleet_By_UserID(Convert.ToInt32(Session["USERID"].ToString()));
if (dtUserFleet.Rows.Count > 0)
{
Table tbl_Reqsn_Count = new Table();
tbl_Reqsn_Count.CssClass = "tbl-css-dash";
tbl_Reqsn_Count.CellPadding = 0;
tbl_Reqsn_Count.CellSpacing = 1;
foreach (DataRow drflt in FleetDT.Rows)
{
// get the fleets based on vessels assigned to loged in user
DataRow[] drUserFleet = dtUserFleet.Select("fleetcode='" + drflt["code"].ToString() + "'");
if (drUserFleet.Length > 0)
{
TableRow tr_Reqsn_Count_HD_Fleet = new TableRow();
TableCell cl_Reqsn_Count_HD_Fleet = new TableCell();
TableRow tr_Reqsn_Count_HD_FormType = new TableRow();
Label lblHD = new Label();
TableRow tr_Reqsn_Count = new TableRow();
tr_Reqsn_Count.CssClass = "td-css-dash";
cl_Reqsn_Count_HD_Fleet.CssClass = "cell-HD-css";
lblHD.Text = drflt["Name"].ToString();
cl_Reqsn_Count_HD_Fleet.Controls.Add(lblHD);
tr_Reqsn_Count_HD_Fleet.Controls.Add(cl_Reqsn_Count_HD_Fleet);
tbl_Reqsn_Count.Controls.Add(tr_Reqsn_Count_HD_Fleet);
foreach (DataRow drDep in DeptDt.Rows)
{
if (drDep["Short_Code"].ToString() != "ALL")
{
DataTable dtReqsnCount = BLL_Infra_DashBoard.Get_Rreqsn_Count(drDep["Short_Code"].ToString(), UDFLib.ConvertToInteger(drflt["code"].ToString()), Session["USERID"].ToString()).Tables[0];
TableCell cl_Reqsn_Count = new TableCell();
TableCell cl_Reqsn_Count_HD_FormType = new TableCell();
cl_Reqsn_Count_HD_FormType.Text = drDep["Description"].ToString();
cl_Reqsn_Count.CssClass = "td-css-dash";
cl_Reqsn_Count_HD_FormType.CssClass = "cell-HD-css";
GridView gvReqsnCount = new GridView();
gvReqsnCount.ID = "gvReqsnCount" + drflt["code"].ToString() + drDep["Short_Code"].ToString();
if (dtReqsnCount.Rows.Count > 0)
{
gvReqsnCount.DataSource = dtReqsnCount;
}
else
{
gvReqsnCount.DataSource = dtEmptyTable;
}
gvReqsnCount.DataBind();
gvReqsnCount.EmptyDataText = "No record found !";
gvReqsnCount.AutoGenerateColumns = true;
gvReqsnCount.RowStyle.CssClass = "RowStyle-css-dash";
gvReqsnCount.AlternatingRowStyle.CssClass = "AlternatingRowStyle-css-dash";
gvReqsnCount.HeaderStyle.CssClass = "HeaderStyle-css-dash";
tr_Reqsn_Count_HD_FormType.Controls.Add(cl_Reqsn_Count_HD_FormType);
cl_Reqsn_Count.Controls.Add(gvReqsnCount);
tr_Reqsn_Count.Controls.Add(cl_Reqsn_Count);
}
}
tbl_Reqsn_Count.Controls.Add(tr_Reqsn_Count_HD_FormType);
tbl_Reqsn_Count.Controls.Add(tr_Reqsn_Count);
}
}
phReqsnCount.Controls.Add(tbl_Reqsn_Count);
}
}
