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