/// <summary>
/// Gets a collection of OutgoingSMS objects by a BillingItem object.
/// </summary>
/// <param name="billingItem">billingItem</param>
/// <param name="startRowIndex"></param>
/// <param name="pageSize"></param>
/// <param name="totalRows"></param>
/// <returns>A collection OutgoingSMS objects.</returns>
public static EntityList<OutgoingSMS> GetOutgoingSMsBybillingitem_(BillingItem @billingitem_, long startRowIndex, int pageSize, out long totalRows)
{
string commandText = @"
FROM
[dbo].[OutgoingSMS]
WHERE
[OutgoingSMS].[billingitem_id] = @billingitem_id ";
List<SqlParameter> parameters = new List<SqlParameter>();
parameters.Add(new SqlParameter("@billingitem_id", @billingitem_.billingitem_id));
return GetList<OutgoingSMS>(SelectFieldList, commandText, parameters, null, startRowIndex, pageSize, out totalRows);
}
/// <summary>
/// Deletes OutgoingSMS objects by a BillingItem object.
/// </summary>
/// <param name="billingItem">billingItem</param>
public static void DeleteOutgoingSMsBybillingitem_(BillingItem billingItem)
{
string commandText = "OutgoingSMSDeleteByBillingItem";
System.Collections.Generic.List<SqlParameter> parameters = new System.Collections.Generic.List<SqlParameter>();
parameters.Add(new SqlParameter("@billingitem_id", billingItem.billingitem_id));
using (SqlHelper helper = new SqlHelper())
{
helper.Execute(commandText, CommandType.StoredProcedure, parameters);
}
}
/// <summary>
/// Gets a collection of OutgoingSMS objects by a BillingItem object.
/// </summary>
/// <param name="billingitem_">billingitem_</param>
/// <returns>A collection OutgoingSMS objects.</returns>
public static EntityList<OutgoingSMS> GetOutgoingSMsBybillingitem_(BillingItem @billingitem_)
{
string commandText = "OutgoingSMSGetByBillingItem";
List<SqlParameter> parameters = new List<SqlParameter>();
parameters.Add(new SqlParameter("@billingitem_id", @billingitem_.billingitem_id));
return GetList<OutgoingSMS>(@billingitem_, commandText, parameters);
}
/// <summary>
/// Create a new OutgoingSMS object from a BillingItem object.
/// </summary>
/// <param name="billingitem_">billingitem_</param>
/// <returns>The newly created OutgoingSMS object.</returns>
public static OutgoingSMS CreateOutgoingSMSBybillingitem_(BillingItem @billingitem_)
{
OutgoingSMS outgoingSMS = InitializeNew<OutgoingSMS>();
outgoingSMS.billingitem_id = @billingitem_.billingitem_id;
outgoingSMS.billingitem_ = @billingitem_;
return outgoingSMS;
}
