// // GET: /TelesalePluginCode/ public ActionResult Index() { //using (IDbConnection dbConn = Helpers.OrmliteConnection.openConn()) //{ // OrmLiteConfig.DialectProvider.UseUnicode = true; // dbConn.DropTables(typeof(DC_Org_AvoidCallingTime)); // const bool overwrite = false; // dbConn.CreateTables(overwrite, typeof(DC_Org_AvoidCallingTime)); //} using (IDbConnection dbConn = Helpers.OrmliteConnection.openConn()) { ViewBag.AVoidCallTime = dbConn.Select <DC_AvoidCallingTimeFrame>("SELECT * FROM DC_AvoidCallingTimeFrame"); } if (asset.View) { ViewData["AllowCreate"] = asset.Create; ViewData["AllowUpdate"] = asset.Update; ViewData["AllowDelete"] = asset.Delete; ViewData["AllowExport"] = asset.Export; ViewData["Asset"] = asset; using (var dbConn = Helpers.OrmliteConnection.openConn()) { ViewData["UserGroups"] = dbConn.Select <Groups>(); } ViewBag.listAvoidCallTime = Deca_Code_Master.GetDeca_Code_Masters("[CodeType]='AvoidCallTime'", "").OrderBy(s => s.CodeID); ViewBag.listAllowedServices = Deca_Code_Master.GetDeca_Code_Masters("[CodeType]='AllowedServices'", "").OrderBy(s => s.CodeID); ViewBag.listCollectionType = Deca_Code_Master.GetDeca_Code_Masters("[CodeType]='CollectionType'", "").OrderBy(s => s.CodeID); ViewBag.listRegion = DC_Location_Region.GetList_Regions(); return(View()); } else { return(RedirectToAction("NoAccessRights", "Error")); } }
public ActionResult Export([DataSourceRequest] DataSourceRequest request) { if (asset.Export) { var data = DW_DC_Organization.GetListOrganizationForTeleSale().ToList(); IEnumerable datas = data.ToDataSourceResult(request).Data; //using (ExcelPackage excelPkg = new ExcelPackage()) FileInfo fileInfo = new FileInfo(Server.MapPath(@"~\ExportExcelFile\DC_OrganizationForTeleSale.xlsx")); var excelPkg = new ExcelPackage(fileInfo); ExcelWorksheet dataSheet = excelPkg.Workbook.Worksheets["DC_OrganizationForTeleSale"]; int rowData = 1; foreach (DW_DC_Organization item in datas) { int i = 1; rowData++; dataSheet.Cells[rowData, i++].Value = item.OrganizationID; dataSheet.Cells[rowData, i++].Value = item.LongName; dataSheet.Cells[rowData, i++].Value = item.Address; if (string.IsNullOrEmpty(item.CheckAllowServices)) { dataSheet.Cells[rowData, i++].Value = ""; } else { if (item.CheckAllowServices == "1") { dataSheet.Cells[rowData, i++].Value = "Airtime"; } else if (item.CheckAllowServices == "2") { dataSheet.Cells[rowData, i++].Value = "Airtime, Cashdvance, Physical goods, Services"; } else { dataSheet.Cells[rowData, i++].Value = "Airtime, Physical goods, Services"; } } dataSheet.Cells[rowData, i++].Value = item.SalesPriority; if (!string.IsNullOrEmpty(item.CollectionType)) { var data1 = Deca_Code_Master.GetDeca_Code_Masters("[CodeID] = '" + item.CollectionType + "'", "").FirstOrDefault(); dataSheet.Cells[rowData, i++].Value = data1.Description; } else { dataSheet.Cells[rowData, i++].Value = ""; } dataSheet.Cells[rowData, i++].Value = item.TeleSaleNote; dataSheet.Cells[rowData, i++].Value = item.KeyPerson; dataSheet.Cells[rowData, i++].Value = item.OnsiteInfo; dataSheet.Cells[rowData, i++].Value = item.DeliveryNote; dataSheet.Cells[rowData, i++].Value = item.CreditLimitRules; dataSheet.Cells[rowData, i++].Value = item.SettlementDate; dataSheet.Cells[rowData, i++].Value = item.DeliveryNote; dataSheet.Cells[rowData, i++].Value = item.Note; dataSheet.Cells[rowData, i++].Value = item.RegionalBD; dataSheet.Cells[rowData, i++].Value = item.DueDate; } MemoryStream output = new MemoryStream(); excelPkg.SaveAs(output); string fileName = "DC_OrganizationForTeleSale_" + DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xlsx"; string contentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; output.Position = 0; return(File(output.ToArray(), contentType, fileName)); } else { ModelState.AddModelError("", "You don't have permission to export data"); return(File("", //The binary data of the XLS file "application/vnd.ms-excel", //MIME type of Excel files "DC_TelesaleAgent" + DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xls")); //Suggested file name in the "Save as" dialog which will be displayed to the end user } }