Пример #1
0
        public static DataSet GetCurrentSize(int productId)
        {
            DataSet lresultDataSet = new DataSet();


            // DataTable  dataTable = new DataTable();

            SqlConnection lConnection = new SqlConnection();

            lConnection.ConnectionString = ShoeStoreDB.GetConnectionString();

            string lCommandString = @"SELECT ID,Name,Country,CreationDate,Code,Description FROM Manufacture";

            // Создаем и настраиваем экземпляр класса SqlDataAdapter
            SqlDataAdapter adapter = new SqlDataAdapter(lCommandString, lConnection);

            try
            {
                // lconnection.Open();
                adapter.Fill(lresultDataSet, "Manufacture");
            }
            catch (Exception ex)
            {
            }
            finally
            {
                if (lConnection.State == ConnectionState.Open)
                {
                    lConnection.Close();
                }
            }

            return(lresultDataSet);
        }
Пример #2
0
        public static string GetProductTitleImage(int pProductId)
        {
            string lresult = string.Empty;

            SqlConnection lConnection = new SqlConnection();

            lConnection.ConnectionString = ShoeStoreDB.GetConnectionString();

            SqlCommand lCommand = new SqlCommand("GetProductTitleImage", lConnection);

            lCommand.CommandType = System.Data.CommandType.StoredProcedure;


            lCommand.Parameters.Add(new SqlParameter(@"ProductId", SqlDbType.Int));
            lCommand.Parameters[@"ProductId"].Value = pProductId;

            try
            {
                lConnection.Open();
                lresult = (string)lCommand.ExecuteScalar();
                // lresult = (int)lcommand.Parameters[@"NewProductId"].Value;
            }
            catch (Exception ex) { }
            finally
            {
                if (lConnection.State == ConnectionState.Open)
                {
                    lConnection.Close();
                }
            }
            return(lresult);
        }
Пример #3
0
        /// <summary>
        /// insert new company to dataBase
        /// </summary>
        /// <param name="pId">id</param>
        /// <param name="pCompanyName">Company Name</param>
        /// <param name="pCountry">Country for Manufacture</param>
        /// <param name="pCode">internal manufacturer code</param>
        /// <param name="pCreateDate">date of the founding of the company</param>
        /// <param name="pDecription">Text description of the company</param>
        /// <returns>successful making changes</returns>
        public static bool CreateNewManufacture(string pCompanyName, string pCountry, string pCode, DateTime pCreateDate, string pDecription)
        {
            bool lResult = false;

            SqlConnection lConnection = new SqlConnection();

            lConnection.ConnectionString = ShoeStoreDB.GetConnectionString();

            string lCommandText = @"INSERT INTO Manufacture
                                                (Name
                                                ,Country
                                                ,CreationDate
                                                ,Code
                                                ,Description)
                                            VALUES
                                                (@Name
                                                ,@Country
                                                ,@CreationDate
                                                ,@Code
                                                ,@Description)";

            SqlCommand lCommand = new SqlCommand();

            lCommand.CommandText = lCommandText;
            lCommand.Connection  = lConnection;

            lCommand.Parameters.Add(new SqlParameter(@"Name", SqlDbType.NVarChar, 250));
            lCommand.Parameters[@"Name"].Value = pCompanyName;


            lCommand.Parameters.Add(new SqlParameter(@"Country", SqlDbType.NVarChar, 250));
            lCommand.Parameters[@"Country"].Value = pCountry;


            lCommand.Parameters.Add(new SqlParameter(@"CreationDate", SqlDbType.SmallDateTime));
            lCommand.Parameters[@"CreationDate"].Value = pCreateDate;

            lCommand.Parameters.Add(new SqlParameter(@"Code", SqlDbType.NVarChar, 50));
            lCommand.Parameters[@"Code"].Value = pCode;

            lCommand.Parameters.Add(new SqlParameter(@"Description", SqlDbType.NVarChar, 400));
            lCommand.Parameters[@"Description"].Value = pCompanyName;

            try
            {
                lConnection.Open();
                lCommand.ExecuteNonQuery();
                lResult = true;
            }
            catch { }
            finally
            {
                if (lConnection.State == ConnectionState.Open)
                {
                    lConnection.Close();
                }
            }

            return(lResult);
        }
Пример #4
0
        public static DataSet GetTypes()
        {
            DataSet dataSet = new DataSet();

            SqlConnection lConnection = new SqlConnection();

            lConnection.ConnectionString = ShoeStoreDB.GetConnectionString();

            string lCommandString = @"SELECT ID,TypeItem FROM TypeItem";

            // Создаем и настраиваем экземпляр класса SqlDataAdapter
            SqlDataAdapter adapter = new SqlDataAdapter(lCommandString, lConnection);

            try
            {
                adapter.Fill(dataSet);
            }
            catch (Exception ex)
            {
            }
            finally
            {
                if (lConnection.State == ConnectionState.Open)
                {
                    lConnection.Close();
                }
            }
            return(dataSet);
        }
