Exemplo n.º 1
0
 public static WarehouseDAL.DataContracts.ProductManagment ToDALProductManagment(this ProductManagment prMn)
 {
     return(new WarehouseDAL.DataContracts.ProductManagment()
     {
         Id = prMn.Id, ProductId = prMn.ProductId, Quantity = prMn.Quantity, ActionDate = prMn.ActionDate, Action = prMn.Action, UserId = prMn.UserId, Reason = prMn.Reason, Price = prMn.Price, SupplierId = prMn.SupplierId, Brand = prMn.Brand, LastModifyDate = prMn.LastModifyDate, IsActive = prMn.IsActive
     });
 }
        public int CreateOrUpdate(ProductManagment prMn)
        {
            var productMan = new ProductManagmentAdapter();

            return(productMan.CreateOrUpdate(prMn));
        }
        public int CreateOrUpdate(ProductManagment prMn)
        {
            int result = 0;

            using (var conn = new SqlConnection(ConnectionParameters.ConnectionString))
            {
                conn.Open();

                using (var cmd = new SqlCommand(_createOrUpdate, conn))
                {
                    cmd.CommandType = System.Data.CommandType.StoredProcedure;

                    SqlParameter pId = new SqlParameter("@id", System.Data.SqlDbType.Int);
                    pId.Value = prMn.Id;
                    cmd.Parameters.Add(pId);

                    SqlParameter pProductId = new SqlParameter("@productId", SqlDbType.Int);
                    pProductId.Value = prMn.ProductId;
                    cmd.Parameters.Add(pProductId);

                    SqlParameter pQuantity = new SqlParameter("@quantity", SqlDbType.Decimal);
                    pQuantity.Value = prMn.Quantity;
                    cmd.Parameters.Add(pQuantity);

                    SqlParameter pActionDate = new SqlParameter("@actionDate", SqlDbType.DateTime); //Date or Datatime
                    pActionDate.Value = prMn.ActionDate;
                    cmd.Parameters.Add(pActionDate);

                    SqlParameter pAction = new SqlParameter("@action", SqlDbType.Int);
                    pAction.Value = prMn.Action;
                    cmd.Parameters.Add(pAction);

                    SqlParameter pUserId = new SqlParameter("@userId", SqlDbType.Int);
                    pUserId.Value = prMn.Action;
                    cmd.Parameters.Add(pUserId);


                    SqlParameter pReason = new SqlParameter("@reason", SqlDbType.NVarChar);
                    pReason.Value = prMn.Reason;
                    cmd.Parameters.Add(pReason);


                    SqlParameter pPrice = new SqlParameter("@price", SqlDbType.Int);
                    pPrice.Value = prMn.Price;
                    cmd.Parameters.Add(pPrice);

                    SqlParameter pSupplierId = new SqlParameter("@supplierId", SqlDbType.Int);
                    pSupplierId.Value = prMn.SupplierId;
                    cmd.Parameters.Add(pSupplierId);

                    SqlParameter pBrand = new SqlParameter("@brand", SqlDbType.VarChar);
                    pBrand.Value = prMn.Brand;
                    cmd.Parameters.Add(pBrand);


                    SqlParameter pLastModifyDate = new SqlParameter("@lastModifyDate", SqlDbType.DateTime);
                    pLastModifyDate.Value = prMn.LastModifyDate;
                    cmd.Parameters.Add(pLastModifyDate);


                    SqlParameter pIsActive = new SqlParameter("@isActive", SqlDbType.Bit);
                    pIsActive.Value = prMn.IsActive;
                    cmd.Parameters.Add(pIsActive);

                    SqlParameter pResult = new SqlParameter("@res", System.Data.SqlDbType.Int);
                    pResult.Direction = System.Data.ParameterDirection.Output;
                    cmd.Parameters.Add(pResult);

                    cmd.ExecuteNonQuery();

                    result = Convert.ToInt32(pResult.Value);
                }
                return(result);
            }
        }
        public IList <ProductManagment> GetItem(int id, int userId, int productId)
        {
            IList <ProductManagment> list = null;

            if (id > 0 && userId > 0)
            {
                throw new Exception("invaild argument");
            }
            else if (id > 0 && productId > 0)
            {
                throw new Exception("invaild argument");
            }
            else if (userId > 0 && productId > 0)
            {
                throw new Exception("invaild argument");
            }
            else
            {
                using (var conn = new SqlConnection(ConnectionParameters.ConnectionString))
                {
                    conn.Open();

                    using (var cmd = new SqlCommand(_getItem, conn))
                    {
                        cmd.CommandType = System.Data.CommandType.StoredProcedure;

                        SqlParameter pId = new SqlParameter("@id", System.Data.SqlDbType.Int);
                        if (id > 0)
                        {
                            pId.Value = id;
                        }
                        else
                        {
                            pId.Value = DBNull.Value;
                        }
                        cmd.Parameters.Add(pId);

                        SqlParameter pUserId = new SqlParameter("@userId", System.Data.SqlDbType.Int);
                        if (userId > 0)
                        {
                            pUserId.Value = userId;
                        }
                        else
                        {
                            pUserId.Value = DBNull.Value;
                        }
                        cmd.Parameters.Add(pUserId);

                        SqlParameter pProductId = new SqlParameter("@productId", System.Data.SqlDbType.Int);
                        if (productId > 0)
                        {
                            pProductId.Value = productId;
                        }
                        else
                        {
                            pProductId.Value = DBNull.Value;
                        }
                        cmd.Parameters.Add(pProductId);

                        cmd.ExecuteNonQuery();

                        SqlDataReader reader = cmd.ExecuteReader();

                        if (reader.HasRows)
                        {
                            list = new List <ProductManagment>();
                            while (reader.Read())
                            {
                                ProductManagment newPrMn = new ProductManagment();
                                newPrMn.Id             = Convert.ToInt32(reader["id"]);
                                newPrMn.ProductId      = Convert.ToInt32(reader["productId"]);
                                newPrMn.Quantity       = Convert.ToDecimal(reader["quantity"]);
                                newPrMn.ActionDate     = Convert.ToDateTime(reader["actionDate"]);
                                newPrMn.Action         = Convert.ToInt32(reader["action"]);
                                newPrMn.UserId         = Convert.ToInt32(reader["userId"]);
                                newPrMn.Reason         = Convert.ToString(reader["reason"]);
                                newPrMn.Price          = Convert.ToDecimal(reader["price"]);
                                newPrMn.SupplierId     = Convert.ToInt32(reader["supplierId"]);
                                newPrMn.Brand          = Convert.ToString(reader["brand"]);
                                newPrMn.LastModifyDate = Convert.ToDateTime(reader["lastModifyDate"]);
                                newPrMn.IsActive       = Convert.ToBoolean(reader["isActive"]);
                                list.Add(newPrMn);
                            }
                        }
                    }
                }

                return(list);
            }
        }
        public int CreateOrUpdate(ProductManagment prMn)
        {
            var productManag = new ProductManagmentManager();

            return(productManag.CreateOrUpdate(prMn.ToDALProductManagment()));
        }