protected void DDLCompany_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
DataTable dtVessel;
if (DDLCompany.SelectedValue == "-- ALL --")
{
dtVessel = objVsl.Get_VesselList(UDFLib.ConvertToInteger(DDLFleetP.SelectedValue), 0, 0, "", 0);
}
else
{
dtVessel = objVsl.Get_VesselList(UDFLib.ConvertToInteger(DDLFleetP.SelectedValue), 0, Convert.ToInt32(DDLCompany.SelectedValue), "", Convert.ToInt32(DDLCompany.SelectedValue));
}
DDLVesselP.Items.Clear();
DDLVesselP.DataSource = dtVessel;
DDLVesselP.DataTextField = "Vessel_name";
DDLVesselP.DataValueField = "Vessel_id";
DDLVesselP.DataBind();
ListItem li = new ListItem("-- Select --", "0");
DDLVesselP.Items.Insert(0, li);
DataTable dtSup = objInsp.TEC_WL_Get_Supritendent_UsersByCompanyID(DDLCompany.SelectedIndex == 0 ? null : UDFLib.ConvertIntegerToNull(DDLCompany.SelectedValue), null);
DDLInspectorP.DataSource = dtSup;
DDLInspectorP.DataTextField = "Name";
DDLInspectorP.DataValueField = "UserID";
DDLInspectorP.DataBind();
DDLInspectorP.Items.Insert(0, new ListItem("-- Select --", null));
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
}
}
protected void DDLFleetP_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
DataTable dtVessel = objVsl.Get_VesselList(UDFLib.ConvertToInteger(DDLFleetP.SelectedValue), 0, Convert.ToInt32(Session["USERCOMPANYID"].ToString()), "", Convert.ToInt32(Session["USERCOMPANYID"].ToString()));
DDLVesselP.Items.Clear();
DDLVesselP.DataSource = dtVessel;
DDLVesselP.DataTextField = "Vessel_name";
DDLVesselP.DataValueField = "Vessel_id";
DDLVesselP.DataBind();
ListItem li = new ListItem("-- Select --", "0");
DDLVesselP.Items.Insert(0, li);
DataTable dtSup = objInsp.Get_Supritendent_Users(DDLFleetP.SelectedIndex == 0 ? null : UDFLib.ConvertIntegerToNull(DDLFleetP.SelectedValue), null);
DDLInspectorP.DataSource = dtSup;
DDLInspectorP.DataTextField = "Name";
DDLInspectorP.DataValueField = "UserID";
DDLInspectorP.DataBind();
DDLInspectorP.Items.Insert(0, new ListItem("-- Select --", null));
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
}
}
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);
}
}
protected void Load_Schedule(int ScheduleID, int SchDetailId)
{
try
{
ViewState["AddEditFlag"] = "Edit";
DataTable dtVessel = objVsl.Get_VesselList(0, 0, Convert.ToInt32(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));
ViewState["ScheduleID"] = ScheduleID;
DDLFleetP.SelectedIndex = 0;
DDLCompany.SelectedIndex = 0;
int Me = 0;
DataSet ds = objInsp.Get_Schedule_Details(ScheduleID, GetSessionUserID(), SchDetailId, 0);
if (ds != null)
{
DataTable dtSchedule = ds.Tables[0];
DataTable dtSettings = ds.Tables[1];
DataTable dtInpectionSchedule = ds.Tables[2];
Session["dtInpectionSchedule"] = dtInpectionSchedule;
if (dtSchedule.Rows.Count > 0)
{
ViewState["ScheduleID"] = dtSchedule.Rows[0]["ScheduleID"].ToString();
txtStartDate.Text = UDFLib.ConvertDateToNull(dtSchedule.Rows[0]["Start_Date"]).Value.ToString("dd/MMM/yy");
if (UDFLib.ConvertDateToNull(dtSchedule.Rows[0]["End_Date"]) != null)
{
txtEndDate.Text = UDFLib.ConvertDateToNull(dtSchedule.Rows[0]["End_Date"]).Value.ToString("dd/MMM/yy");
}
rdoFrequency.SelectedValue = dtSchedule.Rows[0]["FrequencyType"].ToString();
txtWeek.Text = dtSchedule.Rows[0]["Frequency"].ToString();
rdoFrequency_SelectedIndexChanged(null, null);
txtInspRemark.Text = dtSchedule.Rows[0]["Schedule_Desc"].ToString();
DDLVesselP.SelectedValue = dtSchedule.Rows[0]["Vessel_ID"].ToString();
DDLVessselP_SelectedIndexChanged(null, null);
try
{
DDLInspectorP.SelectedValue = dtSchedule.Rows[0]["InspectorID"].ToString();
}
catch (Exception)
{
DDLInspectorP.SelectedIndex = 0;
}
try
{
if (dtSchedule.Rows[0]["InspectionTypeId"].ToString().Trim().Length > 0)
{
ddlInspectionTypeP.SelectedValue = dtSchedule.Rows[0]["InspectionTypeId"].ToString();
}
}
catch (Exception)
{
ddlInspectionTypeP.SelectedIndex = 0;
ddlInspectionTypeP.Enabled = true;
}
txtDurJobs.Text = dtSchedule.Rows[0]["DurJobs"].ToString();
}
if (dtSettings.Rows.Count > 0)
{
if (rdoFrequency.SelectedValue == "Onetime")
{
txtOneTime.Text = GetSettingDateValue(dtSettings, "OneTime", "");
}
if (rdoFrequency.SelectedValue == "Weekly")
{
DataTable dtWeekdays = GetSettingTable(dtSettings, "WEEKDAYS");
chkWeekDays.ClearSelection();
foreach (DataRow dr in dtWeekdays.Rows)
{
chkWeekDays.Items[UDFLib.ConvertToInteger(dr["key_value_int"]) - 1].Selected = true;
}
}
if (rdoFrequency.SelectedValue == "Monthwise")
{
DataTable dtMonthWise = GetSettingTable(dtSettings, "MONTHWISE");
chkMonthWise.ClearSelection();
foreach (DataRow dr in dtMonthWise.Rows)
{
chkMonthWise.Items[UDFLib.ConvertToInteger(dr["key_value_int"]) - 1].Selected = true;
}
}
if (rdoFrequency.SelectedValue == "Duration")
{
ddlDuration.SelectedValue = GetSettingTable(dtSettings, "Duration").Rows[0]["key_value_int"].ToString();
}
DataTable dtEmailDays = GetSettingTable(dtSettings, "EmailDays");
if (dtEmailDays.Rows.Count > 0)
{
if (UDFLib.ConvertToInteger(dtEmailDays.Rows[0]["key_value_int"]) > 0)
{
chkSendEmail.Checked = true;
ddlDaysBefore.SelectedValue = UDFLib.ConvertToInteger(dtEmailDays.Rows[0]["key_value_int"]).ToString();
}
else
{
chkSendEmail.Checked = false;
}
}
DataTable dtImages = GetSettingTable(dtSettings, "ShowImages");
if (dtImages.Rows.Count > 0)
{
if (UDFLib.ConvertToInteger(dtImages.Rows[0]["key_value_int"]) == 1)
{
chkImages.Checked = true;
}
else
{
chkImages.Checked = false;
}
}
DataSet dsPorts = objInsp.INSP_Get_InspectionPort(SchDetailId);
if (dsPorts.Tables[0].Rows.Count > 0)
{
try
{
drpPort.SelectedValue = dsPorts.Tables[0].Rows[0]["PortID"].ToString();
}
catch { }
}
}
}
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
}
}