Пример #5
0
        public static DataSet GetCountSize(int pProductId)
        {
            DataSet ldataSet = new DataSet();

            SqlConnection lConnection = new SqlConnection();

            lConnection.ConnectionString = ShoeStoreDB.GetConnectionString();

            SqlCommand lCommand     = new SqlCommand();
            string     lCommandText = @"select Size.ID, Size.Size, ProductSize.ProductCount
                                     FROM  ProductSize INNER JOIN
                                            Size ON ProductSize.SizeID = Size.ID
                                WHERE(ProductSize.ProductId = @ProductID)";

            lCommand.CommandText = lCommandText;
            lCommand.Connection  = lConnection;


            SqlParameter lparametr = new SqlParameter(@"ProductID", SqlDbType.Int);

            lparametr.Value = pProductId;
            //lCommand.Parameters.Add(new SqlParameter);
            //lCommand.Parameters[@"ProductID"].Value = pProductId;

            SqlDataAdapter adapter = new SqlDataAdapter();

            adapter.SelectCommand = lCommand;



            //.CommandText = @"SELECT Size.*

            /*                    FROM  ProductSize INNER JOIN
             *                         Size ON ProductSize.SizeID = Size.ID
             *             WHERE(ProductSize.ProductId = @ProductID)";
             */
            //lCommandText;
            adapter.SelectCommand.Parameters.Add(lparametr);

            try
            {
                adapter.Fill(ldataSet);
            }
            catch (SqlException exc)
            {
            }
            catch (Exception ex)
            {
            }
            finally
            {
                if (lConnection.State == ConnectionState.Open)
                {
                    lConnection.Close();
                }
            }


            return(ldataSet);
        }
Пример #6
0
        /// <summary>
        /// a list of all the Size
        /// </summary>
        /// <returns>data set</returns>
        public static DataSet GetSeason()
        {
            DataSet dataSet = new DataSet();

            SqlConnection lConnection = new SqlConnection();

            lConnection.ConnectionString = ShoeStoreDB.GetConnectionString();

            string lCommandString = @"SELECT ID,Size FROM Size";

            SqlDataAdapter adapter = new SqlDataAdapter(lCommandString, lConnection);

            try
            {
                adapter.Fill(dataSet, "Size");
            }
            catch (Exception ex)
            {
            }
            finally
            {
                if (lConnection.State == ConnectionState.Open)
                {
                    lConnection.Close();
                }
            }
            return(dataSet);
        }
Пример #7
0
        /// <summary>
        /// Remove the selected season
        /// </summary>
        /// <param name="pSeasonId">id selected records</param>
        /// <returns>successful changes</returns>
        public static bool DeleteSeasonal(int pSeasonId)
        {
            bool lResult = false;

            SqlConnection lConnection = new SqlConnection();

            lConnection.ConnectionString = ShoeStoreDB.GetConnectionString();
            string     lSqlCommandstring = @"DELETE FROM SeasonalType WHERE ID = @ID";
            SqlCommand lCommand          = new SqlCommand(lSqlCommandstring, lConnection);

            lCommand.Parameters.AddWithValue("@ID", pSeasonId);

            try
            {
                lConnection.Open();
                lCommand.ExecuteNonQuery();
                lResult = true;
            }
            catch (SqlException exc)
            {
            }
            catch (Exception ex)
            {
            }
            finally
            {
                if (lConnection.State == ConnectionState.Open)
                {
                    lConnection.Close();
                }
            }

            return(lResult);
        }
Пример #8
0
        /// <summary>
        /// inser new color value to db
        /// </summary>
        /// <param name="pColor">color name</param>
        /// <returns></returns>
        public static bool AddType(string pTypeName)
        {
            bool result = false;

            SqlConnection lConnection = new SqlConnection();

            lConnection.ConnectionString = ShoeStoreDB.GetConnectionString();
            string lSqlCommandstring = @"INSERT INTO TypeItem VALUES(@TypeName)";

            SqlCommand lCommand = new SqlCommand(lSqlCommandstring, lConnection);

            lCommand.Parameters.AddWithValue("@TypeName", pTypeName);

            try
            {
                lConnection.Open();
                lCommand.ExecuteNonQuery();
                result = true;
            }
            catch (SqlException exc)
            {
            }
            catch (Exception ex)
            {
            }
            finally
            {
                if (lConnection.State == ConnectionState.Open)
                {
                    lConnection.Close();
                }
            }

            return(result);
        }
