protected void btnExpToExl_Click(object sender, EventArgs e)
{
try
{
DataTable dt = BLL_PB_PortageBill.Get_PerMOAllotments(int.Parse(ddlFleet.SelectedValue)
, int.Parse(ddlVessel.SelectedValue)
, ddlMonth.SelectedValue
, ddlYear.SelectedValue
, int.Parse(ddlManningAgent.SelectedValue)
, int.Parse(DDLBank.SelectedValue)
, CrewID
, Convert.ToInt32(ddlCountry.SelectedValue));
decimal iAmount = 0;
foreach (DataRow row in dt.Rows)
{
iAmount = iAmount + UDFLib.ConvertToDecimal(row["Amount"]);
}
string[] HeaderCaptions = { "Vessel", "Staff Code", "Name", "Rank", "Seaman ID", "Manning Agent", "Account No.", "Beneficiary", "Bank Name", "PBDate", "Amount", "Currency" };
string[] DataColumnsName = { "vessel_short_name", "STAFF_CODE", "Staff_fullName", "Rank_Short_Name", "Seaman_Book_Number", "Company_Name", "BankAccId", "Beneficiary", "Bank_Name", "PBill_Date", "Amount", "Currency" };
GridViewExportUtil.ShowExcel(dt, HeaderCaptions, DataColumnsName, "ReportperManningAgent", "Report-per Manning Agent- Total Amount: " + iAmount.ToString("0.00"), "");
}
catch (Exception ex)
{
}
}
protected void Load_Allotments()
{
//int? AmountValue = chkAmountIsGreaterthanZero.Checked == true ? UDFLib.ConvertIntegerToNull(1) : null;
gvAllotments.PageSize = int.Parse(ddlPageSize.SelectedValue);
DataTable dt = BLL_PB_PortageBill.Get_PerMOAllotments(int.Parse(ddlFleet.SelectedValue)
, int.Parse(ddlVessel.SelectedValue)
, ddlMonth.SelectedValue
, ddlYear.SelectedValue
, int.Parse(ddlManningAgent.SelectedValue)
, int.Parse(DDLBank.SelectedValue)
, CrewID
, Convert.ToInt32(ddlCountry.SelectedValue));
gvAllotments.DataSource = dt;
gvAllotments.DataBind();
lblRecordCount.Text = dt.Rows.Count.ToString();
if (gvAllotments.PageCount > 0)
{
lblPageStatus.Text = (gvAllotments.PageIndex + 1).ToString() + " of " + gvAllotments.PageCount.ToString();
}
else
{
lblPageStatus.Text = "0 of 0";
}
UpdatePanel2.Update();
}