/// <summary>
/// Gets a collection of Docket objects by a Customer object.
/// </summary>
/// <param name="customer_">customer_</param>
/// <returns>A collection Docket objects.</returns>
public static EntityList<Docket> GetDocketsBycustomer_(Customer @customer_)
{
string commandText = "DocketGetByCustomer";
List<SqlParameter> parameters = new List<SqlParameter>();
parameters.Add(new SqlParameter("@customer_id", @customer_.customer_id));
return GetList<Docket>(@customer_, commandText, parameters);
}
/// <summary>
/// Gets a collection of Docket objects by a Customer object.
/// </summary>
/// <param name="customer">customer</param>
/// <param name="startRowIndex"></param>
/// <param name="pageSize"></param>
/// <param name="totalRows"></param>
/// <returns>A collection Docket objects.</returns>
public static EntityList<Docket> GetDocketsBycustomer_(Customer @customer_, long startRowIndex, int pageSize, out long totalRows)
{
string commandText = @"
FROM
[dbo].[Dockets]
WHERE
[Dockets].[customer_id] = @customer_id ";
List<SqlParameter> parameters = new List<SqlParameter>();
parameters.Add(new SqlParameter("@customer_id", @customer_.customer_id));
return GetList<Docket>(SelectFieldList, commandText, parameters, null, startRowIndex, pageSize, out totalRows);
}
/// <summary>
/// Deletes Docket objects by a Customer object.
/// </summary>
/// <param name="customer">customer</param>
public static void DeleteDocketsBycustomer_(Customer customer)
{
string commandText = "DocketDeleteByCustomer";
System.Collections.Generic.List<SqlParameter> parameters = new System.Collections.Generic.List<SqlParameter>();
parameters.Add(new SqlParameter("@customer_id", customer.customer_id));
using (SqlHelper helper = new SqlHelper())
{
helper.Execute(commandText, CommandType.StoredProcedure, parameters);
}
}
/// <summary>
/// Create a new Docket object from a Customer object.
/// </summary>
/// <param name="customer_">customer_</param>
/// <returns>The newly created Docket object.</returns>
public static Docket CreateDocketBycustomer_(Customer @customer_)
{
Docket docket = InitializeNew<Docket>();
docket.customer_id = @customer_.customer_id;
docket.customer_ = @customer_;
return docket;
}
/// <summary>
/// Gets a collection of PointsLog objects by a Customer object.
/// </summary>
/// <param name="customer_">customer_</param>
/// <returns>A collection PointsLog objects.</returns>
public static EntityList<PointsLog> GetPointsLogsBycustomer_(Customer @customer_)
{
string commandText = "PointsLogGetByCustomer";
List<SqlParameter> parameters = new List<SqlParameter>();
parameters.Add(new SqlParameter("@customer_id", @customer_.customer_id));
return GetList<PointsLog>(@customer_, commandText, parameters);
}
/// <summary>
/// Create a new PointsLog object from a Customer object.
/// </summary>
/// <param name="customer_">customer_</param>
/// <returns>The newly created PointsLog object.</returns>
public static PointsLog CreatePointsLogBycustomer_(Customer @customer_)
{
PointsLog pointsLog = InitializeNew<PointsLog>();
pointsLog.customer_id = @customer_.customer_id;
pointsLog.customer_ = @customer_;
return pointsLog;
}
/// <summary>
/// Gets a collection of PointsLog objects by a Customer object.
/// </summary>
/// <param name="customer">customer</param>
/// <param name="orderBy"></param>
/// <param name="startRowIndex"></param>
/// <param name="pageSize"></param>
/// <param name="totalRows"></param>
/// <returns>A collection PointsLog objects.</returns>
protected static EntityList<PointsLog> GetPointsLogsBycustomer_(Customer @customer_, string orderBy, long startRowIndex, int pageSize, out long totalRows)
{
string commandText = @"
FROM
[dbo].[PointsLog]
WHERE
[PointsLog].[customer_id] = @customer_id ";
List<SqlParameter> parameters = new List<SqlParameter>();
parameters.Add(new SqlParameter("@customer_id", @customer_.customer_id));
return GetList<PointsLog>(SelectFieldList, commandText, parameters, orderBy, startRowIndex, pageSize, out totalRows);
}
