public static void Delete(int patternId) { var sql = @" DELETE FROM SocketBoxPatternDetails WHERE PatternId = " + patternId; var db = SocketBoxPatternDetail.GetDatabase(); db.ExecuteNonQuery(sql); }
public static List <SocketBoxPatternDetail> Get(int patternId) { var sql = @" SELECT * FROM SocketBoxPatternDetails WHERE PatternId = " + patternId.ToString(); var db = SocketBoxPatternDetail.GetDatabase(); return(db.ExecuteQuery <SocketBoxPatternDetail>(sql)); }
public static void DeleteByCategory(int categoryId) { var sql = @" DELETE FROM SocketBoxPatternDetails FROM SocketBoxPatternDetails D JOIN SocketBoxPatterns P ON D.PatternId = P.Id AND P.CategoryId = " + categoryId; var db = SocketBoxPatternDetail.GetDatabase(); db.ExecuteNonQuery(sql); }