Пример #9
0
        public static decimal ComputeProductsValue(int productId)
        {
            decimal lresult = 0;

            SqlConnection lconnection = new SqlConnection();

            lconnection.ConnectionString = ShoeStoreDB.GetConnectionString();

            string     lcommandText = "select Cost  From product where id  = @ProductId";
            SqlCommand lcommand     = new SqlCommand(lcommandText, lconnection);

            lcommand.Parameters.Add(new SqlParameter(@"ProductId", SqlDbType.Int));
            lcommand.Parameters[@"ProductId"].Value = productId;

            try
            {
                lconnection.Open();
                lresult = (decimal)lcommand.ExecuteScalar();
                // lresult = (int)lcommand.Parameters[@"NewProductId"].Value;
            }
            catch (Exception ex)
            {
            }
            finally
            {
                if (lconnection.State == ConnectionState.Open)
                {
                    lconnection.Close();
                }
            }


            return(lresult);
        }
Пример #10
0
        /// <summary>
        /// delete colors from db
        /// </summary>
        /// <param name="pColor">id color for deleting</param>
        /// <returns></returns>
        public static int DeleteType(int ptypeId)
        {
            int lResult = 0;

            SqlConnection lConnection = new SqlConnection();

            lConnection.ConnectionString = ShoeStoreDB.GetConnectionString();
            string     lSqlCommandstring = @"DELETE FROM TypeItem WHERE ID = @ID";
            SqlCommand lCommand          = new SqlCommand(lSqlCommandstring, lConnection);

            lCommand.Parameters.AddWithValue("@ID", ptypeId);

            try
            {
                lConnection.Open();
                lCommand.ExecuteNonQuery();
                lResult = 0;
            }
            catch (SqlException exc)
            {
                lResult = 2;
            }
            catch (Exception ex)
            {
            }
            finally
            {
                if (lConnection.State == ConnectionState.Open)
                {
                    lConnection.Close();
                }
            }

            return(lResult);
        }
Пример #11
0
        public static int InsertImage(int pProductId, string pImageUrl, string pImagePreviewPath, string pCaption,
                                      bool pIsTitle, string pImageName, int pSize)
        {
            int lresult;

            lresult = 0;

            SqlConnection lConnection = new SqlConnection();

            lConnection.ConnectionString = ShoeStoreDB.GetConnectionString();

            SqlCommand lcommand = new SqlCommand("InsertImage", lConnection);

            lcommand.CommandType = CommandType.StoredProcedure;

            lcommand.Parameters.Add(new SqlParameter(@"ImageUrl", SqlDbType.NVarChar, 255));
            lcommand.Parameters[@"ImageUrl"].Value = pImageUrl;

            lcommand.Parameters.Add(new SqlParameter(@"imagePreviewPath", SqlDbType.NVarChar, 255));
            lcommand.Parameters[@"imagePreviewPath"].Value = pImagePreviewPath;

            lcommand.Parameters.Add(new SqlParameter(@"CreationDate", SqlDbType.SmallDateTime));
            lcommand.Parameters[@"CreationDate"].Value = DateTime.Now;

            lcommand.Parameters.Add(new SqlParameter(@"Caption", SqlDbType.NVarChar, 255));
            lcommand.Parameters[@"Caption"].Value = pCaption;

            lcommand.Parameters.Add(new SqlParameter(@"istitle", SqlDbType.Bit));
            lcommand.Parameters[@"istitle"].Value = pIsTitle;

            lcommand.Parameters.Add(new SqlParameter(@"imageName", SqlDbType.NVarChar, 255));
            lcommand.Parameters[@"imageName"].Value = pImageName;

            lcommand.Parameters.Add(new SqlParameter(@"productId", SqlDbType.Int));
            lcommand.Parameters[@"productId"].Value = pProductId;

            lcommand.Parameters.Add(new SqlParameter(@"NewImageId", SqlDbType.Int));
            lcommand.Parameters[@"NewImageId"].Direction = ParameterDirection.Output;
            try
            {
                lConnection.Open();
                lcommand.ExecuteNonQuery();
                lresult = (int)lcommand.Parameters[@"NewImageId"].Value;
            }
            catch (Exception ex) { }
            finally
            {
                if (lConnection.State == ConnectionState.Open)
                {
                    lConnection.Close();
                }
            }

            return(lresult);
        }
