public string ExcelReport(DataSourceLoadOptions loadOptions, string test, bool?showSelected, string selectedRecord, bool?only_new, bool?show_classified, string ekk_guid_list)
{
int?event_id = null;
PortalDMTOSModel portalDMTOS = new PortalDMTOSModel();
SYS_AUTHORIZE_USERResult au = JsonConvert.DeserializeObject <SYS_AUTHORIZE_USERResult>(HttpContext.Session.GetString("SYS_AUTHORIZE_USER2_R"));
//List<UI_SELECT_GRID_SETTINGS2Result> grid_settings = portalDMTOS.UI_SELECT_GRID_SETTINGS2(au.id, "PRC_SELECT_ORDER_ITEMS_GKI").ToList();
APL_SELECT_PROJECT_STATES_FOR_DDResult delegated_user = JsonConvert.DeserializeObject <APL_SELECT_PROJECT_STATES_FOR_DDResult>(HttpContext.Session.GetString("deleagting_user"));
List <PRC_SELECT_ORDER_ITEMS_GKIResult> x = null;
if (HttpContext.Session.Keys.Contains("PRC_SELECT_ORDER_ITEMS_GKIResult") &&
HttpContext.Session.Keys.Contains("PRC_SELECT_ORDER_ITEMS_GKIResult_show_classified") &&
HttpContext.Session.Keys.Contains("PRC_SELECT_ORDER_ITEMS_GKIResult_only_new")
& JsonConvert.DeserializeObject <bool?>(HttpContext.Session.GetString("PRC_SELECT_ORDER_ITEMS_GKIResult_show_classified")) == show_classified
& JsonConvert.DeserializeObject <bool?>(HttpContext.Session.GetString("PRC_SELECT_ORDER_ITEMS_GKIResult_only_new")) == only_new)
{
x = JsonConvert.DeserializeObject <List <PRC_SELECT_ORDER_ITEMS_GKIResult> >(HttpContext.Session.GetString("PRC_SELECT_ORDER_ITEMS_GKIResult"));
}
else
{
event_id = portalDMTOS.SYS_START_EVENT(delegated_user.id, "PRC_SELECT_ORDER_ITEMS_GKI", Convert.ToString(show_classified) + "," + Convert.ToString(only_new) + "," + Convert.ToString(delegated_user.id)).FirstOrDefault().event_id;
x = portalDMTOS.PRC_SELECT_ORDER_ITEMS_GKI(show_classified, only_new, ekk_guid_list, delegated_user.id, event_id).ToList();
HttpContext.Session.SetString("PRC_SELECT_ORDER_ITEMS_GKIResult", JsonConvert.SerializeObject(x));
HttpContext.Session.SetString("PRC_SELECT_ORDER_ITEMS_GKIResult_only_new", JsonConvert.SerializeObject(only_new));
HttpContext.Session.SetString("PRC_SELECT_ORDER_ITEMS_GKIResult_show_classified", JsonConvert.SerializeObject(show_classified));
}
int[] selectedRecordMass = null;
if (selectedRecord != null && selectedRecord != "")
{
selectedRecordMass = selectedRecord.Split(',').Select(Int32.Parse).ToArray();
}
if (Convert.ToBoolean(showSelected))
{
x = x.Join(selectedRecordMass, y => y.id, m => m, (y, m) => y).ToList();
}
DevExtreme.AspNet.Data.ResponseModel.LoadResult loadrResults = DataSourceLoader.Load(x, loadOptions);
string j = JsonConvert.SerializeObject(loadrResults.data);
List <PRC_SELECT_ORDER_ITEMS_GKIResult> list = JsonConvert.DeserializeObject <List <PRC_SELECT_ORDER_ITEMS_GKIResult> >(j);
string templatePath = Path.Combine(_env.ContentRootPath + "\\wwwroot\\AppData\\Templates\\ExcelTemplates", "PRC_SELECT_ORDER_ITEMS_GKI" + ".xlsx");
Guid guid = Guid.NewGuid();
string physicalPath = Path.Combine(_env.ContentRootPath + "\\wwwroot\\AppData\\Templates\\ExcelTemplates", guid + ".xlsx");
System.IO.File.Copy(templatePath, physicalPath);
//ExcelReports<PRC_SELECT_ORDER_ITEMS_GKIResult> excel =
// new ExcelReports<PRC_SELECT_ORDER_ITEMS_GKIResult>(x,1,1, grid_settings, physicalPath, "PRC_SELECT_ORDER_ITEMS_GKI", 0, null,()=> portalDMTOS.PRC_SELECT_ORDER_ITEMS_GKI(show_classified, only_new, delegated_user.id, event_id).ToList());
ExcelReports <PRC_SELECT_ORDER_ITEMS_GKIResult> excel =
new ExcelReports <PRC_SELECT_ORDER_ITEMS_GKIResult>(x, 1, 1, delegated_user.id, physicalPath, "PRC_SELECT_ORDER_ITEMS_GKI", 0, null);
excel.ExcelReport();
if (event_id != null)
{
portalDMTOS.SYS_FINISH_EVENT(event_id, physicalPath);
}
return(Convert.ToString(guid));
}
public string ExcelReport(DataSourceLoadOptions loadOptions, bool?showSelected, string selectedRecord)
{
PortalDMTOSModel portalDMTOS = new PortalDMTOSModel();
SYS_AUTHORIZE_USERResult au = JsonConvert.DeserializeObject <SYS_AUTHORIZE_USERResult>(HttpContext.Session.GetString("SYS_AUTHORIZE_USER2_R"));
APL_SELECT_PROJECT_STATES_FOR_DDResult delegated_user = JsonConvert.DeserializeObject <APL_SELECT_PROJECT_STATES_FOR_DDResult>(HttpContext.Session.GetString("deleagting_user"));
List <OMC_SELECT_SVRResult> x = null;
int?event_id = null;
if (HttpContext.Session.Keys.Contains("OMC_SELECT_SVR"))
{
x = JsonConvert.DeserializeObject <List <OMC_SELECT_SVRResult> >(HttpContext.Session.GetString("OMC_SELECT_SVR"));
}
else
{
event_id = portalDMTOS.SYS_START_EVENT(delegated_user.id, "OMC_SELECT_SVR", "").FirstOrDefault().event_id;
x = portalDMTOS.OMC_SELECT_SVR(event_id, null, delegated_user.id, au.id).ToList();
HttpContext.Session.SetString("OMC_SELECT_SVRResult", JsonConvert.SerializeObject(x));
}
int[] selectedRecordMass = null;
if (selectedRecord != null && selectedRecord != "")
{
selectedRecordMass = selectedRecord.Split(',').Select(Int32.Parse).ToArray();
}
if (Convert.ToBoolean(showSelected))
{
x = x.Join(selectedRecordMass, y => y.id, m => m, (y, m) => y).ToList();
}
DevExtreme.AspNet.Data.ResponseModel.LoadResult loadrResults = DataSourceLoader.Load(x, loadOptions);
string j = JsonConvert.SerializeObject(loadrResults.data);
List <OMC_SELECT_SVRResult> list = JsonConvert.DeserializeObject <List <OMC_SELECT_SVRResult> >(j);
string templatePath = Path.Combine(_env.ContentRootPath + "\\wwwroot\\AppData\\ExcelTemplates", "EMPTY" + ".xlsx");
Guid guid = Guid.NewGuid();
string physicalPath = Path.Combine(_env.ContentRootPath + "\\wwwroot\\AppData\\ExportFiles", guid + ".xlsx");
System.IO.File.Copy(templatePath, physicalPath);
ExcelReports <OMC_SELECT_SVRResult> excel =
new ExcelReports <OMC_SELECT_SVRResult>(list, 1, 1, delegated_user.id, physicalPath, "OMC_SELECT_SVR", 0, null);
excel.ExcelReport();
if (event_id != null)
{
portalDMTOS.SYS_FINISH_EVENT(event_id, physicalPath);
}
return(Convert.ToString("ExportFiles\\" + guid + ".xlsx"));
}
