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