protected void ImgExportToExcel_Click(object sender, EventArgs e)
{
string Sign_On_From = "";
string Sign_On_To = "";
string SearchString = txtSearch.Text;
int TotalDays = 0;
int PAGE_SIZE = -1;
int PAGE_INDEX = -1;
int SelectRecordCount = 0;
int FleetCode = UDFLib.ConvertToInteger(ddlFleet.SelectedValue);
int VesselID = UDFLib.ConvertToInteger(ddlVessel.SelectedValue);
if (txtSignOnFrom.Text != "")
{
Sign_On_From = UDFLib.ConvertToDate(Convert.ToString(txtSignOnFrom.Text), UDFLib.GetDateFormat()).ToString();
}
if (txtSignOnTo.Text != "")
{
Sign_On_To = UDFLib.ConvertToDate(Convert.ToString(txtSignOnTo.Text), UDFLib.GetDateFormat()).ToString();
}
DataTable dt = BLL_Crew_CrewList.Get_Super_Att_Vessel_Report(FleetCode, VesselID, Sign_On_From, Sign_On_To, SearchString, GetSessionUserID(), PAGE_SIZE, PAGE_INDEX, ref SelectRecordCount, ref TotalDays);
dt.Columns.Add("Joining_Date1");
dt.Columns.Add("Sign_On_Date1");
dt.Columns.Add("Sign_Off_Date1");
foreach (DataRow dr in dt.Rows)
{
if (dr["Joining_Date"].ToString() != "" && dr["Joining_Date"] != null)
{
dr["Joining_Date1"] = " " + UDFLib.ConvertUserDateFormat(Convert.ToString(dr["Joining_Date"]), Convert.ToString(Session["User_DateFormat"]));
}
if (dr["Sign_On_Date"].ToString() != "" && dr["Sign_On_Date"] != null)
{
dr["Sign_On_Date1"] = " " + UDFLib.ConvertUserDateFormat(Convert.ToString(dr["Sign_On_Date"]));
}
if (dr["Sign_Off_Date"].ToString() != "" && dr["Sign_Off_Date"] != null)
{
dr["Sign_Off_Date1"] = " " + UDFLib.ConvertUserDateFormat(Convert.ToString(dr["Sign_Off_Date"]));
}
}
dt.AcceptChanges();
string[] HeaderCaptions = { "Vessel", "S/Code", "Name", "Rank", "Contract Date", "S/On Date", "S/Off Date", "Days ONBD" };
string[] DataColumnsName = { "Vessel_Short_Name", "Staff_Code", "Staff_Name", "Rank_Short_Name", "Joining_Date1", "Sign_On_Date1", "Sign_Off_Date1", "DaysOnBoard" };
GridViewExportUtil.ExportToExcel(dt, HeaderCaptions, DataColumnsName, "Superintendents_attending_vessels.xls", "Superintendents attending vessels Report");
}
protected void Load_Report()
{
int FleetCode = UDFLib.ConvertToInteger(ddlFleet.SelectedValue);
int VesselID = UDFLib.ConvertToInteger(ddlVessel.SelectedValue);
string Sign_On_From = "";
string Sign_On_To = "";
if (txtSignOnFrom.Text != "")
{
Sign_On_From = UDFLib.ConvertToDate(Convert.ToString(txtSignOnFrom.Text), UDFLib.GetDateFormat()).ToString();
}
if (txtSignOnTo.Text != "")
{
Sign_On_To = UDFLib.ConvertToDate(Convert.ToString(txtSignOnTo.Text), UDFLib.GetDateFormat()).ToString();
}
string SearchString = txtSearch.Text;
int PAGE_SIZE = ucCustomPager_CrewList.PageSize;
int PAGE_INDEX = ucCustomPager_CrewList.CurrentPageIndex;
int SelectRecordCount = ucCustomPager_CrewList.isCountRecord;
int TotalDays = 0;
DataTable dt = BLL_Crew_CrewList.Get_Super_Att_Vessel_Report(FleetCode, VesselID, Sign_On_From, Sign_On_To, SearchString, GetSessionUserID(), PAGE_SIZE, PAGE_INDEX, ref SelectRecordCount, ref TotalDays);
if (ucCustomPager_CrewList.isCountRecord == 1)
{
ucCustomPager_CrewList.CountTotalRec = SelectRecordCount.ToString();
ucCustomPager_CrewList.BuildPager();
}
GridView_Crew.DataSource = dt;
GridView_Crew.DataBind();
lblGrandTotal.Text = TotalDays.ToString();
}
