public void DeletetSettingPolicy(int policyId, ContolType type)
{
try {
var query = $@"Delete from [dbo].[setting_policy]
where [policy_id] = {policyId} AND [type_control] = {(byte)type}";
Connection.Open();
Connection.Query(query);
Connection.Close();
Console.WriteLine($" Succsesful PolicyRepository::DeletePolicy::Query: {query}"); //log
}
catch (Exception ex) {
Connection.Close();
Console.WriteLine($" Invalide PolicyRepository::DeletePolicy::Query:"); //log
Console.WriteLine(ex.Message);
}
}
public bool CheckRight(int userId, ContolType type, Rights right)
{
try {
var query = $@"Select [{right}] from setting_policy
join users on user_id = {userId} and users.policy_id = setting_policy.policy_id
where type_control = {(byte)type}";
Connection.Open();
var outpute = Connection.ExecuteScalar <bool>(query);
Connection.Close();
Console.WriteLine($" Succsesful PolicyRepository::CheckRight::Query: {query}"); //log
return(outpute);
}
catch (Exception ex) {
Connection.Close();
Console.WriteLine($" Invalide PolicyRepository::CreatePolicy::Query:"); //log
Console.WriteLine(ex.Message);
return(false);
}
}
