protected void btnExport_Click(object sender, ImageClickEventArgs e)
{
DataSet ds = BLL_SCM_Report.SCMReportDetailsSearch(Convert.ToInt32(Request.QueryString["SCMID"]), TabSCM.ActiveTab.TabIndex, Convert.ToInt32(Request.QueryString["VesselID"]));
string[] HeaderCaptions = { "Staff Code", "Staff Name", "Staff Rank", "Sigature" };
string[] DataColumnsName = { "STAFF_CODE", "Staff_Name", "Rank_Short_Name", "Sigature" };
ds.Tables[0].Columns.Add("Sigature");
foreach (DataRow item in ds.Tables[0].Rows)
{
item["Sigature"] = "";
}
GridViewExportUtil.ShowExcel(ds.Tables[0], HeaderCaptions, DataColumnsName, "SCM", "Safety Committee Meeting Attendance");
}
protected void BindSCMTabs()
{
int p = 1;
if (TabSCM.ActiveTab.TabIndex != 10)
{
DataSet ds = BLL_SCM_Report.SCMReportDetailsSearch(Convert.ToInt32(Request.QueryString["SCMID"]), TabSCM.ActiveTab.TabIndex, Convert.ToInt32(Request.QueryString["VesselID"]));
if (ds.Tables[ds.Tables.Count - 1].Rows[0]["VerificationComment"].ToString().Length > 0)
{
txtMessage.Text = ds.Tables[ds.Tables.Count - 1].Rows[0]["VerificationComment"].ToString();
txtMessage.ReadOnly = true;
btnVerify.Visible = false;
lblVerifiedBy.Text = ds.Tables[ds.Tables.Count - 1].Rows[0]["VerifiedByName"].ToString();;
lblVerificationDate.Text = Convert.ToDateTime(ds.Tables[ds.Tables.Count - 1].Rows[0]["VerificationDate"].ToString()).ToString("dd/MMM/yyyy");
lblVerificationDate.Visible = true;
lblVerificationDateH.Visible = true;
lblVerifiedBy.Visible = true;
lblVerifiedByH.Visible = true;
txtMessage.Visible = true;
lblComment.Visible = true;
}
else
{
if (objUA.Approve != 0)
{
txtMessage.Text = "";
btnVerify.Visible = true;
txtMessage.Visible = true;
lblVerificationDate.Visible = false;
lblVerificationDateH.Visible = false;
lblVerifiedBy.Visible = false;
lblVerifiedByH.Visible = false;
}
}
switch (TabSCM.ActiveTab.TabIndex)
{
case 0:
gvInjd.DataSource = ds.Tables[0];
gvInjd.DataBind();
gvInjdLst.DataSource = ds.Tables[1];
gvInjdLst.DataBind();
break;
case 1:
gvEmdrl.DataSource = ds.Tables[0];
gvEmdrl.DataBind();
gvEmdrlntdone.DataSource = ds.Tables[1];
gvEmdrlntdone.DataBind();
break;
case 2:
gvSfvs.DataSource = ds.Tables[0];
gvSfvs.DataBind();
break;
case 3:
gvSwpt.DataSource = ds.Tables[0];
gvSwpt.DataBind();
break;
case 4:
gvOrtg.DataSource = ds.Tables[0];
gvOrtg.DataBind();
break;
case 5:
break;
case 6:
gvMetm.DataSource = ds.Tables[0];
gvMetm.DataBind();
break;
case 7:
gvAbsn.DataSource = ds.Tables[0];
gvAbsn.DataBind();
break;
case 8:
gvCncd.DataSource = ds.Tables[0];
gvCncd.DataBind();
break;
case 9:
gvAttachments.DataSource = ds.Tables[0];
gvAttachments.DataBind();
break;
case 12:
gvEnvironmental.DataSource = ds.Tables[0];
gvEnvironmental.DataBind();
dlEnvironmentalAttachments.DataSource = ds.Tables[1];
dlEnvironmentalAttachments.DataBind();
break;
case 13:
gvHealthNutritionHygiene.DataSource = ds.Tables[0];
gvHealthNutritionHygiene.DataBind();
dtHealthAttachments.DataSource = ds.Tables[1];
dtHealthAttachments.DataBind();
break;
default:
break;
}
}
}