protected void DataPortal_Delete(CategoryCriteria criteria)
        {
            bool cancel = false;

            OnDeleting(criteria, ref cancel);
            if (cancel)
            {
                return;
            }

            using (var connection = new SqlConnection(ADOHelper.ConnectionString))
            {
                connection.Open();
                using (var command = new SqlCommand("[dbo].[CSLA_Category_Delete]", connection))
                {
                    command.CommandType = CommandType.StoredProcedure;
                    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();
        }
        protected void DataPortal_Fetch(CategoryCriteria criteria)
        {
            bool cancel = false;

            OnFetching(criteria, ref cancel);
            if (cancel)
            {
                return;
            }

            using (var connection = new SqlConnection(ADOHelper.ConnectionString))
            {
                connection.Open();
                using (var command = new SqlCommand("[dbo].[CSLA_Category_Select]", connection))
                {
                    command.CommandType = CommandType.StoredProcedure;
                    command.Parameters.AddRange(ADOHelper.SqlParameters(criteria.StateBag));
                    command.Parameters.AddWithValue("@p_NameHasValue", criteria.NameHasValue);
                    command.Parameters.AddWithValue("@p_DescnHasValue", criteria.DescriptionHasValue);
                    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.Category' using the following criteria: {0}.", criteria));
                        }
                    }
                }
            }

            OnFetched();
        }
Example #3
0
        public static async Task <CategoryList> GetByCategoryIdAsync(System.String categoryId)
        {
            var criteria = new CategoryCriteria {
                CategoryId = categoryId
            };


            return(await DataPortal.FetchAsync <CategoryList>(criteria));
        }
Example #4
0
        public static CategoryList GetByCategoryId(System.String categoryId)
        {
            var criteria = new CategoryCriteria {
                CategoryId = categoryId
            };


            return(DataPortal.Fetch <CategoryList>(criteria));
        }
Example #5
0
        public static async Task DeleteCategoryAsync(System.String categoryId)
        {
            var criteria = new CategoryCriteria {
                CategoryId = categoryId
            };


            await DataPortal.DeleteAsync <Category>(criteria);
        }
Example #6
0
        public static void DeleteCategory(System.String categoryId)
        {
            var criteria = new CategoryCriteria {
                CategoryId = categoryId
            };


            DataPortal.Delete <Category>(criteria);
        }
Example #7
0
        private void DataPortal_Fetch(CategoryCriteria criteria)
        {
            bool cancel = false;

            OnFetching(criteria, ref cancel);
            if (cancel)
            {
                return;
            }

            RaiseListChangedEvents = false;

            // Fetch Child objects.
            using (var connection = new SqlConnection(ADOHelper.ConnectionString))
            {
                connection.Open();
                using (var command = new SqlCommand("[dbo].[CSLA_Category_Select]", connection))
                {
                    command.CommandType = CommandType.StoredProcedure;
                    command.Parameters.AddRange(ADOHelper.SqlParameters(criteria.StateBag));
                    command.Parameters.AddWithValue("@p_NameHasValue", criteria.NameHasValue);
                    command.Parameters.AddWithValue("@p_DescnHasValue", criteria.DescriptionHasValue);
                    using (var reader = new SafeDataReader(command.ExecuteReader()))
                    {
                        if (reader.Read())
                        {
                            do
                            {
                                this.Add(PetShop.Tests.Collections.EditableRoot.Category.GetCategory(reader));
                            } while(reader.Read());
                        }
                    }
                }
            }

            RaiseListChangedEvents = true;

            OnFetched();
        }
Example #8
0
 public static async Task <CategoryList> GetByCriteriaAsync(CategoryCriteria criteria)
 {
     return(await DataPortal.FetchAsync <CategoryList>(criteria));
 }
Example #9
0
 public static CategoryList GetByCriteria(CategoryCriteria criteria)
 {
     return(DataPortal.Fetch <CategoryList>(criteria));
 }
Example #10
0
 /// <summary>
 /// Determines if a record exists in the Category in the database for the specified criteria.
 /// </summary>
 public static async Task <bool> ExistsAsync(CategoryCriteria criteria)
 {
     return(await PetShop.Tests.Collections.EditableRoot.ExistsCommand.ExecuteAsync(criteria));
 }
Example #11
0
 /// <summary>
 /// Determines if a record exists in the Category in the database for the specified criteria.
 /// </summary>
 /// <param name="criteria">The criteria parameter is a <see cref="CategoryList"/> object.</param>
 /// <returns>A boolean value of true is returned if a record is found.</returns>
 public static bool Exists(CategoryCriteria criteria)
 {
     return(PetShop.Tests.Collections.EditableRoot.Category.Exists(criteria));
 }
Example #12
0
 /// <summary>
 /// CodeSmith generated stub method that is called when fetching the child <see cref="Category"/> object.
 /// </summary>
 /// <param name="criteria"><see cref="CategoryCriteria"/> 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(CategoryCriteria criteria, ref bool cancel);
        protected override void DataPortal_Update()
        {
            bool cancel = false;

            OnUpdating(ref cancel);
            if (cancel)
            {
                return;
            }

            if (OriginalCategoryId != CategoryId)
            {
                // Insert new child.
                Category item = new Category {
                    CategoryId = CategoryId, Name = Name, Description = Description
                };

                item = item.Save();

                // Mark editable child lists as dirty. This code may need to be updated to one-to-one relationships.

                // Create a new connection.
                using (var connection = new SqlConnection(ADOHelper.ConnectionString))
                {
                    connection.Open();
                    FieldManager.UpdateChildren(this, connection);
                }

                // Delete the old.
                var criteria = new CategoryCriteria {
                    CategoryId = OriginalCategoryId
                };

                DataPortal_Delete(criteria);

                // Mark the original as the new one.
                OriginalCategoryId = CategoryId;
                OnUpdated();

                return;
            }

            using (var connection = new SqlConnection(ADOHelper.ConnectionString))
            {
                connection.Open();
                using (var command = new SqlCommand("[dbo].[CSLA_Category_Update]", connection))
                {
                    command.CommandType = CommandType.StoredProcedure;
                    command.Parameters.AddWithValue("@p_OriginalCategoryId", this.OriginalCategoryId);
                    command.Parameters.AddWithValue("@p_CategoryId", this.CategoryId);
                    command.Parameters.AddWithValue("@p_Name", ADOHelper.NullCheck(this.Name));
                    command.Parameters.AddWithValue("@p_Descn", ADOHelper.NullCheck(this.Description));
                    //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.");
                    }

                    LoadProperty(_originalCategoryIdProperty, this.CategoryId);
                }
            }

            OnUpdated();
        }
Example #14
0
 /// <summary>
 /// CodeSmith generated stub method that is called when deleting the <see cref="Category"/> object.
 /// </summary>
 /// <param name="criteria"><see cref="CategoryCriteria"/> 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(CategoryCriteria criteria, ref bool cancel);