partial void BeforeRowDelete(int customFieldCategoryID)
{
CustomFieldCategories cats = new CustomFieldCategories(LoginUser);
using (SqlCommand command = new SqlCommand())
{
command.CommandText = "UPDATE CustomFields SET CustomFieldCategoryID = NULL WHERE CustomFieldCategoryID = @CustomFieldCategoryID";
command.CommandType = CommandType.Text;
command.Parameters.AddWithValue("@CustomFieldCategoryID", customFieldCategoryID);
cats.ExecuteNonQuery(command, "CustomFields");
}
}
public static CustomFieldCategory GetCustomFieldCategory(LoginUser loginUser, int customFieldCategoryID)
{
CustomFieldCategories customFieldCategories = new CustomFieldCategories(loginUser);
customFieldCategories.LoadByCustomFieldCategoryID(customFieldCategoryID);
if (customFieldCategories.IsEmpty)
{
return(null);
}
else
{
return(customFieldCategories[0]);
}
}
public static int GetMaxPosition(LoginUser loginUser, ReferenceType refType, int?auxID)
{
CustomFieldCategories cats = new CustomFieldCategories(loginUser);
using (SqlCommand command = new SqlCommand())
{
command.CommandText =
@"SELECT MAX(Position) FROM CustomFieldCategories
WHERE (RefType = @RefType)
AND (AuxID = @AuxID OR @AuxID < 0)
AND (OrganizationID = @OrganizationID)";
command.CommandType = CommandType.Text;
command.Parameters.AddWithValue("@RefType", refType);
command.Parameters.AddWithValue("@AuxID", auxID == null ? -1 : (int)auxID);
command.Parameters.AddWithValue("@OrganizationID", loginUser.OrganizationID);
object o = cats.ExecuteScalar(command);
if (o == null || o == DBNull.Value)
{
return(-1);
}
return((int)o);
}
}
public CustomFieldCategory(DataRow row, CustomFieldCategories customFieldCategories) : base(row, customFieldCategories)
{
_customFieldCategories = customFieldCategories;
}
