/// <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); }