Пример #12
0
        /// <summary>
        /// обновление записи в БД
        /// </summary>
        /// <param name="pId"></param>
        /// <param name="pMaterial"></param>
        /// <returns></returns>
        public static int UpdateMaterial(int pId, string pMaterial)
        {
            int lResult = 0;

            SqlConnection lConnection = new SqlConnection();

            lConnection.ConnectionString = ShoeStoreDB.GetConnectionString();

            string lCommandText = @"UPDATE MaterialType
                                         SET MaterialType = @MaterialType                                            
                                        WHERE  ID = @ID";

            SqlCommand lCommand = new SqlCommand();

            lCommand.CommandText = lCommandText;
            lCommand.Connection  = lConnection;

            lCommand.Parameters.Add(new SqlParameter(@"MaterialType", SqlDbType.NVarChar, 250));
            lCommand.Parameters[@"MaterialType"].Value = pMaterial;

            lCommand.Parameters.Add(new SqlParameter(@"ID", SqlDbType.Int));
            lCommand.Parameters[@"ID"].Value = pId;


            try
            {
                lConnection.Open();
                lCommand.ExecuteNonQuery();
                lResult = 0;
            }
            catch (SqlException exc)
            {
                lResult = 1;
            }
            catch (Exception ex)
            {
                lResult = 2;
            }
            finally
            {
                if (lConnection.State == ConnectionState.Open)
                {
                    lConnection.Close();
                }
            }


            return(lResult);
        }
Пример #13
0
        /// <summary>
        /// update record in database
        /// </summary>
        /// <param name="pId">id</param>
        /// <param name="pSeasonalName">name</param>
        /// <returns>successful changes</returns>
        public static bool UpdateSize(int pId, string pSize)
        {
            bool lResult = false;

            SqlConnection lConnection = new SqlConnection();

            lConnection.ConnectionString = ShoeStoreDB.GetConnectionString();

            string lCommandText = @"UPDATE Size
                                         SET Size = @Size                                            
                                        WHERE  ID = @ID";

            SqlCommand lCommand = new SqlCommand();

            lCommand.CommandText = lCommandText;
            lCommand.Connection  = lConnection;

            lCommand.Parameters.Add(new SqlParameter(@"Size", SqlDbType.NVarChar, 250));
            lCommand.Parameters[@"Size"].Value = pSize;

            lCommand.Parameters.Add(new SqlParameter(@"ID", SqlDbType.Int));
            lCommand.Parameters[@"ID"].Value = pId;


            try
            {
                lConnection.Open();
                lCommand.ExecuteNonQuery();
                lResult = true;
            }
            catch (SqlException exc)
            {
            }
            catch (Exception ex)
            {
            }
            finally
            {
                if (lConnection.State == ConnectionState.Open)
                {
                    lConnection.Close();
                }
            }


            return(lResult);
        }
Пример #14
0
        /// <summary>
        /// add new rebview for product to data base
        /// </summary>
        /// <param name="pProductId"></param>
        /// <param name="puserName"></param>
        /// <param name="ptext"></param>
        public static bool SetReviewForProduct(int pProductId, string puserName, string ptext)
        {
            //@userName nvarchar(255),@Text nvarChar(max), @productID int

            bool lresult = false;

            SqlConnection lconnection = new SqlConnection();

            lconnection.ConnectionString = ShoeStoreDB.GetConnectionString();

            SqlCommand lcommand = new SqlCommand("CreateReview", lconnection);

            lcommand.CommandType = System.Data.CommandType.StoredProcedure;


            lcommand.Parameters.Add(new SqlParameter(@"ProductId", SqlDbType.Int));
            lcommand.Parameters[@"ProductId"].Value = pProductId;

            lcommand.Parameters.Add(new SqlParameter(@"Text", SqlDbType.NText));
            lcommand.Parameters[@"Text"].Value = ptext;

            lcommand.Parameters.Add(new SqlParameter(@"userName", SqlDbType.NVarChar, 255));
            lcommand.Parameters[@"userName"].Value = puserName;


            try
            {
                lconnection.Open();
                lcommand.ExecuteNonQuery();
                lresult = true;
                // lresult = (int)lcommand.Parameters[@"NewProductId"].Value;
            }
            catch (Exception ex)
            {
            }
            finally
            {
                if (lconnection.State == ConnectionState.Open)
                {
                    lconnection.Close();
                }
            }
            return(lresult);
        }
