public IActionResult Index() { PortalDMTOSModel portalDMTOS = new PortalDMTOSModel(); SYS_AUTHORIZE_USERResult user = 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")); ViewBag.FunctionSection = portalDMTOS.UI_SELECT_LINK_SECTIONS_FOR_DD(delegated_user.id); List <UI_SELECT_GRID_SETTINGSResult> grid_settings = portalDMTOS.UI_SELECT_GRID_SETTINGS(delegated_user.id, "UI_SELECT_LINK_FUNCTIONS", null, 1).ToList(); Settings settings = new Settings(); for (int i = 0; i < grid_settings.Count; i++) { grid_settings[i].global_visible = grid_settings[i].global_visible == null ? true : grid_settings[i].global_visible; grid_settings[i].is_visible = grid_settings[i].is_visible == null ? true : grid_settings[i].is_visible; grid_settings[i].global_editable = grid_settings[i].global_editable == null ? true : grid_settings[i].global_editable; ViewData["CK_UI_" + grid_settings[i].field_description] = grid_settings[i].is_visible & grid_settings[i].global_visible; ViewData["CK_UI_" + grid_settings[i].field_description + "_width"] = grid_settings[i].width; ViewData["CK_UI_" + grid_settings[i].field_description + "_ru"] = grid_settings[i].russian_field_description; ViewData["CK_UI_" + grid_settings[i].field_description + "_pos"] = grid_settings[i].number; ViewData["CK_UI_" + grid_settings[i].field_description + "_edit"] = grid_settings[i].global_editable; } settings.actionName = "UpdateSettingsOfGrid"; settings.checkBoxClass = "UserSettingsCheckbox"; settings.controllerName = "Common"; settings.flowWindowName = "UserSettings"; settings.storedProcedure = "UI_SELECT_LINK_FUNCTIONS"; settings.widthClass = "UserSettingsWidth"; settings.positionClass = "PositionClass"; settings.gridSettings = grid_settings; ViewBag.Settings = settings; return(View()); }
public string RemoveFunctions(string FunctionsRecords) { SYS_AUTHORIZE_USERResult user = 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")); PortalDMTOSModel portalDMTOS = new PortalDMTOSModel(); string errors = ""; while (FunctionsRecords[0] == ',') { FunctionsRecords = FunctionsRecords.Substring(1); } foreach (int id in FunctionsRecords.Split(',').Select(x => Int32.Parse(x))) { string error = portalDMTOS.UI_DELETE_LINK_FUNCTION(id, delegated_user.id, user.id).FirstOrDefault().error_description; if (error != "" && error != null) { if (errors != "") { errors = errors + "__" + error; } else { errors = errors + error; } } } return(errors); }
public ActionResult UpdateFileUploader(string project_id, string project_description) { 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")); if (project_description == "" | project_description == null) { project_description = ""; } else { project_description = "Загрузка СВР по проекту " + project_description; } FileUploader fileUploader = new FileUploader("Uploader", "UploadFileAccept", "/Common/UploadFile", "ReportGk", "upload_class", "UploaderFlowWindow", "[{Name:\"loading_id\", Value:31}, " + "{Name:\"project_id\", Value:" + project_id + "}, " + "{Name:\"user_id\", Value:" + Convert.ToString(delegated_user.id) + "}," + "{Name:\"real_user_id\", Value:" + Convert.ToString(au.id) + "}]", "[{Name:\"loading_id\", Value:\"\"}, {Name:\"loading_id\", Value:null}, {Name:\"user_id\", Value:" + Convert.ToString(delegated_user.id) + "}," + "{Name:\"real_user_id\", Value:" + Convert.ToString(au.id) + "}]", "OMC_INSERT_SVR_LOADING_ITEM", "OMC_SELECT_SVR_LOADING_ITEM", "OMC_SELECT_SVR_TEMPLATE", "Шаблон загрузки СВР", //"PRC_SELECT_ORDER_ITEMS_GKI", 31, "ReportGk", "", //1, 4, 1, 5, 0 , project_description); return(PartialView("FileUploader", fileUploader)); }
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 async Task <IActionResult> Index(bool?showSelected) { var webRoot = _env.WebRootPath; PortalDMTOSModel portalDMTOS = new PortalDMTOSModel(); IEnumerable <APL_SELECT_PROJECT_STATES_FOR_DDResult> apl = await portalDMTOS.APL_SELECT_PROJECT_STATES_FOR_DDAsync(); 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 <UI_SELECT_GRID_SETTINGSResult> grid_settings = portalDMTOS.UI_SELECT_GRID_SETTINGS(delegated_user.id, "OMC_SELECT_SVR", null, 1).ToList(); Settings settings = new Settings(); for (int i = 0; i < grid_settings.Count; i++) { grid_settings[i].global_visible = grid_settings[i].global_visible == null ? true : grid_settings[i].global_visible; grid_settings[i].is_visible = grid_settings[i].is_visible == null ? true : grid_settings[i].is_visible; grid_settings[i].global_editable = grid_settings[i].global_editable == null ? true : grid_settings[i].global_editable; ViewData["CK_UI_" + grid_settings[i].field_description] = grid_settings[i].is_visible & grid_settings[i].global_visible; ViewData["CK_UI_" + grid_settings[i].field_description + "_width"] = grid_settings[i].width; ViewData["CK_UI_" + grid_settings[i].field_description + "_ru"] = grid_settings[i].russian_field_description; ViewData["CK_UI_" + grid_settings[i].field_description + "_pos"] = grid_settings[i].number; ViewData["CK_UI_" + grid_settings[i].field_description + "_edit"] = grid_settings[i].global_editable; } settings.actionName = "UpdateSettingsOfGrid"; settings.checkBoxClass = "UserSettingsCheckbox"; settings.controllerName = "Common"; settings.flowWindowName = "UserSettings"; settings.storedProcedure = "OMC_SELECT_SVR"; settings.widthClass = "UserSettingsWidth"; settings.positionClass = "PositionClass"; settings.gridSettings = grid_settings; ViewBag.Settings = settings; ViewData["Columns_Array"] = grid_settings;//homeGridSettings; ViewBag.NOT_CLOSE_PROJECTS_FOR_DD = portalDMTOS.UI_SELECT_DROPDOWN("NOT_CLOSE_PROJECTS", null, delegated_user.id, au.id); FileUploader fileUploader = new FileUploader("Uploader", "UploadFileAccept", "/Common/UploadFile", "ReportGk", "upload_class", "UploaderFlowWindow", "[{Name:\"loading_id\", Value:31}, " + "{Name:\"project_id\", Value:null}, " + "{Name:\"user_id\", Value:" + Convert.ToString(delegated_user.id) + "}," + "{ Name:\"real_user_id\", Value:" + Convert.ToString(au.id) + "}]", "[{Name:\"loading_id\", Value:\"\"}, {Name:\"loading_id\", Value:null}, {Name:\"user_id\", Value:" + Convert.ToString(delegated_user.id) + "}," + "{Name:\"real_user_id\", Value:" + Convert.ToString(au.id) + "}]", "OMC_INSERT_SVR_LOADING_ITEM", "OMC_SELECT_SVR_LOADING_ITEM", "OMC_SELECT_SVR_TEMPLATE", "Шаблон загрузки СВР", //"PRC_SELECT_ORDER_ITEMS_GKI", 31, "ReportGk", "", //1, 5, 1, 5, 0 , ""); ViewBag.FileUploader = fileUploader; return(View()); }
public string CancelState9(int?project_id) { 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")); string error = portalDMTOS.APL_UPDATE_PROJECT_REQUIREMENT_STATE_9_2(project_id, -9, delegated_user.id, au.id).FirstOrDefault().error; return(error); }
public string SendRSSToDMTOS(int?project_id) { 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")); string error = portalDMTOS.APL_SEND_RSS_TO_DMTOS(project_id, delegated_user.id, au.id).FirstOrDefault().error_description; return(error); }
public string StateUpdate(string id_list, int?state_id, string reason_change_state) { 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")); string error = portalDMTOS.APL_UPDATE_PRSLNO_STATE(id_list, state_id, reason_change_state, delegated_user.id, au.id).FirstOrDefault().error_description; return(error); }
public string AddQuantity(int?main_prslno_id, double?quantity) { 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")); string error = portalDMTOS.APL_ADD_PRSLNO_QUANTITY(main_prslno_id, quantity, delegated_user.id, au.id).FirstOrDefault().error_description; return(error); }
public string DeleteMailNotification(int?id) { 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")); string error = portalDMTOS.UI_DELETE_MAIL_NOTIFICATION(id, delegated_user.id, au.id).FirstOrDefault().error_description; return(error); }
public string ApproveRequestNPS(string item_id_list, int is_nps) { //SYS_AUTHORIZE_USERResult au = JsonConvert.DeserializeObject<SYS_AUTHORIZE_USERResult>(HttpContext.Session.GetString("SYS_AUTHORIZE_USER2_R")); 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")); string error = portalDMTOS.APL_UPDATE_PROJECT_REQUIREMENT_CHANGE_REQUEST_STATE2(item_id_list, is_nps, delegated_user.id, au.id).FirstOrDefault().error_description; return(error); }
public string SetColor(string grid_type, string item_id_list, string color) { color = color.Replace("#", ""); 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")); string error = portalDMTOS.UI_UPDATE_GRID_ROW_SETTINGS(grid_type, item_id_list, color, delegated_user.id, au.id).FirstOrDefault().error_description; return(error); }
public ActionResult StatePartialUpdate() { //SYS_AUTHORIZE_USERResult au = JsonConvert.DeserializeObject<SYS_AUTHORIZE_USERResult>(HttpContext.Session.GetString("SYS_AUTHORIZE_USER2_R")); 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 <APL_SELECT_PROJECT_STATES_FOR_DDResult> CHANGE_STATES = portalDMTOS.UI_SELECT_DROPDOWN("CHANGE_STATES", null, delegated_user.id, au.id).ToList(); return(PartialView("~/Views/Requirements/Shared/StatePartialUpdate.cshtml", CHANGE_STATES)); }
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")); }
public string UpdateFunctions(int?id, int?section_id, string title, string stored_procedure, string description) { SYS_AUTHORIZE_USERResult user = 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")); PortalDMTOSModel portalDMTOS = new PortalDMTOSModel(); string error = ""; if (id == null) { error = portalDMTOS.UI_INSERT_LINK_FUNCTION(section_id, title, stored_procedure, description, delegated_user.id, user.id).FirstOrDefault().error_description; } else { error = portalDMTOS.UI_UPDATE_LINK_FUNCTION(id, section_id, title, stored_procedure, description, delegated_user.id, user.id).FirstOrDefault().error_description; } return(Convert.ToString(error)); }
public IActionResult Import(int?project_id) { 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")); FileUploader fileUploader = new FileUploader("Uploader", "UploadFileAccept", "/Common/UploadFile", "ReportGk", "upload_class", "UploaderFlowWindow", "[{Name:\"loading_id\", Value:2}, {Name:\"project_id\", Value:" + Convert.ToString(project_id) + "}, {Name:\"user_id\", Value:" + Convert.ToString(delegated_user.id) + "},{ Name:\"real_user_id\", Value:" + Convert.ToString(au.id) + "}]", "[{Name:\"loading_id\", Value:\"\"}, {Name:\"loading_id\", Value:null}, {Name:\"user_id\", Value:" + Convert.ToString(delegated_user.id) + "}," + "{Name:\"real_user_id\", Value:" + Convert.ToString(au.id) + "}]", "APL_INSERT_PROJECT_REQUIREMENT_LOADING_ITEM", "APL_SELECT_PROJECT_REQUIREMENT_LOADING_ITEMS2", "APL_SELECT_PROJECT_REQUIREMENT_TEMPLATE", "Шаблон загрузки позиций проектной потребности", //"PRC_SELECT_ORDER_ITEMS_GKI", 2, "ReportGk", "" //, 1,1,1,2 , 0, "Загрузка/изменение проектной потребности" ); //ViewBag.FileUploader = fileUploader; return(PartialView("FileUploader", fileUploader)); }
public override void OnActionExecuting(ActionExecutingContext filterContext) { //filterContext.HttpContext.Session.GetString("SYS_AUTHORIZE_USER2_R"); PortalDMTOSModel portalDMTOS = new PortalDMTOSModel(); if (filterContext.HttpContext.Session.Keys.Contains("SYS_AUTHORIZE_USER2_R")) { APL_SELECT_PROJECT_STATES_FOR_DDResult delegated_user = JsonConvert.DeserializeObject <APL_SELECT_PROJECT_STATES_FOR_DDResult>(filterContext.HttpContext.Session.GetString("deleagting_user")); //filterContext.HttpContext.Session.SetString("FAQ", JsonConvert.SerializeObject(portalDMTOS.UI_SELECT_LINK_PAGE_NOTE(filterContext.RouteData.Values["Controller"].ToString(), filterContext.RouteData.Values["Action"].ToString(), delegated_user.id).FirstOrDefault().http_text)); SYS_AUTHORIZE_USERResult user = JsonConvert.DeserializeObject <SYS_AUTHORIZE_USERResult>(filterContext.HttpContext.Session.GetString("SYS_AUTHORIZE_USER2_R")); filterContext.HttpContext.Session.SetString("message_panel", JsonConvert.SerializeObject(portalDMTOS.SYS_SELECT_MESSAGES(user.id, delegated_user.id).FirstOrDefault().description)); UI_SELECT_LINKResult link_info = null; //UI_SELECT_LINKResult link_info = JsonConvert.DeserializeObject<UI_SELECT_LINKResult>(HttpContextAccessor.HttpContext.Session.GetString("link_info")); string action = filterContext.RouteData.Values["Action"].ToString(); string controller = filterContext.RouteData.Values["Controller"].ToString(); string link_information_param = null; if (filterContext.ActionArguments.Any(x => x.Key == "link_information_param")) { link_information_param = Convert.ToString(filterContext.ActionArguments["link_information_param"]); } if (filterContext.RouteData.Values["Action"] != null && filterContext.RouteData.Values["Controller"] != null) { link_info = portalDMTOS.UI_SELECT_LINK(action, controller, link_information_param).FirstOrDefault(); } if (link_info == null) { link_info = portalDMTOS.UI_SELECT_LINK("Index", "Home", link_information_param).FirstOrDefault(); } filterContext.HttpContext.Session.SetString("link_info", JsonConvert.SerializeObject(link_info)); var link_page_note = portalDMTOS.UI_SELECT_LINK_PAGE_NOTE2(link_info.id, delegated_user.id, user.id).FirstOrDefault().http_text; filterContext.HttpContext.Session.SetString("FAQ", JsonConvert.SerializeObject(link_page_note)); //APL_SELECT_PROJECT_STATES_FOR_DDResult SYS_SELECT_ROLES_FOR_DD = JsonConvert.DeserializeObject<APL_SELECT_PROJECT_STATES_FOR_DDResult>(HttpContextAccessor.HttpContext.Session.GetString("SYS_SELECT_ROLES_FOR_DD")); List <APL_SELECT_PROJECT_STATES_FOR_DDResult> SYS_SELECT_ROLES_FOR_DD = portalDMTOS.SYS_SELECT_ROLES_FOR_DD(delegated_user.id).ToList(); filterContext.HttpContext.Session.SetString("SYS_SELECT_ROLES_FOR_DD", JsonConvert.SerializeObject(SYS_SELECT_ROLES_FOR_DD)); } base.OnActionExecuting(filterContext); }
public async Task <IActionResult> Index(bool?showSelected) { var webRoot = _env.WebRootPath; 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 <UI_SELECT_GRID_SETTINGSResult> grid_settings = portalDMTOS.UI_SELECT_GRID_SETTINGS(delegated_user.id, "APL_SELECT_PROJECTS_FOR_REQUIREMENTS", null, 1).ToList(); Settings settings = new Settings(); ViewBag.SendRSSToDMTOSBtn = portalDMTOS.UI_GET_ACTION_ROLE("Requirements/Index", "SendRSSToDMTOS", delegated_user.id, null).FirstOrDefault().column0; ViewBag.SetState9Btn = portalDMTOS.UI_GET_ACTION_ROLE("Requirements/Index", "SetState9", delegated_user.id, null).FirstOrDefault().column0; ViewBag.CancelState9Btn = portalDMTOS.UI_GET_ACTION_ROLE("Requirements/Index", "CancelState9", delegated_user.id, null).FirstOrDefault().column0; ViewBag.SetColorBtn = portalDMTOS.UI_GET_ACTION_ROLE("Requirements/Index", "SetColor", delegated_user.id, null).FirstOrDefault().column0; for (int i = 0; i < grid_settings.Count; i++) { grid_settings[i].global_visible = grid_settings[i].global_visible == null ? true : grid_settings[i].global_visible; grid_settings[i].is_visible = grid_settings[i].is_visible == null ? true : grid_settings[i].is_visible; grid_settings[i].global_editable = grid_settings[i].global_editable == null ? true : grid_settings[i].global_editable; ViewData["CK_UI_" + grid_settings[i].field_description] = grid_settings[i].is_visible & grid_settings[i].global_visible; ViewData["CK_UI_" + grid_settings[i].field_description + "_width"] = grid_settings[i].width; ViewData["CK_UI_" + grid_settings[i].field_description + "_ru"] = grid_settings[i].russian_field_description; ViewData["CK_UI_" + grid_settings[i].field_description + "_pos"] = grid_settings[i].number; ViewData["CK_UI_" + grid_settings[i].field_description + "_edit"] = grid_settings[i].global_editable; } settings.actionName = "UpdateSettingsOfGrid"; settings.checkBoxClass = "UserSettingsCheckbox"; settings.controllerName = "Common"; settings.flowWindowName = "UserSettings"; settings.storedProcedure = "APL_SELECT_PROJECTS_FOR_REQUIREMENTS"; settings.widthClass = "UserSettingsWidth"; settings.positionClass = "PositionClass"; settings.gridSettings = grid_settings; ViewBag.Settings = settings; return(View()); }
public IActionResult Index() { var webRoot = _env.WebRootPath; 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")); ViewBag.AddMailNotification = portalDMTOS.UI_GET_ACTION_ROLE("Projects/Objects", "AddMailNotification", delegated_user.id, null).FirstOrDefault().column0; ViewBag.EditMailNotification = portalDMTOS.UI_GET_ACTION_ROLE("Projects/Objects", "EditMailNotification ", delegated_user.id, null).FirstOrDefault().column0; ViewBag.DeleteMailNotification = portalDMTOS.UI_GET_ACTION_ROLE("Projects/Objects", "DeleteMailNotification", delegated_user.id, null).FirstOrDefault().column0; List <UI_SELECT_GRID_SETTINGSResult> grid_settings = portalDMTOS.UI_SELECT_GRID_SETTINGS(delegated_user.id, "UI_SELECT_MAIL_NOTIFICATIONS", null, 1).ToList(); Settings settings = new Settings(); for (int i = 0; i < grid_settings.Count; i++) { grid_settings[i].global_visible = grid_settings[i].global_visible == null ? true : grid_settings[i].global_visible; grid_settings[i].is_visible = grid_settings[i].is_visible == null ? true : grid_settings[i].is_visible; grid_settings[i].global_editable = grid_settings[i].global_editable == null ? true : grid_settings[i].global_editable; ViewData["CK_UI_" + grid_settings[i].field_description] = grid_settings[i].is_visible & grid_settings[i].global_visible; ViewData["CK_UI_" + grid_settings[i].field_description + "_width"] = grid_settings[i].width; ViewData["CK_UI_" + grid_settings[i].field_description + "_ru"] = grid_settings[i].russian_field_description; ViewData["CK_UI_" + grid_settings[i].field_description + "_pos"] = grid_settings[i].number; ViewData["CK_UI_" + grid_settings[i].field_description + "_edit"] = grid_settings[i].global_editable; } settings.actionName = "UpdateSettingsOfGrid"; settings.checkBoxClass = "UserSettingsCheckbox"; settings.controllerName = "Common"; settings.flowWindowName = "UserSettings"; settings.storedProcedure = "UI_SELECT_MAIL_NOTIFICATIONS"; settings.widthClass = "UserSettingsWidth"; settings.positionClass = "PositionClass"; settings.gridSettings = grid_settings; ViewBag.Settings = settings; return(View()); }
public async Task <IActionResult> Index(bool?showSelected) { var webRoot = _env.WebRootPath; PortalDMTOSModel portalDMTOS = new PortalDMTOSModel(); IEnumerable <APL_SELECT_PROJECT_STATES_FOR_DDResult> apl = await portalDMTOS.APL_SELECT_PROJECT_STATES_FOR_DDAsync(); 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 <UI_SELECT_GRID_SETTINGSResult> grid_settings = portalDMTOS.UI_SELECT_GRID_SETTINGS(delegated_user.id, "PRC_SELECT_ORDER_ITEMS_GKI", null, 1).ToList(); ViewBag.EkkCode = new EkkCodeModel(portalDMTOS.MDM_SELECT_INVENTORY_CLASSES_FOR_GRAPH().ToList(), "ekk_code_name", "ekk_text", true, "FullSearch"); //ViewBag.EkkCode2 = new EkkCodeModel(portalDMTOS.MDM_SELECT_INVENTORY_CLASSES_FOR_GRAPH().ToList(), "ekk_code_name2"); Settings settings = new Settings(); for (int i = 0; i < grid_settings.Count; i++) { grid_settings[i].global_visible = grid_settings[i].global_visible == null ? true : grid_settings[i].global_visible; grid_settings[i].is_visible = grid_settings[i].is_visible == null ? true : grid_settings[i].is_visible; grid_settings[i].global_editable = grid_settings[i].global_editable == null ? true : grid_settings[i].global_editable; ViewData["CK_UI_" + grid_settings[i].field_description] = grid_settings[i].is_visible & grid_settings[i].global_visible; ViewData["CK_UI_" + grid_settings[i].field_description + "_width"] = grid_settings[i].width; ViewData["CK_UI_" + grid_settings[i].field_description + "_ru"] = grid_settings[i].russian_field_description; ViewData["CK_UI_" + grid_settings[i].field_description + "_pos"] = grid_settings[i].number; ViewData["CK_UI_" + grid_settings[i].field_description + "_edit"] = grid_settings[i].global_editable; } settings.actionName = "UpdateSettingsOfGrid"; settings.checkBoxClass = "UserSettingsCheckbox"; settings.controllerName = "Common"; settings.flowWindowName = "UserSettings"; settings.storedProcedure = "PRC_SELECT_ORDER_ITEMS_GKI"; settings.widthClass = "UserSettingsWidth"; settings.positionClass = "PositionClass"; settings.gridSettings = grid_settings; ViewBag.Settings = settings; ViewData["Columns_Array"] = grid_settings;//homeGridSettings; List <APL_SELECT_PROJECT_STATES_FOR_DDResult> dd = portalDMTOS.PRC_SELECT_ORDER_ITEMS_GKI_STATES_FOR_DD(); ViewBag.StateDropdown = JsonConvert.SerializeObject(dd); return(View()); }
public async Task <IActionResult> SVR_items(int svr_id, bool?showSelected, string link_information_param) { var webRoot = _env.WebRootPath; PortalDMTOSModel portalDMTOS = new PortalDMTOSModel(); IEnumerable <APL_SELECT_PROJECT_STATES_FOR_DDResult> apl = await portalDMTOS.APL_SELECT_PROJECT_STATES_FOR_DDAsync(); 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 <UI_SELECT_GRID_SETTINGSResult> grid_settings = portalDMTOS.UI_SELECT_GRID_SETTINGS(delegated_user.id, "OMC_SELECT_SVR_ITEMS", null, 1).ToList(); Settings settings = new Settings(); for (int i = 0; i < grid_settings.Count; i++) { grid_settings[i].global_visible = grid_settings[i].global_visible == null ? true : grid_settings[i].global_visible; grid_settings[i].is_visible = grid_settings[i].is_visible == null ? true : grid_settings[i].is_visible; grid_settings[i].global_editable = grid_settings[i].global_editable == null ? true : grid_settings[i].global_editable; ViewData["CK_UI_" + grid_settings[i].field_description] = grid_settings[i].is_visible & grid_settings[i].global_visible; ViewData["CK_UI_" + grid_settings[i].field_description + "_width"] = grid_settings[i].width; ViewData["CK_UI_" + grid_settings[i].field_description + "_ru"] = grid_settings[i].russian_field_description; ViewData["CK_UI_" + grid_settings[i].field_description + "_pos"] = grid_settings[i].number; ViewData["CK_UI_" + grid_settings[i].field_description + "_edit"] = grid_settings[i].global_editable; } settings.actionName = "UpdateSettingsOfGrid"; settings.checkBoxClass = "UserSettingsCheckbox"; settings.controllerName = "Common"; settings.flowWindowName = "UserSettings"; settings.storedProcedure = "OMC_SELECT_SVR_ITEMS"; settings.widthClass = "UserSettingsWidth"; settings.positionClass = "PositionClass"; settings.gridSettings = grid_settings; ViewBag.Settings = settings; ViewData["Columns_Array"] = grid_settings; ViewData["svr_id"] = svr_id; return(View()); }
public async Task <IActionResult> Index(bool?showSelected) { var webRoot = _env.WebRootPath; 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 <UI_SELECT_GRID_SETTINGSResult> grid_settings = portalDMTOS.UI_SELECT_GRID_SETTINGS(delegated_user.id, "APL_SELECT_PROJECT_REQUIREMENT_CHANGE_REQUESTS2", null, 1).ToList(); Settings settingsForApprove = new Settings(); for (int i = 0; i < grid_settings.Count; i++) { grid_settings[i].global_visible = grid_settings[i].global_visible == null ? true : grid_settings[i].global_visible; grid_settings[i].is_visible = grid_settings[i].is_visible == null ? true : grid_settings[i].is_visible; grid_settings[i].global_editable = grid_settings[i].global_editable == null ? true : grid_settings[i].global_editable; ViewData["CK_UI_" + grid_settings[i].field_description] = grid_settings[i].is_visible & grid_settings[i].global_visible; ViewData["CK_UI_" + grid_settings[i].field_description + "_width"] = grid_settings[i].width; ViewData["CK_UI_" + grid_settings[i].field_description + "_ru"] = grid_settings[i].russian_field_description; ViewData["CK_UI_" + grid_settings[i].field_description + "_pos"] = grid_settings[i].number; ViewData["CK_UI_" + grid_settings[i].field_description + "_edit"] = grid_settings[i].global_editable; } settingsForApprove.actionName = "UpdateSettingsOfGrid"; settingsForApprove.checkBoxClass = "UserSettingsCheckbox"; settingsForApprove.controllerName = "Common"; settingsForApprove.flowWindowName = "UserSettings"; settingsForApprove.storedProcedure = "APL_SELECT_PROJECT_REQUIREMENT_CHANGE_REQUESTS2"; settingsForApprove.widthClass = "UserSettingsWidth"; settingsForApprove.positionClass = "PositionClassFor"; settingsForApprove.gridSettings = grid_settings; ViewBag.UserSettings = settingsForApprove; ViewData["Columns_Array"] = grid_settings;//homeGridSettings; return(View()); }
public async Task <IActionResult> Items(int?project_id, string link_information_param) { var webRoot = _env.WebRootPath; 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 <UI_SELECT_GRID_SETTINGSResult> grid_settings = portalDMTOS.UI_SELECT_GRID_SETTINGS(delegated_user.id, "APL_SELECT_PROJECT_REQUIREMENTS", project_id, 1).ToList(); Settings settings = new Settings(); for (int i = 0; i < grid_settings.Count; i++) { grid_settings[i].global_visible = grid_settings[i].global_visible == null ? true : grid_settings[i].global_visible; grid_settings[i].is_visible = grid_settings[i].is_visible == null ? true : grid_settings[i].is_visible; grid_settings[i].global_editable = grid_settings[i].global_editable == null ? true : grid_settings[i].global_editable; ViewData["CK_UI_" + grid_settings[i].field_description] = grid_settings[i].is_visible & grid_settings[i].global_visible; ViewData["CK_UI_" + grid_settings[i].field_description + "_width"] = grid_settings[i].width; ViewData["CK_UI_" + grid_settings[i].field_description + "_ru"] = grid_settings[i].russian_field_description; ViewData["CK_UI_" + grid_settings[i].field_description + "_pos"] = grid_settings[i].number; ViewData["CK_UI_" + grid_settings[i].field_description + "_edit"] = grid_settings[i].global_editable; } settings.actionName = "UpdateSettingsOfGrid"; settings.checkBoxClass = "UserSettingsCheckbox"; settings.controllerName = "Common"; settings.flowWindowName = "UserSettings"; settings.storedProcedure = "APL_SELECT_PROJECT_REQUIREMENTS"; settings.widthClass = "UserSettingsWidth"; settings.positionClass = "PositionClass"; settings.gridSettings = grid_settings; ViewBag.Settings = settings; ViewBag.ChangeState = portalDMTOS.UI_GET_ACTION_ROLE("Requirements/Items", "changeState", delegated_user.id, Convert.ToString(project_id)).FirstOrDefault().column0; ViewBag.LoadItems = portalDMTOS.UI_GET_ACTION_ROLE("Requirements/Items", "LoadItems", delegated_user.id, Convert.ToString(project_id)).FirstOrDefault().column0; ViewBag.ChangeItems = portalDMTOS.UI_GET_ACTION_ROLE("Requirements/Items", "ChangeItems", delegated_user.id, Convert.ToString(project_id)).FirstOrDefault().column0; ViewBag.AddQuantity = portalDMTOS.UI_GET_ACTION_ROLE("Requirements/Items", "AddQuantity", delegated_user.id, Convert.ToString(project_id)).FirstOrDefault().column0; ViewBag.SetColor = portalDMTOS.UI_GET_ACTION_ROLE("Requirements/Items", "SetColor", delegated_user.id, Convert.ToString(project_id)).FirstOrDefault().column0; ViewBag.Colors = portalDMTOS.UI_SELECT_GRID_COLORS().FirstOrDefault().color_list; List <UI_SELECT_GRID_SETTINGSResult> grid_settingsTotal = portalDMTOS.UI_SELECT_GRID_SETTINGS(delegated_user.id, "APL_SELECT_PROJECT_REQUIREMENTS_TOTAL_INFO2", project_id, 1).ToList(); Settings settingsTotal = new Settings(); for (int i = 0; i < grid_settingsTotal.Count; i++) { grid_settingsTotal[i].global_visible = grid_settingsTotal[i].global_visible == null ? true : grid_settingsTotal[i].global_visible; grid_settingsTotal[i].is_visible = grid_settingsTotal[i].is_visible == null ? true : grid_settingsTotal[i].is_visible; grid_settingsTotal[i].global_editable = grid_settingsTotal[i].global_editable == null ? true : grid_settingsTotal[i].global_editable; ViewData["CK_UI_Total_" + grid_settingsTotal[i].field_description] = grid_settingsTotal[i].is_visible & grid_settingsTotal[i].global_visible; ViewData["CK_UI_Total_" + grid_settingsTotal[i].field_description + "_width"] = grid_settingsTotal[i].width; ViewData["CK_UI_Total_" + grid_settingsTotal[i].field_description + "_ru"] = grid_settingsTotal[i].russian_field_description; ViewData["CK_UI_Total_" + grid_settingsTotal[i].field_description + "_pos"] = grid_settingsTotal[i].number; ViewData["CK_UI_Total_" + grid_settingsTotal[i].field_description + "_edit"] = grid_settingsTotal[i].global_editable; } settingsTotal.actionName = "UpdateSettingsOfGrid"; settingsTotal.checkBoxClass = "UserSettingsCheckboxTotal"; settingsTotal.controllerName = "Common"; settingsTotal.flowWindowName = "UserSettingsTotal"; settingsTotal.storedProcedure = "APL_SELECT_PROJECT_REQUIREMENTS_TOTAL_INFO2"; settingsTotal.widthClass = "UserSettingsWidthTotal"; settingsTotal.positionClass = "PositionClassTotal"; settingsTotal.gridSettings = grid_settingsTotal; ViewBag.SettingsTotal = settingsTotal; UI_SELECT_LINKResult link_info = JsonConvert.DeserializeObject <UI_SELECT_LINKResult>(HttpContext.Session.GetString("link_info")); HttpContext.Session.SetString("link_info", JsonConvert.SerializeObject(link_info)); try { ViewBag.link_info = link_info.description.Replace('"', ' '); } catch { ViewBag.link_info = ""; } //UpdateGridCardModel gridCardModel = new UpdateGridCardModel( // "GridCard", // portalDMTOS.UI_SELECT_GRID_SETTINGS(delegated_user.id, "APL_SELECT_PROJECT_REQUIREMENTS", null, 2).ToList(), // "Карточка", // "Grid", // true, // true, // "APL_UPDATE_PROJECT_REQUIREMENT", // "find_row_id", // null); //// { FlowWindowName = "GridCard", FlowWindowRussianName = "Карточка", GridSettings = portalDMTOS.UI_SELECT_GRID_SETTINGS(delegated_user.id, "APL_SELECT_PROJECT_LIST_INFO2", null, 2).ToList(), Bindning=false, Close_window=false, GridId="GridCard", StoredProcedure= "APL_UPDATE_PROJECT2" }; ////ViewBag.grid2EditAdd = Convert.ToString(grid_settings2.Any(x => x.global_editable == true)).ToLower(); //ViewBag.GridCard = gridCardModel; ViewData["project_id"] = project_id; return(View()); }
public string ExportChangeItems(string id_list) { 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")); int?event_id = null; List <APL_SELECT_PROJECT_REQUIREMENTS_FOR_CHANGEResult> x = portalDMTOS.APL_SELECT_PROJECT_REQUIREMENTS_FOR_CHANGE(event_id, id_list, delegated_user.id, au.id).ToList(); string j = JsonConvert.SerializeObject(x); List <APL_SELECT_PROJECT_REQUIREMENTS_FOR_CHANGEResult> list = JsonConvert.DeserializeObject <List <APL_SELECT_PROJECT_REQUIREMENTS_FOR_CHANGEResult> >(j); string templatePath = Path.Combine(_env.ContentRootPath + "\\wwwroot\\AppData\\ExcelTemplates", "APL_SELECT_PROJECT_REQUIREMENT_TEMPLATE" + ".xlsx"); Guid guid = Guid.NewGuid(); string physicalPath = Path.Combine(_env.ContentRootPath + "\\wwwroot\\AppData\\ExportFiles", guid + ".xlsx"); System.IO.File.Copy(templatePath, physicalPath); int rowCount = 5; ExcelReports <APL_SELECT_PROJECT_REQUIREMENTS_FOR_CHANGEResult> excel = new ExcelReports <APL_SELECT_PROJECT_REQUIREMENTS_FOR_CHANGEResult>(list, rowCount, 1, delegated_user.id, physicalPath, "APL_SELECT_PROJECT_REQUIREMENT_TEMPLATE", 0, null); foreach (var a in list) { excel.SetValueInCellExport(excel.workSheet, rowCount, 1, a.code, null); excel.SetValueInCellExport(excel.workSheet, rowCount, 2, a.object_description, null); excel.SetValueInCellExport(excel.workSheet, rowCount, 3, a.subcontractor_description, null); excel.SetValueInCellExport(excel.workSheet, rowCount, 4, a.project_documentation, null); excel.SetValueInCellExport(excel.workSheet, rowCount, 5, a.project_documentation_date_description, null); excel.SetValueInCellExport(excel.workSheet, rowCount, 6, a.project_documentation_receive_date_description, null); excel.SetValueInCellExport(excel.workSheet, rowCount, 7, a.revision_number_description, null); excel.SetValueInCellExport(excel.workSheet, rowCount, 8, a.revision_number_date_description, null); excel.SetValueInCellExport(excel.workSheet, rowCount, 9, a.revision_number_receive_date_description, null); excel.SetValueInCellExport(excel.workSheet, rowCount, 10, a.start_description, null); excel.SetValueInCellExport(excel.workSheet, rowCount, 11, a.finish_description, null); excel.SetValueInCellExport(excel.workSheet, rowCount, 12, a.station_description, null); excel.SetValueInCellExport(excel.workSheet, rowCount, 13, a.description, null); excel.SetValueInCellExport(excel.workSheet, rowCount, 14, a.additional_properties, null); excel.SetValueInCellExport(excel.workSheet, rowCount, 15, a.package_contents, null); excel.SetValueInCellExport(excel.workSheet, rowCount, 16, a.unit_description, null); excel.SetValueInCellExport(excel.workSheet, rowCount, 17, a.quantity_description, null); excel.SetValueInCellExport(excel.workSheet, rowCount, 18, a.mass_per_unit_description, null); excel.SetValueInCellExport(excel.workSheet, rowCount, 19, a.mass_size, null); excel.SetValueInCellExport(excel.workSheet, rowCount, 20, a.manufacturer_description, null); excel.SetValueInCellExport(excel.workSheet, rowCount, 21, a.delivery_type_description, null); excel.SetValueInCellExport(excel.workSheet, rowCount, 22, a.goods_type_description, null); excel.SetValueInCellExport(excel.workSheet, rowCount, 23, a.summary, null); excel.SetValueInCellExport(excel.workSheet, rowCount, 24, a.summary2, null); excel.SetValueInCellExport(excel.workSheet, rowCount, 25, a.state_description, null); excel.SetValueInCellExport(excel.workSheet, rowCount, 26, a.package_description, null); excel.SetValueInCellExport(excel.workSheet, rowCount, 27, a.in_kd_description, null); excel.SetValueInCellExport(excel.workSheet, rowCount, 28, a.psd_state_description, null); excel.SetValueInCellExport(excel.workSheet, rowCount, 29, a.pr_source_description, null); excel.SetValueInCellExport(excel.workSheet, rowCount, 30, a.subcontractor_description, null); rowCount++; } excel.ep.Save(); if (event_id != null) { portalDMTOS.SYS_FINISH_EVENT(event_id, physicalPath); } return(Convert.ToString("ExportFiles\\" + guid + ".xlsx")); }
public override void OnActionExecuting(ActionExecutingContext filterContext) { //filterContext.HttpContext.Session.GetString("SYS_AUTHORIZE_USER2_R"); PortalDMTOSModel portalDMTOS = new PortalDMTOSModel(); string Host = System.Net.Dns.GetHostName(); //filterContext.HttpContext.Session["system_message"] = oSandBoxDBEntities.SYS_SELECT_MESSAGES(null, null).FirstOrDefault(); if (filterContext.HttpContext.Session.GetString("SYS_AUTHORIZE_USER2_R") == null) //if (filterContext.HttpContext.Request.Cookies["SYS_AUTHORIZE_USER2_R"] == null) { if (filterContext.HttpContext.User == null) { //filterContext.Result = new RedirectToRouteResult(new RouteValueDictionary(new { controller = "Denied", action = "Index2" })); //HttpContext.Current.Response.Redirect("/Denied/Index2"); // filterContext.HttpContext.Response.Redirect(""); filterContext.Result = new RedirectResult("/Home/Denied?username="******"User-Agent"])).FirstOrDefault(); //||||||| .r426 // au = portalDMTOS.SYS_AUTHORIZE_USER(filterContext.HttpContext.User.Identity.Name, null, Convert.ToString(filterContext.HttpContext.Request.Headers["User-Agent"])).FirstOrDefault(); ////======= // au = portalDMTOS.SYS_AUTHORIZE_USER(filterContext.HttpContext.User.Identity.Name, Hosts, Convert.ToString(filterContext.HttpContext.Request.Headers["User-Agent"])).FirstOrDefault(); //>>>>>>> .r428 //SYS_AUTHORIZE_USER2Result au = oSandBoxDBEntities.SYS_AUTHORIZE_USER2(filterContext.HttpContext.User.Identity.Name, null, Convert.ToString(filterContext.HttpContext.Request.Headers["User-Agent"])).FirstOrDefault(); //SYS_AUTHORIZE_USER2Result au = oSandBoxDBEntities.SYS_AUTHORIZE_USER2("OOOSGM\\kordemskaya_lo", null, Convert.ToString(filterContext.HttpContext.Request.Headers["User-Agent"])).FirstOrDefault(); // SYS_AUTHORIZE_USER2Result au = oSandBoxDBEntities.SYS_AUTHORIZE_USER2(filterContext.HttpContext.User.Identity.Name,au.delegating_user_id, null).FirstOrDefault(); //SYS_AUTHORIZE_USER2_R au = oSandBoxDBEntities.SYS_AUTHORIZE_USER2("OOOSGM\\abasova_kr", null).FirstOrDefault(); //SYS_AUTHORIZE_USER2_R au = oSandBoxDBEntities.SYS_AUTHORIZE_USER2("OOOSGM\\volchihina_ua", null).FirstOrDefault(); //SYS_AUTHORIZE_USER2_R au = oSandBoxDBEntities.SYS_AUTHORIZE_USER2("OOOSGM\\zhukov_vs", null).FirstOrDefault(); //SYS_AUTHORIZE_USER2_R au = oSandBoxDBEntities.SYS_AUTHORIZE_USER2("OOOSGM\\suhoivanova_lg", null).FirstOrDefault(); if (au != null && au.not_in_SGM == true) { //HttpContext.Current.Response.Redirect("/Denied/Index?username="******"/Home/Denied?username="******"Denied", action = "Index2" })); // HttpContext.Current.Response.Redirect("/Denied/Index2"); filterContext.Result = new RedirectResult("/Home/Denied?username="******"SYS_AUTHORIZE_USER2_R", JsonConvert.SerializeObject(au.delegating_user_id));//, new CookieOptions() { HttpOnly = false }); // filterContext.HttpContext.Response.Cookies.Append("SYS_SELECT_DELEGATING_USERS_R", Convert.ToString(JsonConvert.SerializeObject(sduc)));//, new CookieOptions() { HttpOnly = false }); filterContext.HttpContext.Session.SetString("SYS_AUTHORIZE_USER2_R", JsonConvert.SerializeObject(au)); filterContext.HttpContext.Session.SetString("SYS_SELECT_DELEGATING_USERS_R", JsonConvert.SerializeObject(sduc)); filterContext.HttpContext.Session.SetString("deleagting_user", JsonConvert.SerializeObject(sduc.Where(x => x.id == au.id).FirstOrDefault())); List <UI_SELECT_GRID_SETTINGSResult> settingsGridLogPerson = portalDMTOS.UI_SELECT_GRID_SETTINGS(au.id, "SYS_SELECT_LOG", null, 1).ToList(); filterContext.HttpContext.Session.SetString("settingsGridLogPerson", JsonConvert.SerializeObject(settingsGridLogPerson)); List <UI_SELECT_SITE_MENUResult> site_map = portalDMTOS.UI_SELECT_SITE_MENU(au.id).ToList(); filterContext.HttpContext.Session.SetString("site_map", JsonConvert.SerializeObject(site_map)); bool admin = portalDMTOS.SYS_SELECT_ROLES_BY_USER(sduc.Where(x => x.id == au.id).FirstOrDefault().id).ToList().Any(x => x.role_id == 1); filterContext.HttpContext.Session.SetString("admin_role", JsonConvert.SerializeObject(admin)); } else { // filterContext.Result = new RedirectToRouteResult(new RouteValueDictionary(new { controller = "Denied", action = "Index" })); // HttpContext.Current.Response.Redirect("/Denied/Index?username="******"/Home/Denied?username="******"SYS_AUTHORIZE_USER2_R"); //SYS_AUTHORIZE_USER2Result au2 = JsonConvert.DeserializeObject<SYS_AUTHORIZE_USER2Result>( filterContext.HttpContext.Request.Cookies["SYS_AUTHORIZE_USER2_R"]); //filterContext.HttpContext.Session.SetString("system_message", JsonConvert.SerializeObject(oSandBoxDBEntities.SYS_SELECT_MESSAGES(user.delegating_user_id, user.id).FirstOrDefault())); // filterContext.HttpContext.Response.Cookies.Append("system_message", Convert.ToString(JsonConvert.SerializeObject(oSandBoxDBEntities.SYS_SELECT_MESSAGES(user.delegating_user_id, user.id).FirstOrDefault()))); //if (au != null | filterContext.HttpContext.Session.Keys.Contains("SYS_AUTHORIZE_USER2_R")) //{ // APL_SELECT_PROJECT_STATES_FOR_DDResult delegated_user = JsonConvert.DeserializeObject<APL_SELECT_PROJECT_STATES_FOR_DDResult>(filterContext.HttpContext.Session.GetString("deleagting_user")); // //filterContext.HttpContext.Session.SetString("FAQ", JsonConvert.SerializeObject(portalDMTOS.UI_SELECT_LINK_PAGE_NOTE(filterContext.RouteData.Values["Controller"].ToString(), filterContext.RouteData.Values["Action"].ToString(), delegated_user.id).FirstOrDefault().http_text)); // SYS_AUTHORIZE_USERResult user = JsonConvert.DeserializeObject<SYS_AUTHORIZE_USERResult>(filterContext.HttpContext.Session.GetString("SYS_AUTHORIZE_USER2_R")); // filterContext.HttpContext.Session.SetString("message_panel", JsonConvert.SerializeObject(portalDMTOS.SYS_SELECT_MESSAGES(user.id, delegated_user.id).FirstOrDefault().description)); // UI_SELECT_LINKResult link_info=null; // //UI_SELECT_LINKResult link_info = JsonConvert.DeserializeObject<UI_SELECT_LINKResult>(HttpContextAccessor.HttpContext.Session.GetString("link_info")); // if (filterContext.RouteData.Values["Action"].ToString()!=null && filterContext.RouteData.Values["Controller"].ToString()!=null) // link_info = portalDMTOS.UI_SELECT_LINK(filterContext.RouteData.Values["Action"].ToString(), filterContext.RouteData.Values["Controller"].ToString()).FirstOrDefault(); // if (link_info == null) // link_info = portalDMTOS.UI_SELECT_LINK("Index", "Home").FirstOrDefault(); // filterContext.HttpContext.Session.SetString("link_info", JsonConvert.SerializeObject(link_info)); // filterContext.HttpContext.Session.SetString("FAQ", JsonConvert.SerializeObject(portalDMTOS.UI_SELECT_LINK_PAGE_NOTE2(link_info.id, delegated_user.id, user.id).FirstOrDefault().http_text)); // //APL_SELECT_PROJECT_STATES_FOR_DDResult SYS_SELECT_ROLES_FOR_DD = JsonConvert.DeserializeObject<APL_SELECT_PROJECT_STATES_FOR_DDResult>(HttpContextAccessor.HttpContext.Session.GetString("SYS_SELECT_ROLES_FOR_DD")); // List<APL_SELECT_PROJECT_STATES_FOR_DDResult> SYS_SELECT_ROLES_FOR_DD = portalDMTOS.SYS_SELECT_ROLES_FOR_DD(delegated_user.id).ToList(); // filterContext.HttpContext.Session.SetString("SYS_SELECT_ROLES_FOR_DD", JsonConvert.SerializeObject(SYS_SELECT_ROLES_FOR_DD)); //} base.OnActionExecuting(filterContext); }
public IActionResult Index(int?id) { PortalDMTOSModel portalDMTOS = new PortalDMTOSModel(); if (id != null) { SYS_AUTHORIZE_USERResult au = JsonConvert.DeserializeObject <SYS_AUTHORIZE_USERResult>(HttpContext.Session.GetString("SYS_AUTHORIZE_USER2_R")); UI_SELECT_LINKResult link_info = new UI_SELECT_LINKResult { id = 0, description = "" }; HttpContext.Session.SetString("SYS_AUTHORIZE_USER2_R", JsonConvert.SerializeObject(au)); List <APL_SELECT_PROJECT_STATES_FOR_DDResult> sduc = portalDMTOS.SYS_SELECT_DELEGATING_USERS2(au.id).ToList <APL_SELECT_PROJECT_STATES_FOR_DDResult>(); HttpContext.Session.SetString("deleagting_user", JsonConvert.SerializeObject(sduc.Where(x => x.id == id).FirstOrDefault())); HttpContext.Session.SetString("SYS_SELECT_DELEGATING_USERS_R", JsonConvert.SerializeObject(sduc)); List <UI_SELECT_SITE_MENUResult> site_map = portalDMTOS.UI_SELECT_SITE_MENU(id).ToList(); HttpContext.Session.SetString("site_map", JsonConvert.SerializeObject(site_map)); APL_SELECT_PROJECT_STATES_FOR_DDResult delegated_user = JsonConvert.DeserializeObject <APL_SELECT_PROJECT_STATES_FOR_DDResult>(HttpContext.Session.GetString("deleagting_user")); List <UI_SELECT_GRID_SETTINGSResult> settingsGridLogPerson = portalDMTOS.UI_SELECT_GRID_SETTINGS(delegated_user.id, "SYS_SELECT_LOG", null, 1).ToList(); HttpContext.Session.SetString("settingsGridLogPerson", JsonConvert.SerializeObject(settingsGridLogPerson)); bool admin = portalDMTOS.SYS_SELECT_ROLES_BY_USER(sduc.Where(x => x.id == id).FirstOrDefault().id).ToList().Any(x => x.role_id == 1); HttpContext.Session.SetString("admin_role", JsonConvert.SerializeObject(admin)); link_info = JsonConvert.DeserializeObject <UI_SELECT_LINKResult>(HttpContext.Session.GetString("link_info")); HttpContext.Session.SetString("FAQ", JsonConvert.SerializeObject(portalDMTOS.UI_SELECT_LINK_PAGE_NOTE2(link_info.id, id, au.id).FirstOrDefault().http_text)); //HttpContext.Session.SetString("link_info", JsonConvert.SerializeObject(link_info)); //HttpContext.Session.SetString("FAQ", JsonConvert.SerializeObject(portalDMTOS.UI_SELECT_LINK_PAGE_NOTE2(link_info.id, user_id).FirstOrDefault().http_text)); HttpContext.Session.SetString("message_panel", JsonConvert.SerializeObject(portalDMTOS.SYS_SELECT_MESSAGES(id, au.id).FirstOrDefault().description)); ViewBag.SYS_SELECT_ROLES_FOR_DD = portalDMTOS.SYS_SELECT_ROLES_FOR_DD(id); ViewBag.Message = "Вы действуете в системе от имени другого пользователя!"; } else { ViewBag.Message = "Добро пожаловать!"; //HttpContext.Session.Clear(); UI_SELECT_LINKResult link_info = new UI_SELECT_LINKResult { id = 0, description = "" }; link_info = JsonConvert.DeserializeObject <UI_SELECT_LINKResult>(HttpContext.Session.GetString("link_info")); SYS_AUTHORIZE_USERResult au = JsonConvert.DeserializeObject <SYS_AUTHORIZE_USERResult>(HttpContext.Session.GetString("SYS_AUTHORIZE_USER2_R")); List <APL_SELECT_PROJECT_STATES_FOR_DDResult> SYS_SELECT_ROLES_FOR_DD = JsonConvert.DeserializeObject <List <APL_SELECT_PROJECT_STATES_FOR_DDResult> >(HttpContext.Session.GetString("SYS_SELECT_ROLES_FOR_DD")); HttpContext.Session.Clear(); List <APL_SELECT_PROJECT_STATES_FOR_DDResult> sduc = portalDMTOS.SYS_SELECT_DELEGATING_USERS2(au.id).ToList(); HttpContext.Session.SetString("SYS_AUTHORIZE_USER2_R", JsonConvert.SerializeObject(au)); HttpContext.Session.SetString("link_info", JsonConvert.SerializeObject(link_info)); HttpContext.Session.SetString("SYS_SELECT_ROLES_FOR_DD", JsonConvert.SerializeObject(SYS_SELECT_ROLES_FOR_DD)); HttpContext.Session.SetString("deleagting_user", JsonConvert.SerializeObject(sduc.Where(x => x.id == au.id).FirstOrDefault())); HttpContext.Session.SetString("SYS_SELECT_DELEGATING_USERS_R", JsonConvert.SerializeObject(sduc)); List <UI_SELECT_SITE_MENUResult> site_map = portalDMTOS.UI_SELECT_SITE_MENU(au.id).ToList(); HttpContext.Session.SetString("site_map", JsonConvert.SerializeObject(site_map)); APL_SELECT_PROJECT_STATES_FOR_DDResult delegated_user = JsonConvert.DeserializeObject <APL_SELECT_PROJECT_STATES_FOR_DDResult>(HttpContext.Session.GetString("deleagting_user")); List <UI_SELECT_GRID_SETTINGSResult> settingsGridLogPerson = portalDMTOS.UI_SELECT_GRID_SETTINGS(delegated_user.id, "SYS_SELECT_LOG", null, 1).ToList(); HttpContext.Session.SetString("settingsGridLogPerson", JsonConvert.SerializeObject(settingsGridLogPerson)); bool admin = portalDMTOS.SYS_SELECT_ROLES_BY_USER(sduc.Where(x => x.id == au.id).FirstOrDefault().id).ToList().Any(x => x.role_id == 1); HttpContext.Session.SetString("admin_role", JsonConvert.SerializeObject(admin)); HttpContext.Session.SetString("FAQ", JsonConvert.SerializeObject(portalDMTOS.UI_SELECT_LINK_PAGE_NOTE2(link_info.id, au.id, au.id).FirstOrDefault().http_text)); //HttpContext.Session.SetString("link_info", JsonConvert.SerializeObject(link_info)); //HttpContext.Session.SetString("FAQ", JsonConvert.SerializeObject(portalDMTOS.UI_SELECT_LINK_PAGE_NOTE2(link_info.id, user_id).FirstOrDefault().http_text)); HttpContext.Session.SetString("message_panel", JsonConvert.SerializeObject(portalDMTOS.SYS_SELECT_MESSAGES(au.id, au.id).FirstOrDefault().description)); } return(View()); }