/// <summary>
/// Gets a collection of Trigger objects by a UploadedAd object.
/// </summary>
/// <param name="uploadedad_">uploadedad_</param>
/// <returns>A collection Trigger objects.</returns>
public static EntityList<Trigger> GetTriggersByuploadedad_(UploadedAd @uploadedad_)
{
string commandText = "TriggerGetByUploadedAd";
List<SqlParameter> parameters = new List<SqlParameter>();
parameters.Add(new SqlParameter("@uploadedad_id", @uploadedad_.uploadedad_id));
return GetList<Trigger>(@uploadedad_, commandText, parameters);
}
/// <summary>
/// Gets a collection of Trigger objects by a UploadedAd object.
/// </summary>
/// <param name="uploadedAd">uploadedAd</param>
/// <param name="startRowIndex"></param>
/// <param name="pageSize"></param>
/// <param name="totalRows"></param>
/// <returns>A collection Trigger objects.</returns>
public static EntityList<Trigger> GetTriggersByuploadedad_(UploadedAd @uploadedad_, long startRowIndex, int pageSize, out long totalRows)
{
string commandText = @"
FROM
[dbo].[Triggers]
WHERE
[Triggers].[uploadedad_id] = @uploadedad_id ";
List<SqlParameter> parameters = new List<SqlParameter>();
parameters.Add(new SqlParameter("@uploadedad_id", @uploadedad_.uploadedad_id));
return GetList<Trigger>(SelectFieldList, commandText, parameters, null, startRowIndex, pageSize, out totalRows);
}
/// <summary>
/// Deletes Trigger objects by a UploadedAd object.
/// </summary>
/// <param name="uploadedAd">uploadedAd</param>
public static void DeleteTriggersByuploadedad_(UploadedAd uploadedAd)
{
string commandText = "TriggerDeleteByUploadedAd";
System.Collections.Generic.List<SqlParameter> parameters = new System.Collections.Generic.List<SqlParameter>();
parameters.Add(new SqlParameter("@uploadedad_id", uploadedAd.uploadedad_id));
using (SqlHelper helper = new SqlHelper())
{
helper.Execute(commandText, CommandType.StoredProcedure, parameters);
}
}
/// <summary>
/// Create a new Trigger object from a UploadedAd object.
/// </summary>
/// <param name="uploadedad_">uploadedad_</param>
/// <returns>The newly created Trigger object.</returns>
public static Trigger CreateTriggerByuploadedad_(UploadedAd @uploadedad_)
{
Trigger trigger = InitializeNew<Trigger>();
trigger.uploadedad_id = @uploadedad_.uploadedad_id;
trigger.uploadedad_ = @uploadedad_;
return trigger;
}
/// <summary>
/// Gets a collection of RequestedAd objects by a UploadedAd object.
/// </summary>
/// <param name="uploadedAd">uploadedAd</param>
/// <param name="orderBy"></param>
/// <param name="startRowIndex"></param>
/// <param name="pageSize"></param>
/// <param name="totalRows"></param>
/// <returns>A collection RequestedAd objects.</returns>
protected static EntityList<RequestedAd> GetRequestedAdsByuploadedad_(UploadedAd @uploadedad_, string orderBy, long startRowIndex, int pageSize, out long totalRows)
{
string commandText = @"
FROM
[dbo].[RequestedAds]
WHERE
[RequestedAds].[uploadedad_id] = @uploadedad_id ";
List<SqlParameter> parameters = new List<SqlParameter>();
parameters.Add(new SqlParameter("@uploadedad_id", @uploadedad_.uploadedad_id));
return GetList<RequestedAd>(SelectFieldList, commandText, parameters, orderBy, startRowIndex, pageSize, out totalRows);
}
/// <summary>
/// Create a new RequestedAd object from a UploadedAd object.
/// </summary>
/// <param name="uploadedad_">uploadedad_</param>
/// <returns>The newly created RequestedAd object.</returns>
public static RequestedAd CreateRequestedAdByuploadedad_(UploadedAd @uploadedad_)
{
RequestedAd requestedAd = InitializeNew<RequestedAd>();
requestedAd.uploadedad_id = @uploadedad_.uploadedad_id;
requestedAd.uploadedad_ = @uploadedad_;
return requestedAd;
}
/// <summary>
/// Create a new PlacedAd object from a UploadedAd object.
/// </summary>
/// <param name="uploadedad_">uploadedad_</param>
/// <returns>The newly created PlacedAd object.</returns>
public static PlacedAd CreatePlacedAdByuploadedad_(UploadedAd @uploadedad_)
{
PlacedAd placedAd = InitializeNew<PlacedAd>();
placedAd.uploadedad_id = @uploadedad_.uploadedad_id;
placedAd.uploadedad_ = @uploadedad_;
return placedAd;
}