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