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