private void BindRestHoursDetails()
{
DataTable dt = BLL_QMS_RestHours.Get_RestHours_Report(UDFLib.ConvertDateToNull(txtFrom.Text), UDFLib.ConvertDateToNull(txtTo.Text), UDFLib.ConvertToInteger(ddlCrewList.SelectedValue), UDFLib.ConvertToInteger(ddlVesselList.SelectedValue));
if (dt.Rows.Count > 0)
{
lblStaffCode.Text = dt.Rows[0]["Staff_Code"].ToString();
lblStaffName.Text = dt.Rows[0]["Staff_Name"].ToString();
lblStaffRank.Text = dt.Rows[0]["Staff_rank_Code"].ToString();
txtSeafarerRemarks.Text = dt.Rows[0]["Seafarer_Remarks"].ToString();
txtVerifierRemarks.Text = dt.Rows[0]["Verifier_Remarks"].ToString();
lblManage.Text = dt.Rows[0]["Manager_Code"].ToString() + "-" + dt.Rows[0]["Manager_Rank"].ToString() + "-" + dt.Rows[0]["Manager_Name"].ToString();
lblDateofjoing.Text = dt.Rows[0]["Joining_Date"].ToString() != "" ? Convert.ToDateTime(dt.Rows[0]["Joining_Date"]).ToString("dd/MMM/yyyy") : "";
lblDateofsignoff.Text = dt.Rows[0]["Sign_Off_Date"].ToString() != "" ? Convert.ToDateTime(dt.Rows[0]["Sign_Off_Date"]).ToString("dd/MMM/yyyy") : "";
lblSignOn.Text = dt.Rows[0]["Sign_On_Date"].ToString() != "" ? Convert.ToDateTime(dt.Rows[0]["Sign_On_Date"]).ToString("dd/MMM/yyyy") + " " + Convert.ToDateTime(dt.Rows[0]["Sign_On_Date"]).ToString("HH:MM") : "";
// lblManagerRank.Text = dt.Rows[0]["Manager_Rank"].ToString();
lblRestHourDate.Text = " Date : " + dt.Rows[0]["REST_HOURS_DATE"].ToString();
if (dt.Rows[0]["IsEmergency"].ToString() == "1")
{
chkEmergency.Checked = true;
}
if (dt.Rows[0]["IsArrival"].ToString() == "1")
{
chkArrival.Checked = true;
}
if (dt.Rows[0]["IsDeparture"].ToString() == "1")
{
chkDeparture.Checked = true;
}
if (dt.Rows[0]["IsDrill"].ToString() == "1")
{
chkDrill.Checked = true;
}
if (dt.Rows[0]["IsEmergencyVerify"].ToString() == "1")
{
chkEmergencyVerify.Checked = true;
}
}
else
{
lblStaffCode.Text = "";
lblStaffName.Text = "";
lblStaffRank.Text = "";
lblDateofjoing.Text = "";
lblDateofsignoff.Text = "";
txtSeafarerRemarks.Text = "";
txtVerifierRemarks.Text = "";
lblManage.Text = "";
lblSignOn.Text = "";
// lblManagerRank.Text = dt.Rows[0]["Manager_Rank"].ToString();
lblRestHourDate.Text = "";
}
rpDeckLogBook01.DataSource = dt;
rpDeckLogBook01.DataBind();
}
protected void ImgExpExcel_Click(object sender, EventArgs e)
{
DataTable dt = BLL_QMS_RestHours.Get_RestHours_Report(UDFLib.ConvertDateToNull(txtFrom.Text), UDFLib.ConvertDateToNull(txtTo.Text), UDFLib.ConvertToInteger(ddlCrewList.SelectedValue), UDFLib.ConvertToInteger(ddlVesselList.SelectedValue));
string[] HeaderCaptions = { "Date", "Ship's Clocked Hours",
"0", "0", "1", "0", "2",
"0", "3", "0", "4",
"0", "5", "0", "6",
"0", "7", "0", "8",
"0", "9", "1", "0",
"1", "1", "1", "2",
"1", "3", "1", "4",
"1", "5", "1", "6",
"1", "7", "1", "8",
"1", "9", "2", "0",
"2", "1", "2", "2",
"2", "3", "",
"Work Hours", "Rest Hours", "Rest Hours in Any 24 Hours", "Over Time", "Rest Hour In 7-Day Period","Seafarer's Remark", "Verifier's Remark" };
string[] DataColumnsName = { "REST_HOURS_DATE", "SHIPS_CLOCKED_HOURS",
"WH_0000_0030", "WH_0030_0100", "WH_0100_0130", "WH_0130_0200",
"WH_0200_0230", "WH_0230_0300", "WH_0300_0330", "WH_0330_0400",
"WH_0400_0430", "WH_0430_0500", "WH_0500_0530", "WH_0530_0600",
"WH_0600_0630", "WH_0630_0700", "WH_0700_0730", "WH_0730_0800",
"WH_0800_0830", "WH_0830_0900", "WH_0900_0930", "WH_0930_1000",
"WH_1000_1030", "WH_1030_1100", "WH_1100_1130", "WH_1130_1200",
"WH_1200_1230", "WH_1230_1300", "WH_1300_1330", "WH_1330_1400",
"WH_1400_1430", "WH_1430_1500", "WH_1500_1530", "WH_1530_1600",
"WH_1600_1630", "WH_1630_1700", "WH_1700_1730", "WH_1730_1800",
"WH_1800_1830", "WH_1830_1900", "WH_1900_1930", "WH_1930_2000",
"WH_2000_2030", "WH_2030_2100", "WH_2100_2130", "WH_2130_2200",
"WH_2200_2230", "WH_2230_2300", "WH_2300_2330", "WH_2330_2400",
"WORKING_HOURS", "REST_HOURS", "REST_HOURS_ANY24", "OverTime_HOURS","RestHrs7Day","Seafarer_Remarks", "Verifier_Remarks" };
List <string> lColName = new List <string>();
for (int i = 0; i < dt.Columns.Count; i++)
{
string lCoumnName = dt.Columns[i].ToString();
if (lCoumnName.StartsWith("WH_"))
{
lColName.Add(lCoumnName);
}
}
foreach (string itemc in lColName)
{
ChangeColumnDataType(dt, itemc, typeof(string));
}
foreach (DataRow item in dt.Rows)
{
foreach (DataColumn ColumnName in dt.Columns)
{
if (ColumnName.ToString().StartsWith("WH_"))
{
if (item[ColumnName.ToString()].ToString() == "0")
{
item[ColumnName.ToString()] = DBNull.Value;
}
else
{
item[ColumnName.ToString()] = "✓";
}
}
}
}
//GridViewExportUtil.ExportToExcel(dt, HeaderCaptions, DataColumnsName, "CrewHandOver.xls", "Crew Handover");
if (dt.Rows.Count > 0)
{
GridViewExportUtil.ShowExcel(dt, HeaderCaptions, DataColumnsName, "CrewRestHoursReport.xls", "Rest/Work Hour Report for " + dt.Rows[0]["Staff_rank_Code"] + "-" + dt.Rows[0]["Staff_Code"] + "-" + dt.Rows[0]["Staff_Name"]);
}
else
{
string msg = String.Format("alert('Records not found!');");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msg", msg, true);
}
}