Пример #15
0
        /// <summary>
        ////добавление
        /// </summary>
        /// <param name="pProductId"></param>
        /// <returns></returns>
        public static bool SetProductsSize(int pProductId, int psizeid, int pProductCount)
        {
            bool lresult = false;
            //SetProductsSize
            SqlConnection lconnection = new SqlConnection();

            lconnection.ConnectionString = ShoeStoreDB.GetConnectionString();

            SqlCommand lcommand = new SqlCommand("SetProductsSize", lconnection);

            lcommand.CommandType = System.Data.CommandType.StoredProcedure;

            lcommand.Parameters.Add(new SqlParameter(@"productid", SqlDbType.Int));
            lcommand.Parameters[@"productid"].Value = pProductId;

            lcommand.Parameters.Add(new SqlParameter(@"sizeId", SqlDbType.Int));
            lcommand.Parameters[@"sizeId"].Value = psizeid;;

            lcommand.Parameters.Add(new SqlParameter(@"count", SqlDbType.Int));
            lcommand.Parameters[@"count"].Value = pProductCount;;

            try
            {
                lconnection.Open();
                lcommand.ExecuteNonQuery();
                lresult = true;
            }
            catch (SqlException exc)
            {
            }
            catch (Exception ex)
            {
            }
            finally
            {
                if (lconnection.State == ConnectionState.Open)
                {
                    lconnection.Close();
                }
            }

            return(lresult);
        }
Пример #16
0
        /// <summary>
        ///  receiving data according to the selected size
        /// </summary>
        /// <param name="pProductId"></param>
        /// <param name="psize"></param>
        /// <returns></returns>
        public static DataSet GetProductBySize(int pProductId, int psize)
        {
            DataSet ldataSet = new DataSet();

            SqlConnection lconnection = new SqlConnection();

            lconnection.ConnectionString = ShoeStoreDB.GetConnectionString();

            SqlCommand lcommand = new SqlCommand("GetProductsInfoById", lconnection);

            lcommand.CommandType = System.Data.CommandType.StoredProcedure;


            lcommand.Parameters.Add(new SqlParameter(@"ProductId", SqlDbType.Int));
            lcommand.Parameters[@"ProductId"].Value = pProductId;

            lcommand.Parameters.Add(new SqlParameter(@"Size", SqlDbType.Int));
            lcommand.Parameters[@"Size"].Value = psize;

            SqlDataAdapter ladapter = new SqlDataAdapter(lcommand);

            try
            {
                //lconnection.Open();
                ladapter.Fill(ldataSet);
            }
            catch (SqlException ex)
            {
            }
            catch (Exception ex)
            {
            }

            finally
            {
                if (lconnection.State == ConnectionState.Open)
                {
                    lconnection.Close();
                }
            }
            return(ldataSet);
        }
Пример #17
0
        public static DataSet GetProductValueToCart(int productId)
        {
            DataSet ldataSet = new DataSet();

            SqlConnection lconnection = new SqlConnection();

            lconnection.ConnectionString = ShoeStoreDB.GetConnectionString();

            string lcommandText = @"SELECT  Product.Name, Manufacture.Name AS ManufactyreName, Manufacture.Country,Product.Cost
                                     FROM   Product INNER JOIN Manufacture ON Product.ManufacturedId = Manufacture.ID
                                    WHERE   Product.ID  = @ProductId";

            SqlCommand lcommand = new SqlCommand(lcommandText, lconnection);

            lcommand.Parameters.Add(new SqlParameter(@"ProductId", SqlDbType.Int));
            lcommand.Parameters[@"ProductId"].Value = productId;

            SqlDataAdapter ladapter = new SqlDataAdapter(lcommand);

            try
            {
                //lconnection.Open();
                ladapter.Fill(ldataSet);
            }
            catch (SqlException ex)
            {
            }
            catch (Exception ex)
            {
            }

            finally
            {
                if (lconnection.State == ConnectionState.Open)
                {
                    lconnection.Close();
                }
            }

            return(ldataSet);
        }
Пример #18
0
        public static int GetProductCount(int pProductId, int psizeId)
        {
            int lresult = 0;

            SqlConnection lconnection = new SqlConnection();

            lconnection.ConnectionString = ShoeStoreDB.GetConnectionString();

            SqlCommand lcommand = new SqlCommand("GetProductCount", lconnection);

            lcommand.CommandType = System.Data.CommandType.StoredProcedure;

            lcommand.Parameters.Add(new SqlParameter(@"ProductId", SqlDbType.Int));
            lcommand.Parameters[@"ProductId"].Value = pProductId;

            lcommand.Parameters.Add(new SqlParameter(@"SizeID", SqlDbType.Int));
            lcommand.Parameters[@"SizeID"].Value = psizeId;;

            try
            {
                lconnection.Open();
                lresult = (int)lcommand.ExecuteScalar();
            }
            catch (SqlException exc)
            {
            }
            catch (Exception ex)
            {
            }
            finally
            {
                if (lconnection.State == ConnectionState.Open)
                {
                    lconnection.Close();
                }
            }

            return(lresult);
        }
