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(); }