public static SocketBoxSpecific GetPatternName(int patternId) { var sql = @" SELECT * FROM SocketBoxSpecifics WHERE Id = " + patternId; var db = SocketBoxSpecific.GetDatabase(); var boxes = db.ExecuteQuery <SocketBoxSpecific>(sql); return(boxes[0]); }
public static int GetNewId() { var sql = @" SELECT MAX(Id) FROM SocketBoxSpecifics"; var db = SocketBoxSpecific.GetDatabase(); var obj = db.ExecuteScalar(sql); if (obj == null || obj == DBNull.Value) { return(1); } return((int)obj + 1); }