Пример #19
0
        /// <summary>
        /// delete colors from db
        /// </summary>
        /// <param name="pColor">id color for deleting</param>
        /// <returns></returns>
        public static bool EditType(int pColorId, string ptype)
        {
            bool lResult = false;

            SqlConnection lConnection = new SqlConnection();

            lConnection.ConnectionString = ShoeStoreDB.GetConnectionString();
            string     lSqlCommandstring = @"UPDATE TypeItem SET TypeItem = @TypeItem WHERE ID=@ID";
            SqlCommand lCommand          = new SqlCommand(lSqlCommandstring, lConnection);

            lCommand.Parameters.Add(new SqlParameter(@"ID", SqlDbType.Int));
            lCommand.Parameters[@"ID"].Value = pColorId;

            lCommand.Parameters.Add(new SqlParameter(@"TypeItem", SqlDbType.NVarChar, 255));
            lCommand.Parameters[@"TypeItem"].Value = ptype;

            try
            {
                lConnection.Open();
                lCommand.ExecuteNonQuery();
                lResult = true;
            }
            catch (SqlException exc)
            {
            }
            catch (Exception ex)
            {
            }
            finally
            {
                if (lConnection.State == ConnectionState.Open)
                {
                    lConnection.Close();
                }
            }

            return(lResult);
        }
Пример #20
0
        /// <summary>
        /// создание новой записи
        /// </summary>
        /// <param name="pMaterialName">название материала</param>

        public static bool CreateNewMaterial(string pMaterialName)
        {
            bool lResult = false;

            SqlConnection lConnection = new SqlConnection();

            lConnection.ConnectionString = ShoeStoreDB.GetConnectionString();

            string lCommandText = @"INSERT INTO MaterialType( MaterialType )
                                            VALUES ( @MaterialType )";



            SqlCommand lCommand = new SqlCommand();

            lCommand.CommandText = lCommandText;
            lCommand.Connection  = lConnection;

            lCommand.Parameters.Add(new SqlParameter(@"MaterialType", SqlDbType.NVarChar, 250));
            lCommand.Parameters[@"MaterialType"].Value = pMaterialName;

            try
            {
                lConnection.Open();
                lCommand.ExecuteNonQuery();
                lResult = true;
            }
            catch { }
            finally
            {
                if (lConnection.State == ConnectionState.Open)
                {
                    lConnection.Close();
                }
            }

            return(lResult);
        }
Пример #21
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="pProductId"></param>
        /// <returns></returns>
        public static DataSet GetSizeForCurrentProduct(int pProductId)
        {
            DataSet dataSet = new DataSet();

            SqlConnection lConnection = new SqlConnection();

            lConnection.ConnectionString = ShoeStoreDB.GetConnectionString();

            string lCommandString = @"SELECT Size.ID, Size.Size
                                        FROM ProductSize INNER JOIN
                                             Size ON ProductSize.SizeID = Size.ID
                                             AND ProductSize.ProductID = @Productid";

            SqlCommand lCommand = new SqlCommand(lCommandString, lConnection);

            lCommand.Parameters.Add(new SqlParameter(@"Productid", SqlDbType.Int));
            lCommand.Parameters[@"Productid"].Value = pProductId;


            SqlDataAdapter adapter = new SqlDataAdapter(lCommand);

            try
            {
                adapter.Fill(dataSet);
            }
            catch (Exception ex)
            {
            }
            finally
            {
                if (lConnection.State == ConnectionState.Open)
                {
                    lConnection.Close();
                }
            }
            return(dataSet);
        }
Пример #22
0
        public static bool DeleteProduct(int productId)
        {
            bool lresult = false;

            SqlConnection lconnection = new SqlConnection();

            lconnection.ConnectionString = ShoeStoreDB.GetConnectionString();

            SqlCommand lcommand = new SqlCommand("deleteProduct", lconnection);

            lcommand.CommandType = System.Data.CommandType.StoredProcedure;

            lcommand.Parameters.Add(new SqlParameter(@"ProductId", SqlDbType.Int));
            lcommand.Parameters[@"ProductId"].Value = productId;
            try
            {
                lconnection.Open();
                lcommand.ExecuteNonQuery();
                lresult = true;
            }
            catch (SqlException exc)
            {
            }
            catch (Exception ex)
            {
            }
            finally
            {
                if (lconnection.State == ConnectionState.Open)
                {
                    lconnection.Close();
                }
            }

            return(lresult);
        }
