/// <summary> /// Retrieves data from the data base into a CSLA editable child business object of type <see cref="OrderStatus"/> /// using the criteria provided. /// </summary> /// <param name="criteria">Object of type <see cref="OrderStatusCriteria"/></param> /// <returns></returns> private void Child_Fetch(OrderStatusCriteria criteria) { bool cancel = false; OnChildFetching(criteria, ref cancel); if (cancel) { return; } string commandText = String.Format("SELECT [OrderId], [LineNum], [Timestamp], [Status] FROM [dbo].[OrderStatus] {0}", ADOHelper.BuildWhereStatement(criteria.StateBag)); using (var connection = new SqlConnection(ADOHelper.ConnectionString)) { connection.Open(); using (var command = new SqlCommand(commandText, connection)) { command.Parameters.AddRange(ADOHelper.SqlParameters(criteria.StateBag)); using (var reader = new SafeDataReader(command.ExecuteReader())) { if (reader.Read()) { Map(reader); } else { throw new Exception(String.Format("The record was not found in 'dbo.OrderStatus' using the following criteria: {0}.", criteria)); } } } } OnChildFetched(); }
/// <summary> /// Deletes data in the data base using the criteria specified in the OrderStatusCriteria object. /// </summary> /// <param name="criteria">Object of type <see cref="OrderStatusCriteria"/></param> /// <returns></returns> protected void DataPortal_Delete(OrderStatusCriteria criteria, SqlConnection connection) { bool cancel = false; OnDeleting(criteria, connection, ref cancel); if (cancel) { return; } var commandText = String.Format("DELETE FROM [dbo].[OrderStatus] {0}", ADOHelper.BuildWhereStatement(criteria.StateBag)); using (var command = new SqlCommand(commandText, connection)) { command.Parameters.AddRange(ADOHelper.SqlParameters(criteria.StateBag)); //result: The number of rows changed, inserted, or deleted. -1 for select statements; 0 if no rows were affected, or the statement failed. int result = command.ExecuteNonQuery(); if (result == 0) { throw new DBConcurrencyException("The entity is out of date on the client. Please update the entity and try again. This could also be thrown if the sql statement failed to execute."); } } OnDeleted(); }
internal static async Task <OrderStatus> GetByOrderIdAsync(System.Int32 orderId) { var criteria = new OrderStatusCriteria { OrderId = orderId }; return(await DataPortal.FetchAsync <AsyncChildLoader <OrderStatus> >(criteria).ContinueWith(t => t.Result.Child)); }
/// <summary> /// Returns a <see cref="OrderStatus"/> object of the specified criteria. /// </summary> /// <param name="orderId">No additional detail available.</param> /// <returns>A <see cref="OrderStatus"/> object of the specified criteria.</returns> internal static OrderStatus GetByOrderId(System.Int32 orderId) { var criteria = new OrderStatusCriteria { OrderId = orderId }; return(DataPortal.FetchChild <OrderStatus>(criteria)); }
/// <summary> /// Returns a <see cref="OrderStatus"/> object of the specified criteria. /// </summary> /// <param name="orderId">No additional detail available.</param> /// <param name="lineNum">No additional detail available.</param> /// <returns>A <see cref="OrderStatus"/> object of the specified criteria.</returns> internal static OrderStatus GetByOrderIdLineNum(System.Int32 orderId, System.Int32 lineNum) { var criteria = new OrderStatusCriteria { OrderId = orderId, LineNum = lineNum }; return(DataPortal.FetchChild <OrderStatus>(criteria)); }
/// <summary> /// Returns a <see cref="OrderStatusList"/> object of the specified criteria. /// </summary> /// <param name="orderId">No additional detail available.</param> /// <returns>A <see cref="OrderStatusList"/> object of the specified criteria.</returns> public static OrderStatusList GetByOrderId(System.Int32 orderId) { var criteria = new OrderStatusCriteria { OrderId = orderId }; return(DataPortal.Fetch <OrderStatusList>(criteria)); }
/// <summary> /// Returns a <see cref="OrderStatusList"/> object of the specified criteria. /// </summary> /// <param name="orderId">No additional detail available.</param> /// <param name="lineNum">No additional detail available.</param> /// <returns>A <see cref="OrderStatusList"/> object of the specified criteria.</returns> public static OrderStatusList GetByOrderIdLineNum(System.Int32 orderId, System.Int32 lineNum) { var criteria = new OrderStatusCriteria { OrderId = orderId, LineNum = lineNum }; return(DataPortal.Fetch <OrderStatusList>(criteria)); }
public static async Task <OrderStatusList> GetByOrderIdAsync(System.Int32 orderId) { var criteria = new OrderStatusCriteria { OrderId = orderId }; return(await DataPortal.FetchAsync <OrderStatusList>(criteria)); }
private void DataPortal_Fetch(OrderStatusCriteria criteria) { bool cancel = false; OnFetching(criteria, ref cancel); if (cancel) { return; } RaiseListChangedEvents = false; // Fetch Child objects. string commandText = String.Format("SELECT [OrderId], [LineNum], [Timestamp], [Status] FROM [dbo].[OrderStatus] {0}", ADOHelper.BuildWhereStatement(criteria.StateBag)); using (var connection = new SqlConnection(ADOHelper.ConnectionString)) { connection.Open(); using (var command = new SqlCommand(commandText, connection)) { command.Parameters.AddRange(ADOHelper.SqlParameters(criteria.StateBag)); using (var reader = new SafeDataReader(command.ExecuteReader())) { if (reader.Read()) { do { this.Add(PetShop.Tests.ParameterizedSQL.OrderStatus.GetOrderStatus(reader)); } while(reader.Read()); } } } } RaiseListChangedEvents = true; OnFetched(); }
/// <summary> /// Determines if a record exists in the OrderStatus in the database for the specified criteria. /// </summary> public static async Task <bool> ExistsAsync(OrderStatusCriteria criteria) { return(await PetShop.Tests.ParameterizedSQL.ExistsCommand.ExecuteAsync(criteria)); }
/// <summary> /// Determines if a record exists in the OrderStatus in the database for the specified criteria. /// </summary> /// <param name="criteria">The criteria parameter is a <see cref="OrderStatusList"/> object.</param> /// <returns>A boolean value of true is returned if a record is found.</returns> public static bool Exists(OrderStatusCriteria criteria) { return(PetShop.Tests.ParameterizedSQL.OrderStatus.Exists(criteria)); }
/// <summary> /// CodeSmith generated stub method that is called when fetching the child <see cref="OrderStatus"/> object. /// </summary> /// <param name="criteria"><see cref="OrderStatusCriteria"/> object containing the criteria of the object to fetch.</param> /// <param name="cancel">Value returned from the method indicating whether the object fetching should proceed.</param> partial void OnFetching(OrderStatusCriteria criteria, ref bool cancel);
public static async Task <OrderStatusList> GetByCriteriaAsync(OrderStatusCriteria criteria) { return(await DataPortal.FetchAsync <OrderStatusList>(criteria)); }
public static OrderStatusList GetByCriteria(OrderStatusCriteria criteria) { return(DataPortal.Fetch <OrderStatusList>(criteria)); }
/// <summary> /// CodeSmith generated stub method that is called when deleting the child <see cref="OrderStatus"/> object. /// </summary> /// <param name="criteria"><see cref="OrderStatusCriteria"/> object containing the criteria of the object to delete.</param> /// <param name="cancel">Value returned from the method indicating whether the object deletion should proceed.</param> partial void OnDeleting(OrderStatusCriteria criteria, ref bool cancel);
/// <summary> /// Determines if a record exists in the OrderStatus table in the database for the specified criteria. /// </summary> /// <param name="criteria">The criteria parameter is an <see cref="OrderStatus"/> object.</param> /// <returns>A boolean value of true is returned if a record is found.</returns> public static bool Exists(OrderStatusCriteria criteria) { return(PetShop.Tests.ParameterizedSQL.ExistsCommand.Execute(criteria)); }
/// <summary> /// CodeSmith generated stub method that is called when deleting the child <see cref="OrderStatus"/> object. /// </summary> /// <param name="criteria"><see cref="OrderStatusCriteria"/> object containing the criteria of the object to delete.</param> /// <param name="connection"></param> /// <param name="cancel">Value returned from the method indicating whether the object deletion should proceed.</param> partial void OnDeleting(OrderStatusCriteria criteria, SqlConnection connection, ref bool cancel);