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