public static bool IsHoliday(this DateTime originalDate) { SelectSql select = new SelectSql(); var isHoliday = select.IsHolidays(originalDate); select.Dispose(); return(isHoliday); }
/// <summary> /// Получение модели из БД /// </summary> /// <param name="report">Отчет</param> public void ReportInvoice(ref EfDatabaseInvoice.Report report) { SelectSql select = new SelectSql(); AddObjectDb.AddObjectDb adddoc = new AddObjectDb.AddObjectDb(); select.ReportInvoice(ref report); report.Main.Barcode = new Barcode(); report.Main.Barcode.Id = adddoc.AddDocument(report.ParamRequest.IdNameDocument, report.Main.Received.NameUser, report.ParamRequest.IdUsers); }
/// <summary> /// Выгрузка ролей пользователя /// </summary> /// <param name="idUser">УН пользователя</param> /// <returns></returns> public RuleUsers[] AllRuleUser(int idUser) { SelectSql sql = new SelectSql(); ModelSelect model = new ModelSelect { LogicaSelect = sql.SqlSelectModel(34) }; sql.Dispose(); var ruleAndUser = Inventory.Database.SqlQuery <RuleUsers>(model.LogicaSelect.SelectUser, new SqlParameter(model.LogicaSelect.SelectedParametr.Split(',')[0], idUser)).ToArray(); return(ruleAndUser); }
/// <summary> /// Получение данных для личного кабинета пользователя инвенторизации /// </summary> /// <param name="idUser">Ун пользователя</param> /// <returns></returns> public string AllTechicsLkInventory(int idUser) { SerializeJson json = new SerializeJson(); SelectSql sql = new SelectSql(); ModelSelect model = new ModelSelect { LogicaSelect = sql.SqlSelectModel(33) }; var idDepartment = Inventory.Database.SqlQuery <int>(model.LogicaSelect.SelectUser, new SqlParameter(model.LogicaSelect.SelectedParametr.Split(',')[0], idUser)).FirstOrDefault(); sql.Dispose(); if (idDepartment != 0) { return(json.JsonLibaryIgnoreDate(Inventory.AllTechnics.Where(x => x.IdOtdel == idDepartment))); } return(json.JsonLibaryIgnoreDate(Inventory.AllTechnics.Where(x => x.IdUser == idUser))); }
/// <summary> /// Генерация параметров для запроса на СТО /// </summary> /// <param name="modelSupport">Модель запроса на сервис</param> public void GenerateTemplateUrlParameter(ref ModelParametrSupport modelSupport) { SelectSql select = new SelectSql(); ModelSelect model = new ModelSelect { LogicaSelect = select.SqlSelectModel(28) }; if (modelSupport.IdSysBlock == 0) { var idUser = modelSupport.IdUser; modelSupport.IdSysBlock = Inventory.SysBlocks.Where(x => x.IdUser == idUser).Select(sel => sel.IdSysBlock).FirstOrDefault(); } modelSupport.TemplateSupport = Inventory.Database.SqlQuery <TemplateSupport1>(model.LogicaSelect.SelectUser, new SqlParameter(model.LogicaSelect.SelectedParametr.Split(',')[0], modelSupport.IdTemplate)).ToArray(); if (modelSupport?.TemplateSupport != null && modelSupport?.TemplateSupport.Length > 0) { var description = modelSupport.Discription; modelSupport.TemplateSupport.Where(discription => discription.NameGuidParametr == "UF_DESCRIPTION").ToList().ForEach(d => d.Parametr = description); var modelParameterInput = modelSupport.TemplateSupport.Where(temple => temple.NameStepSupport == "Step2" && temple.TemplateParametrType != null); foreach (var template in modelParameterInput) { if (template.TemplateParametrType.Equals("User") && modelSupport.IdUser != 0) { template.Parametr = Inventory.Database.SqlQuery <string>(template.SelectParametr, new SqlParameter("IdUser", modelSupport.IdUser)).FirstOrDefault(); } if (template.TemplateParametrType.Equals("SysBlock") && modelSupport.IdSysBlock != 0) { template.Parametr = Inventory.Database.SqlQuery <string>(template.SelectParametr, new SqlParameter("IdSysBlock", modelSupport.IdSysBlock)).FirstOrDefault(); } if (template.TemplateParametrType.Equals("Monitors") && modelSupport.IdMonitor != 0) { template.Parametr = Inventory.Database.SqlQuery <string>(template.SelectParametr, new SqlParameter("IdMonitor", modelSupport.IdMonitor)).FirstOrDefault(); } if (template.TemplateParametrType.Equals("Printer") && modelSupport.IdPrinter != 0) { template.Parametr = Inventory.Database.SqlQuery <string>(template.SelectParametr, new SqlParameter("IdPrinter", modelSupport.IdPrinter)).FirstOrDefault(); } if (template.TemplateParametrType.Equals("Mfu") && modelSupport.IdMfu != 0) { template.Parametr = Inventory.Database.SqlQuery <string>(template.SelectParametr, new SqlParameter("IdMfu", modelSupport.IdMfu)).FirstOrDefault(); } if (template.TemplateParametrType.Equals("Scanner") && modelSupport.IdScanner != 0) { template.Parametr = Inventory.Database.SqlQuery <string>(template.SelectParametr, new SqlParameter("IdScaner", modelSupport.IdScanner)).FirstOrDefault(); } if (template.TemplateParametrType.Equals("Telephon") && modelSupport.IdTelephon != 0) { template.Parametr = Inventory.Database.SqlQuery <string>(template.SelectParametr, new SqlParameter("IdTelephon", modelSupport.IdTelephon)).FirstOrDefault(); } if (template.TemplateParametrType.Equals("DomainUser") && modelSupport.IdUser != 0) { var personnelNumberAndGroupOtdel = Inventory.Database.SqlQuery <string>(template.SelectParametr, new SqlParameter("IdUser", modelSupport.IdUser)).FirstOrDefault(); if (template.NameParametrType.Equals("Group")) { template.Parametr = FindGroupAccess(personnelNumberAndGroupOtdel).Aggregate((element, next) => element + (string.IsNullOrWhiteSpace(element) ? string.Empty : ",") + next); } if (template.NameParametrType.Equals("GroupOtdel")) { template.Parametr = FindIdentytyGroup(personnelNumberAndGroupOtdel.Replace("№", "№ ")); } if (template.NameParametrType.Contains("GroupOtdelBoss")) { template.Parametr = FindFullPathActiveDirectory(personnelNumberAndGroupOtdel); } } if (template.TemplateParametrType.Equals("DomainSysBlock") && modelSupport.IdSysBlock != 0) { var nameComputer = Inventory.Database.SqlQuery <string>(template.SelectParametr, new SqlParameter("IdSysBlock", modelSupport.IdSysBlock)).FirstOrDefault(); var parameters = template.Parametr.Split('/'); template.Parametr = IsCheckComputer(nameComputer) ? parameters[0] : parameters[1]; } } } else { throw new InvalidOperationException($"Фатальная ошибка отсутствует шаблон запроса на CTO по id {modelSupport.IdTemplate}!"); } select.Dispose(); }