private void Excelbutton_Click(object sender, EventArgs e)
{
fromDate = Convert.ToString(Convert.ToDateTime(fromDateTimePicker.Text).ToShortDateString());
toDate = Convert.ToString(Convert.ToDateTime(toDateTimePicker.Text).ToShortDateString());
EfficencyBLL efficency = new EfficencyBLL();
DataTable dt = new DataTable();
BindingSource dataBind = new BindingSource();
dt = efficency.GetDepartmentWiseReport(fromDate, toDate, plant);
dataBind.DataSource = dt;
DepartmentWisedataGridView.DataSource = dataBind;
if (DepartmentWisedataGridView.Rows.Count > 0)
{
try
{
// Bind table data to Stream Writer to export data to respective folder
StreamWriter wr = new StreamWriter(@"E:\\Item_Wise_Repports.xls");
wr.Write("HIRDARAMANI APPARELS BANGLADESH");
wr.WriteLine();
wr.Write("Department wise sample summery");
wr.WriteLine();
wr.WriteLine();
wr.WriteLine();
// Write Columns to excel file
for (int i = 0; i < dt.Columns.Count; i++)
{
wr.Write(dt.Columns[i].ToString().ToUpper() + "\t");
}
wr.WriteLine();
//write rows to excel file
for (int i = 0; i < (dt.Rows.Count); i++)
{
for (int j = 0; j < dt.Columns.Count; j++)
{
if (dt.Rows[i][j] != null)
{
wr.Write(Convert.ToString(dt.Rows[i][j]) + "\t");
}
else
{
wr.Write("\t");
}
}
wr.WriteLine();
}
wr.Close();
}
catch (Exception ex)
{
throw ex;
}
}
}
public void DepartmentWiseForDepartmentwise(string FromDate, string ToDate, string plant)
{
EfficencyBLL efficency = new EfficencyBLL();
DataTable dt = new DataTable();
BindingSource dataBind = new BindingSource();
try
{
dt = efficency.GetDepartmentWiseReport(FromDate, ToDate, plant);
dataBind.DataSource = dt;
DepartmentWisedataGridView.DataSource = dataBind;
}
catch (Exception ex)
{
}
}