protected void Load_CompanyList()
{
try
{
int RelationshipType_id = UDFLib.ConvertToInteger(ddCompRelationshipType.SelectedValue);
DataSet ds = objCompBLL.Get_Company_Parent_Child(RelationshipType_id, UDFLib.ConvertToInteger(lstCompany.SelectedValue), Convert.ToInt32(Session["USERID"].ToString()));
if (ds.Tables.Count > 0)
{
lstCompany.DataSource = ds.Tables[0];
lstCompany.DataTextField = "company_name";
lstCompany.DataValueField = "ID";
lstCompany.DataBind();
lstCompany.Items.Insert(0, new ListItem("-Select-", "0"));
lstCompany1.DataSource = ds.Tables[1];
lstCompany1.DataTextField = "company_name";
lstCompany1.DataValueField = "ID";
lstCompany1.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 BindSupAttGrid(DateTime StartDate)
{
DataSet dtCompany = objCom.Get_Company_Parent_Child(1, UDFLib.ConvertToInteger(Session["USERCOMPANYID"].ToString()), 0);;
DDLCompany.DataSource = dtCompany.Tables[0];
DDLCompany.DataTextField = "Company_Name";
DDLCompany.DataValueField = "ID";
DDLCompany.DataBind();
DDLCompany.Items.Insert(0, new ListItem("-- ALL --", null));
dt = objInsp.TEC_Get_SupritendentAttendanceWithPort(StartDate, UDFLib.ConvertToInteger(DDLCompany.SelectedValue));
grdSupAtt.DataSource = dt;
grdSupAtt.DataBind();
//string js = "LastLoad()";
// ScriptManager.RegisterStartupScript(this, this.GetType(), "ddd", js, true);
//string[] retval = new string[2];
//retval = asncLoadCalendarBySupt("0", StartDate.ToString());
//newt0.InnerHtml = retval[0];
//newt.InnerHtml = retval[2];
}
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);
}
}
