public PermissionTypeState(PermissionType type, PermissionState state)
{
permissionType = type;
permissionState = state;
}
public Result Delete(PermissionType permissionType)
{
Result result = new Result();
if (OnBeforeDeletePermissionType != null)
OnBeforeDeletePermissionType(permissionType, result);
SqlConnection conn = null;
if (result.Succeeded)
{
try
{
using (TransactionScope scope = new TransactionScope())
{
conn = (SqlConnection)DatabaseManager.DatabaseEngine.GetConnection();
try
{
SqlCommand cmd = new SqlCommand("DeletePermissionType", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@PermissionTypeID", permissionType.PermissionTypeID));
cmd.ExecuteNonQuery();
scope.Complete();
}
catch (Exception ex)
{
return new Result(ex.Message);
}
}
}
finally
{
DatabaseManager.DatabaseEngine.ReleaseConnection(conn);
}
if (OnPermissionTypeDeleted != null)
OnPermissionTypeDeleted(permissionType);
}
return result;
}
public PermissionTypeState(PermissionType type, PermissionState state)
{
permissionType = type;
permissionState = state;
}
public Result Store(PermissionType permissionType)
{
SqlConnection conn = null;
try
{
using (TransactionScope scope = new TransactionScope())
{
conn = (SqlConnection)DatabaseManager.DatabaseEngine.GetConnection();
try
{
SqlCommand cmd = new SqlCommand("StorePermissionType", conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter prm = new SqlParameter("@PermissionTypeID", permissionType.PermissionTypeID);
prm.Direction = ParameterDirection.InputOutput;
cmd.Parameters.Add(prm);
cmd.Parameters.Add(new SqlParameter("@PermissionTypeCode", permissionType.PermissionTypeCode));
cmd.Parameters.Add(new SqlParameter("@Description", permissionType.Description));
cmd.Parameters.Add(new SqlParameter("@DefaultValue", permissionType.DefaultValue));
for (int i = 0; i < cmd.Parameters.Count; i++)
if (cmd.Parameters[i].Value == null)
cmd.Parameters[i].Value = DBNull.Value;
cmd.ExecuteNonQuery();
permissionType.PermissionTypeID = (long)prm.Value;
scope.Complete();
}
catch (Exception ex)
{
return new Result(ex.Message);
}
}
}
finally
{
DatabaseManager.DatabaseEngine.ReleaseConnection(conn);
}
return new Result();
}
