public static void DeleteRowInTableRatioClasses(string idClassParent, string idClassDescendent) { var request = $"DELETE FROM {Constants.DataBase.Requests.TableRatioClasses} WHERE [ID_Класса_родителя] = '{idClassParent}' AND [ID_Класса_потомка] = '{idClassDescendent}'"; SqlCommandsSevice.CommandsSql(request); LoggingService.Event(request); }
/// <summary> /// Переименовать роль /// </summary> public static void RenameRole(string roleName, string newRoleName) { var request = $"ALTER ROLE \"{roleName}\" WITH NAME = \"{newRoleName}\""; SqlCommandsSevice.CommandsSql(request); LoggingService.Event(request); }
/// <summary> /// Удалить роль /// </summary> public static void DeleteRole(string roleName) { var request = $"DROP ROLE \"{roleName}\""; SqlCommandsSevice.CommandsSql(request); LoggingService.Event(request); }
/// <summary> /// Удаление члена из роли /// </summary> public static void RemoveMemberOfRole(string role, string member) { var request = $"ALTER ROLE \"{role}\" DROP MEMBER \"{member}\""; SqlCommandsSevice.CommandsSql(request); LoggingService.Event(request); }
/// <summary> /// Добавление члена в роль /// </summary> public static void AddMemberInRole(string role, string member) { var request = $"ALTER ROLE \"{role}\" ADD MEMBER \"{member}\""; SqlCommandsSevice.CommandsSql(request); LoggingService.Event(request); }
public static void InsertIntoTableRatioClasses(string idClassParent, string idClassDescendent) { var valuesCells = $"NEWID(), CONVERT(uniqueidentifier,\'{idClassParent}\'), CONVERT(uniqueidentifier,\'{idClassDescendent}\')"; var request = $"INSERT INTO {Constants.DataBase.Requests.TableRatioClasses} ({Constants.DataBase.Requests.ColumnsRatioClasses}) VALUES ({valuesCells})"; SqlCommandsSevice.CommandsSql(request); LoggingService.Event(request); }
/// <summary> /// Добавить новую строку в таблице Объекьтов классов /// </summary> /// <param name="viewObjectClass"></param> public static void InsertIntoTableObjectClass(ObjectClass viewObjectClass) { var idTempateReport = viewObjectClass.IdTempateReport == string.Empty ? $"CONVERT(uniqueidentifier,\'{viewObjectClass.IdTempateReport}\')" : "NULL"; var idStandartsDefault = viewObjectClass.IdStandartsDefault == string.Empty ? $"\'CONVERT(uniqueidentifier, {viewObjectClass.IdStandartsDefault}\')" : "NULL"; var valuesCells = $"CONVERT(uniqueidentifier,\'{viewObjectClass.Id}\'), \'{viewObjectClass.ProductionFunds}\', \'{viewObjectClass.MetaClass}\', \'{viewObjectClass.TitleClass}\', \'{viewObjectClass.TitleNameRoot}\', \'{viewObjectClass.NameClassInPlural}\', \'{viewObjectClass.NameInPluralGenitive}\'," + $"\'{viewObjectClass.Scheme}\', \'{viewObjectClass.Table}\', \'{viewObjectClass.Image}\', \'{viewObjectClass.Editable}\', {idStandartsDefault}, \'{viewObjectClass.TitleView}\', \'{viewObjectClass.NonStandartTriggers}\', \'{viewObjectClass.NameRule}\'," + $"\'{viewObjectClass.SpecialSchemeView}\', \'{viewObjectClass.ExtraMetadata}\', {idTempateReport}, \'{viewObjectClass.Timestamp}\'"; var request = $"INSERT INTO {Constants.DataBase.Requests.TableObjectClasses} ({Constants.DataBase.Requests.ColumnsObjectClasses}) VALUES ({valuesCells})"; SqlCommandsSevice.CommandsSql(request); LoggingService.Event(request); }
public static void UpdateTableRatioClasses(RatioClass ratioClass) { var request = $"UPDATE [config].[Отношения классов] SET [Потомок обязателен] = \'{ratioClass.DescendantRequired}\'," + $"[Потомок единственный] = \'{ratioClass.DescendantOnly}\'," + $"[Потомок на ТП] = \'{ratioClass.DescendantOnTp}\'," + $"[ТП потомка на ТП родителя] = \'{ratioClass.TpDescendantOnTpParent}\'," + $"[Показывать узел класса потомка] = \'{ratioClass.ShowClassesNodeDescendant}\'," + $"[Показывать узел ТП потомка] = \'{ratioClass.ShowClassesNodeTpDescendant}\'," + $"[Папка] = \'{ratioClass.Folder}\'" + $"WHERE ID = \'{ratioClass.Id}\'"; SqlCommandsSevice.CommandsSql(request); LoggingService.Event(request); }
/// <summary> /// Создать новую роль /// </summary> public static void AddRole(string roleName) { try { var request = $"CREATE ROLE \"{roleName}\" AUTHORIZATION [dbo]"; SqlCommandsSevice.CommandsSql(request); LoggingService.Event(request); } catch (Exception) { SqlCommandsSevice.Connection.Close(); MessageBox.Show(@"Такое имя роли уже существует", @"Connection Info", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Обновить строку в таблице Объекьтов классов /// </summary> /// <param name="id"></param> /// <param name="nameColumn"></param> /// <param name="valueCell"></param> public static void UpdateTableObjectClasses(string id, string nameColumn, string valueCell) { var request = $"UPDATE [config].[Классы объектов] SET [{nameColumn}] = \'{valueCell}\' WHERE ID = \'{id}\'"; SqlCommandsSevice.CommandsSql(request); LoggingService.Event(request); }