public static void DeleteByCategory(int categoryId) { var sql = @" DELETE FROM SocketBoxPatterns WHERE CategoryId = " + categoryId; var db = SocketBoxPattern.GetDatabase(); db.ExecuteNonQuery(sql); }
public static void Delete(int patternId) { var sql = @" DELETE FROM SocketBoxPatterns WHERE Id = " + patternId; var db = SocketBoxPattern.GetDatabase(); db.ExecuteNonQuery(sql); }
public static int GetNewId() { var sql = @"SELECT MAX(Id) FROM SocketBoxPatterns"; var db = SocketBoxPattern.GetDatabase(); var obj = db.ExecuteScalar(sql); if (obj == null || obj == DBNull.Value) { return(1); } return((int)obj + 1); }