protected void btnexcelDownload_Click(object sender, EventArgs e)
{
ModalPopupExtender2.Hide();
SubBusinessUnitReportingChild obj = new SubBusinessUnitReportingChild();
DataSet ds = obj.GetSKPickingBoard2("Select One", "Select One", "Select One", "Select One");
WorkbookEngine we = new WorkbookEngine();
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (!dr.IsNull("ExpirationDate"))
{
dr.Delete();
}
//DateTime expirationDate = Convert.ToDateTime(dr["ExpirationDate"].ToString());
}
we.ExportDataSetToExcel(ds.Tables[0], "SubBusinessUnit Reporting");
}
private void BindGridView()
{
int count;
SubBusinessUnitReportingChild obj = new SubBusinessUnitReportingChild();
string subBusinessUnitName = ddlSubBusinessUnitName.SelectedValue.ToString();
string subBusinessUnitManagerName = ddlSubBusinessUnitManagerName.SelectedValue.ToString();
string businessUnitName = ddlBusinessUnitName.SelectedValue.ToString();
string companyName = ddlCompanyName.SelectedValue.ToString();
DataSet ds = obj.GetSKPickingBoard2(subBusinessUnitName, businessUnitName, companyName, subBusinessUnitManagerName);//, companyName);// fromDate, toDate, period, fromQuantity, toQuantity, fromAmount, toAmount, adjustmentType, countryName, subBusinessUnitName, companyName, subSegmentName, accountSubTypeName, subCategoryName, rblMeasurementSystemText);
SubBusinessUnitGridView.DataSource = ds.Tables[0];
SubBusinessUnitGridView.DataBind();
count = ds.Tables[0].Rows.Count;
if (count > 1)
{
lblRecordCount.Text = "Record Count: " + count;
}
else
{
lblRecordCount.Text = "Record Count: " + count;
}
}