Пример #23
0
        /// <summary>
        /// обновление текущего значения для указанного производителя
        /// </summary>
        /// <param name="pId">id</param>
        /// <param name="pCompanyName">Company Name</param>
        /// <param name="pCountry">Country for Manufacture</param>
        /// <param name="pCode">internal manufacturer code</param>
        /// <param name="pCreateDate">date of the founding of the company</param>
        /// <param name="pDecription">Text description of the company</param>
        /// <returns>successful making changes</returns>
        public static bool UpdateManufacture(int pId, string pCompanyName, string pCountry, string pCode, DateTime pCreateDate, string pDecription)
        {
            bool lResult = false;

            SqlConnection lConnection = new SqlConnection();

            lConnection.ConnectionString = ShoeStoreDB.GetConnectionString();

            string lCommandText = @"UPDATE Manufacture
                                         SET Name = @Name
                                            ,Country = @Country
                                            ,CreationDate = @CreationDate
                                            ,Code = @Code
                                            ,Description = @Description
                                        WHERE  ID = @ID";

            SqlCommand lCommand = new SqlCommand();

            lCommand.CommandText = lCommandText;
            lCommand.Connection  = lConnection;

            lCommand.Parameters.Add(new SqlParameter(@"Name", SqlDbType.NVarChar, 250));
            lCommand.Parameters[@"Name"].Value = pCompanyName;


            lCommand.Parameters.Add(new SqlParameter(@"Country", SqlDbType.NVarChar, 250));
            lCommand.Parameters[@"Country"].Value = pCountry;

            lCommand.Parameters.Add(new SqlParameter(@"CreationDate", SqlDbType.SmallDateTime));
            lCommand.Parameters[@"CreationDate"].Value = pCreateDate;

            lCommand.Parameters.Add(new SqlParameter(@"Code", SqlDbType.NVarChar, 50));
            lCommand.Parameters[@"Code"].Value = pCode;

            lCommand.Parameters.Add(new SqlParameter(@"Description", SqlDbType.NVarChar, 400));
            lCommand.Parameters[@"Description"].Value = pCompanyName;

            lCommand.Parameters.Add(new SqlParameter(@"ID", SqlDbType.Int));
            lCommand.Parameters[@"ID"].Value = pId;


            try
            {
                lConnection.Open();
                lCommand.ExecuteNonQuery();
                lResult = true;
            }
            catch (SqlException exc)
            {
            }
            catch (Exception ex)
            {
            }
            finally
            {
                if (lConnection.State == ConnectionState.Open)
                {
                    lConnection.Close();
                }
            }


            return(lResult);
        }
Пример #24
0
        public static int CreateProduct(int pColorId, int pSizeId, int pSexId, int pMaterialTypeId,
                                        int pManufactureId, int pSeasonId, int pTypeId, string pName, decimal pCost, string pCode,
                                        string pDescription)
        {
            int lresult = 0;

            SqlConnection lConnection = new SqlConnection();

            lConnection.ConnectionString = ShoeStoreDB.GetConnectionString();

            SqlCommand lCommand = new SqlCommand("CreateProduct", lConnection);

            lCommand.CommandType = System.Data.CommandType.StoredProcedure;


            lCommand.Parameters.Add(new SqlParameter(@"Name", SqlDbType.NVarChar, 255));
            lCommand.Parameters[@"Name"].Value = pName;

            lCommand.Parameters.Add(new SqlParameter(@"ColorId", SqlDbType.Int));
            lCommand.Parameters[@"ColorId"].Value = pColorId;

            lCommand.Parameters.Add(new SqlParameter(@"SizeId", SqlDbType.Int));
            lCommand.Parameters[@"SizeId"].Value = pSizeId;

            lCommand.Parameters.Add(new SqlParameter(@"SexId", SqlDbType.Int));
            lCommand.Parameters[@"SexId"].Value = pSexId;

            lCommand.Parameters.Add(new SqlParameter(@"TypeId", SqlDbType.Int));
            lCommand.Parameters[@"TypeId"].Value = pTypeId;

            lCommand.Parameters.Add(new SqlParameter(@"MaterialTypeID", SqlDbType.Int));
            lCommand.Parameters[@"MaterialTypeID"].Value = pMaterialTypeId;

            lCommand.Parameters.Add(new SqlParameter(@"ManufactureID", SqlDbType.Int));
            lCommand.Parameters[@"ManufactureID"].Value = pManufactureId;

            lCommand.Parameters.Add(new SqlParameter(@"SeasonId", SqlDbType.Int));
            lCommand.Parameters[@"SeasonId"].Value = pSeasonId;

            lCommand.Parameters.Add(new SqlParameter(@"cost", SqlDbType.Decimal));
            lCommand.Parameters[@"cost"].Value = pCost;

            lCommand.Parameters.Add(new SqlParameter(@"DescriptionText", SqlDbType.NText));
            lCommand.Parameters[@"DescriptionText"].Value = pDescription;

            lCommand.Parameters.Add(new SqlParameter(@"Code", SqlDbType.NVarChar, 255));
            lCommand.Parameters[@"Code"].Value = pCode;

            //lCommand.Parameters.Add(new SqlParameter(@"CountItem", SqlDbType.Int));
            //lCommand.Parameters[@"CountItem"].Value = pcount;

            lCommand.Parameters.Add(new SqlParameter(@"NewProductId", SqlDbType.Int));
            lCommand.Parameters[@"NewProductId"].Direction = ParameterDirection.Output;
            try
            {
                lConnection.Open();
                lCommand.ExecuteNonQuery();
                lresult = (int)lCommand.Parameters[@"NewProductId"].Value;
            }
            catch (Exception ex) { }
            finally
            {
                if (lConnection.State == ConnectionState.Open)
                {
                    lConnection.Close();
                }
            }

            return(lresult);
        }
