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