protected void Bind_ChangeEvent(int EventID)
{
DataSet ds = objCrew.Get_CrewChangeEvent(EventID, GetSessionUserID());
UDFLib.AddParentTable(ds.Tables[0], "Events", new string[] { "PKID" },
new string[] { "Vessel_short_name", "Event_Date", "Port_Name", "Event_Status", "EventRemark" }, "EventMembers");
rpt1.DataSource = ds;
rpt1.DataMember = "Events";
rpt1.DataBind();
}
protected void Load_CrewComplaints(int CrewID)
{
DataSet ds = objCrew.Get_CrewComplaints(CrewID, int.Parse(Session["USERID"].ToString()));
UDFLib.AddParentTable(ds.Tables[0], "Complaints", new string[] { "WORKLIST_ID", "VESSEL_ID" },
new string[] { "VESSEL_NAME", "JOB_DESCRIPTION", "STATUS" }, "EscLog");
UDFLib.AddParentTable(ds.Tables[1], "MyComplaints", new string[] { "WORKLIST_ID", "VESSEL_ID" },
new string[] { "VESSEL_NAME", "JOB_DESCRIPTION", "STATUS" }, "MyLog");
rptMyComplaints.DataSource = ds;
rptMyComplaints.DataMember = "MyComplaints";
rptMyComplaints.DataBind();
}
protected void Bind_ChangeEvent()
{
int CrewID = GetCrewID();
DataSet ds = objBLLCrew.Get_CrewChangeEvents_ByCrew(CrewID, GetSessionUserID());
UDFLib.AddParentTable(ds.Tables[0], "Events", new string[] { "PKID" },
new string[] { "Vessel_short_name", "Event_Date", "Port_Name" }, "EventMembers");
rpt1.DataSource = ds;
rpt1.DataMember = "Events";
rpt1.DataBind();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
int RankID = 0;
DataSet ds = BLL_Crew_CrewRotation.Get_RotationReport(0, UDFLib.ConvertToInteger(ddlVessel_Manager.SelectedValue), UDFLib.ConvertToInteger(ddlManningOffice.SelectedValue), UDFLib.ConvertToInteger(ddlFleet.SelectedValue), UDFLib.ConvertToInteger(ddlVessel.SelectedValue), RankID, UDFLib.ConvertToDefaultDt(txtFromDate.Text), UDFLib.ConvertToDefaultDt(txtToDate.Text), txtSearch.Text, GetSessionUserID());
UDFLib.AddParentTable(ds.Tables[0], "Parent", new string[] { "Vessel_ID" },
new string[] { "vessel_name" }, "ChildMembers");
rpt1.DataSource = ds;
rpt1.DataMember = "Parent";
rpt1.DataBind();
//ExportToExcel(rpt1);
}
protected void Load_CrewComplaints(int CrewID)
{
try
{
DataSet ds = objBLLCrew.Get_CrewComplaints(CrewID, int.Parse(Session["USERID"].ToString()));
UDFLib.AddParentTable(ds.Tables[0], "Complaints", new string[] { "WORKLIST_ID", "VESSEL_ID" },
new string[] { "VESSEL_NAME", "JOB_DESCRIPTION", "STATUS" }, "EscLog");
UDFLib.AddParentTable(ds.Tables[1], "MyComplaints", new string[] { "WORKLIST_ID", "VESSEL_ID" },
new string[] { "VESSEL_NAME", "JOB_DESCRIPTION", "STATUS" }, "MyLog");
rptComplaintsToMe.DataSource = ds;
rptComplaintsToMe.DataMember = "Complaints";
rptComplaintsToMe.DataBind();
rptMyComplaints.DataSource = ds;
if (ds.Tables["Table1"].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables["Table1"].Rows)
{
if (!string.IsNullOrEmpty(dr["ESCALATED_ON"].ToString()))
{
dr["ESCALATED_ON"] = UDFLib.ConvertUserDateFormat(Convert.ToString(dr["ESCALATED_ON"].ToString()), UDFLib.GetDateFormat());
}
}
}
rptMyComplaints.DataMember = "MyComplaints";
rptMyComplaints.DataBind();
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
}
}