Пример #25
0
        /// <summary>
        /// updated product information
        /// </summary>
        /// <param name="pProduxtId">product id </param>
        /// <param name="pname">name</param>
        /// <param name="pcode">inner code, articul</param>
        /// <param name="pmanufactureId">manufacture id </param>
        /// <param name="pcolorId">color id </param>
        /// <param name="pmaterialId">matrerial id</param>
        /// <param name="psizeId">size id</param>
        /// <param name="psexId">size id</param>
        /// <param name="pseasonId">season id</param>
        /// <param name="typeId">current type id</param>
        /// <param name="pdescriptionId">products description</param>
        /// <param name="pCost">value of goods</param>
        /// <returns></returns>
        public static bool UpdateProduct(int pProductId, string pname, string pcode, int pmanufactureId,
                                         int pcolorId, int pmaterialId, int psizeId, int psexId, int pseasonId, int typeId, string pdescription,
                                         decimal pCost)
        {
            bool lresult = false;

            SqlConnection lconnection = new SqlConnection();

            lconnection.ConnectionString = ShoeStoreDB.GetConnectionString();

            SqlCommand lCommand = new SqlCommand("[UpdateProductById]", lconnection);

            lCommand.CommandType = System.Data.CommandType.StoredProcedure;


            lCommand.Parameters.Add(new SqlParameter(@"name", SqlDbType.NVarChar, 255));
            lCommand.Parameters[@"name"].Value = pname;

            lCommand.Parameters.Add(new SqlParameter(@"Code", SqlDbType.NVarChar, 255));
            lCommand.Parameters[@"Code"].Value = pcode;

            lCommand.Parameters.Add(new SqlParameter(@"manufactureID", SqlDbType.Int));
            lCommand.Parameters[@"manufactureID"].Value = pmanufactureId;

            lCommand.Parameters.Add(new SqlParameter(@"ColorID", SqlDbType.Int));
            lCommand.Parameters[@"ColorID"].Value = pcolorId;

            lCommand.Parameters.Add(new SqlParameter(@"MaterialID", SqlDbType.Int));
            lCommand.Parameters[@"MaterialID"].Value = pmaterialId;

            lCommand.Parameters.Add(new SqlParameter(@"SizeID", SqlDbType.Int));
            lCommand.Parameters[@"SizeID"].Value = psizeId;

            lCommand.Parameters.Add(new SqlParameter(@"SexID", SqlDbType.Int));
            lCommand.Parameters[@"SexID"].Value = psexId;

            lCommand.Parameters.Add(new SqlParameter(@"SesonID", SqlDbType.Int));
            lCommand.Parameters[@"SesonID"].Value = pseasonId;

            lCommand.Parameters.Add(new SqlParameter(@"TypeID", SqlDbType.Int));
            lCommand.Parameters[@"TypeID"].Value = typeId;

            lCommand.Parameters.Add(new SqlParameter(@"Desctiption", SqlDbType.NText));
            lCommand.Parameters[@"Desctiption"].Value = pdescription;

            lCommand.Parameters.Add(new SqlParameter(@"Cost", SqlDbType.Decimal));
            lCommand.Parameters[@"Cost"].Value = pCost;

            //lCommand.Parameters.Add(new SqlParameter(@"Count", SqlDbType.Int));
            //lCommand.Parameters[@"Count"].Value = typeId;

            lCommand.Parameters.Add(new SqlParameter(@"ProductID", SqlDbType.Int));
            lCommand.Parameters[@"ProductID"].Value = pProductId;

            try
            {
                lconnection.Open();
                lCommand.ExecuteNonQuery();
                lresult = true;
            }
            catch (Exception ex) { }
            finally
            {
                if (lconnection.State == ConnectionState.Open)
                {
                    lconnection.Close();
                }
            }
            return(lresult);
        }