protected void LoadItems()
{
if (!HasEditPermission)
{
dgSuppliers.Columns[dgSuppliers.Columns.Count - 1].Visible = false;
}
string searchName = "%" + txtSearchName.Text.Trim() + "%";
string searchPhone = "%" + txtSearchPhone.Text.Trim() + "%";
dgSuppliers.VirtualItemCount = SupplierController.GetAllSuppliersUI(true, searchName, searchPhone).Count;
if (dgSuppliers.VirtualItemCount == 0)
{
phHasItems.Visible = false;
phHasNoItems.Visible = true;
lblNoItems.Text = SuppliersStrings.GetText(@"MessageNoSuppliersFound");
}
else
{
phHasItems.Visible = true;
phHasNoItems.Visible = false;
if (dgSuppliers.PageSize * dgSuppliers.CurrentPageIndex > dgSuppliers.VirtualItemCount)
{
dgSuppliers.CurrentPageIndex = 0;
hfCurrentPageIndex_dgSuppliers.Value = dgSuppliers.CurrentPageIndex.ToString();
}
List <SupplierUI> items = SupplierController.GetAllSuppliersUI(true, searchName, searchPhone, dgSuppliers.PageSize, dgSuppliers.CurrentPageIndex);
BindList(items);
}
}
protected void btnExportForCRM_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(@"SupplierServices"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(AppUsersStrings.GetText(@"Address"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"CityName"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"Phone"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"ContactPhone"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"ContactName"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"Email"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"SupplierType"), typeof(string)));
List <SupplierUI> suppliers = new List <SupplierUI>();
string searchName = "%" + txtSearchName.Text.Trim() + "%";
string searchPhone = "%" + txtSearchPhone.Text.Trim() + "%";
suppliers = SupplierController.GetAllSuppliersUI(true, searchName, searchPhone);
foreach (SupplierUI supplier in suppliers)
{
int i = 0;
System.Data.DataRow row = dt.NewRow();
row[i++] = supplier.SupplierId;
row[i++] = supplier.BusinessName;
row[i++] = getSupplierServices(supplier);
row[i++] = supplier.Street + " " + supplier.HouseNum;
row[i++] = supplier.CityName;
row[i++] = "=\"" + supplier.Phone + "\"";
row[i++] = "=\"" + supplier.ContactPhone + "\"";
row[i++] = supplier.ContactName;
row[i++] = supplier.Email;
row[i++] = supplier.IsProduct ? SuppliersStrings.GetText(@"IsProduct") : SuppliersStrings.GetText(@"IsService");
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=SuppliersExportForCRM_" + 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();
}
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(@"BusinessName"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"Email"), 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(SuppliersStrings.GetText(@"Street"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"HouseNum"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"Precent"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"SumPerMonth"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"CreateDate"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"citiesSupplied"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"citiesHomeService"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"MaxWinningsNum"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"AvgRate"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"SupplierType"), typeof(string)));
List <SupplierUI> suppliers = new List <SupplierUI>();
string searchName = "%" + txtSearchName.Text.Trim() + "%";
string searchPhone = "%" + txtSearchPhone.Text.Trim() + "%";
suppliers = SupplierController.GetAllSuppliersUI(true, searchName, searchPhone);
foreach (SupplierUI supplier in suppliers)
{
System.Data.DataRow row = dt.NewRow();
row[0] = supplier.BusinessName;
row[1] = supplier.Email;
row[2] = "\"" + supplier.Phone + "\"";
row[3] = supplier.ContactName;
row[4] = "\"" + supplier.ContactPhone + "\"";
row[5] = supplier.CityName;
row[6] = supplier.Street;
row[7] = supplier.HouseNum;
row[8] = supplier.Precent;
row[9] = supplier.SumPerMonth;
row[10] = "\"" + supplier.CreateDate + "\"";
row[11] = (supplier.citiesSupplied.Count == 0 || supplier.citiesSupplied == null) ? "" : String.Join(", ", supplier.citiesSupplied.Select(o => o.CityName));
row[12] = (supplier.citiesHomeService.Count == 0 || supplier.citiesHomeService == null) ? "" : String.Join(", ", supplier.citiesHomeService.Select(o => o.CityName));
row[13] = supplier.MaxWinningsNum;
row[14] = supplier.AvgRate;
row[15] = supplier.IsProduct ? SuppliersStrings.GetText(@"IsProduct") : SuppliersStrings.GetText(@"IsService");
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=SuppliersExport_" + 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();
}
