/// <summary>
/// Gets a collection of Docket objects by a PlacedAd object.
/// </summary>
/// <param name="placedAd">placedAd</param>
/// <param name="startRowIndex"></param>
/// <param name="pageSize"></param>
/// <param name="totalRows"></param>
/// <returns>A collection Docket objects.</returns>
public static EntityList<Docket> GetDocketsByplacedad_(PlacedAd @placedad_, long startRowIndex, int pageSize, out long totalRows)
{
string commandText = @"
FROM
[dbo].[Dockets]
WHERE
[Dockets].[placedad_id] = @placedad_id ";
List<SqlParameter> parameters = new List<SqlParameter>();
parameters.Add(new SqlParameter("@placedad_id", @placedad_.placedad_id));
return GetList<Docket>(SelectFieldList, commandText, parameters, null, startRowIndex, pageSize, out totalRows);
}
/// <summary>
/// Deletes Docket objects by a PlacedAd object.
/// </summary>
/// <param name="placedAd">placedAd</param>
public static void DeleteDocketsByplacedad_(PlacedAd placedAd)
{
string commandText = "DocketDeleteByPlacedAd";
System.Collections.Generic.List<SqlParameter> parameters = new System.Collections.Generic.List<SqlParameter>();
parameters.Add(new SqlParameter("@placedad_id", placedAd.placedad_id));
using (SqlHelper helper = new SqlHelper())
{
helper.Execute(commandText, CommandType.StoredProcedure, parameters);
}
}
/// <summary>
/// Gets a collection of Docket objects by a PlacedAd object.
/// </summary>
/// <param name="placedad_">placedad_</param>
/// <returns>A collection Docket objects.</returns>
public static EntityList<Docket> GetDocketsByplacedad_(PlacedAd @placedad_)
{
string commandText = "DocketGetByPlacedAd";
List<SqlParameter> parameters = new List<SqlParameter>();
parameters.Add(new SqlParameter("@placedad_id", @placedad_.placedad_id));
return GetList<Docket>(@placedad_, commandText, parameters);
}
/// <summary>
/// Create a new Docket object from a PlacedAd object.
/// </summary>
/// <param name="placedad_">placedad_</param>
/// <returns>The newly created Docket object.</returns>
public static Docket CreateDocketByplacedad_(PlacedAd @placedad_)
{
Docket docket = InitializeNew<Docket>();
docket.placedad_id = @placedad_.placedad_id;
docket.placedad_ = @placedad_;
return docket;
}
