protected void Page_PreRender(object sender, EventArgs e)
{
filters.Visible = true;
Master.PageTitle = SupplierEventStrings.GetText(@"ServiceSuppliersReportPageTitle");
Master.ActiveMenu = "ServiceSuppliersReport";
Master.AddClientScriptInclude(@"dgDateManager.js");
}
protected void btnExport_Click(object sender, EventArgs e)
{
System.Data.DataTable dt = new System.Data.DataTable();
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"SupplierId"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"BusinessName"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"Phone"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"ContactName"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"ContactPhone"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"CityName"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SupplierEventStrings.GetText(@"ClickNum"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SupplierEventStrings.GetText(@"ClickToCallNum"), typeof(string)));
List <SupplierServiceUI> suppliers = new List <SupplierServiceUI>();
string searchName = txtSearchName.Text.Trim();
string searchPhone = txtSearchPhone.Text.Trim();
string searchId = txtSearchSupplierId.Text.Trim();
string searchCity = txtSearchCity.Text.Trim();
DateTime from, to = new DateTime();
DateTime.TryParse(datepickerFrom.Text.ToString(), out from);
DateTime.TryParse(datepickerTo.Text.ToString(), out to);
suppliers = ServiceController.GetServiceSuppliersAndNumEvents(searchName, searchPhone, searchId, searchCity, from, to, true);
foreach (SupplierServiceUI supplier in suppliers)
{
System.Data.DataRow row = dt.NewRow();
row[0] = supplier.SupplierId;
row[1] = supplier.BusinessName;
row[2] = "\"" + supplier.Phone + "\"";
row[3] = supplier.ContactName;
row[4] = "\"" + supplier.ContactPhone + "\"";
row[5] = supplier.CityName;
row[6] = supplier.ClickNum;
row[7] = supplier.ClickToCallNum;
dt.Rows.Add(row);
}
//System.Data.DataRow sumRow = dt.NewRow();
//sumRow[0] = SuppliersStrings.GetText(@"SumSumPerMonth") + " " + suppliers.Sum(o => o.SumPerMonth);
//dt.Rows.Add(sumRow);
SpreadsheetWriter ex = SpreadsheetWriter.FromDataTable(dt, false, true);
Response.Clear();
Response.AddHeader(@"content-disposition", @"attachment;filename=ServiceSuppliersReport_" + DateTime.UtcNow.ToString(@"yyyy_MM_dd_HH_mm_ss") + "." + ex.FileExtension);
Response.Charset = @"UTF-8";
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = ex.FileContentType;
Response.BinaryWrite(System.Text.Encoding.UTF8.GetPreamble());
Response.Write(ex.ToString());
Response.End();
}
