示例#1
0
        public void NewInventory_Add()
        {
            //  SETUP
            InventoryObject io = new InventoryObject();
            io.Consignor = 5;
            io.Description = "Test Inventory Object";
            io.Price = 123.45M;
            io.Comment = "Comment";

            // TRIGGER
            MockInventoryUtilities t = new MockInventoryUtilities();
            bool actualResult = t.SaveInventory(io);

            // VALIDATE
            Assert.IsTrue(actualResult);
        }
示例#2
0
 /// <summary>
 /// Save inventory to the database
 /// </summary>
 /// <returns></returns>
 private bool SaveInventory()
 {
     for (int iRowCount = 0; iRowCount < dgInventory.Rows.Count-1; iRowCount++)
     {
         InventoryClasses.InventoryObject newInventory = new InventoryClasses.InventoryObject();
         newInventory.Consignor = int.Parse(txtConsignerID.Text.ToString());
         newInventory.Description = dgInventory[0, iRowCount].Value.ToString();
         newInventory.Price = decimal.Parse(dgInventory[1, iRowCount].Value.ToString());
         string comment = string.Empty;
         if (dgInventory[2, iRowCount].Value != null)
         {
             comment = dgInventory[2, iRowCount].Value.ToString();
         }
         newInventory.Comment = comment;
         InventoryClasses.InventoryUtilities iu = new InventoryClasses.InventoryUtilities();
         int returnValue = iu.SaveInventory(newInventory);
         if (returnValue == -1)
         {
             return false;
         }
     }
     return true;
 }
示例#3
0
        /// <summary>
        /// save the inventory item
        /// </summary>
        /// <returns></returns>
        private bool SaveInventoryItem()
        {
            InventoryClasses.InventoryObject io = new InventoryClasses.InventoryObject();
            InventoryClasses.InventoryUtilities iu = new InventoryClasses.InventoryUtilities();

            io.ItemID = txtItemID.Text;
            io.Description = txtDescription.Text;
            decimal dpResult = 0;
            if (decimal.TryParse(txtAskPrice.Text, out dpResult))
            {
                io.Price = dpResult;
            }
            else
            {
                io.Price = dpResult;
            }

            decimal dsResult = 0;
            if (decimal.TryParse(txtSellPrice.Text, out dsResult))
            {
                io.SellPrice = dsResult;
            }
            else
            {
                io.SellPrice = dsResult;
            }

            io.Comment = txtComment.Text;
            io.SoldStatus = cboSoldStatus.SelectedIndex;
            io.Returnable = ckReturn.Checked;

            //CHECK FOR NULL DATES

            DateTime dtResult = DateTime.MinValue;
            if (DateTime.TryParse(txtDateIn.Text, out dtResult))
            {
                io.DateIn = dtResult;
            }
            else
            {
                io.DateIn = DateTime.MinValue;
            }

            if (DateTime.TryParse(txtDateSold.Text, out dtResult))
            {
                io.DateSold = dtResult;
            }
            else
            {
                io.DateSold = DateTime.MinValue;
            }

            if (DateTime.TryParse(txtDatePaid.Text, out dtResult))
            {
                io.DatePaid = dtResult;
            }
            else
            {
                io.DatePaid = DateTime.MinValue;
            }
            decimal pResult = 0;
            if (decimal.TryParse(txtPaidAmount.Text, out pResult))
            {
                io.PaidAmount = pResult;
            }
            else
            {
                io.PaidAmount = pResult;
            }

            bool returnValue = iu.UpdateInventory(io);
            return returnValue;
        }
示例#4
0
        /// <summary>
        /// load up the found details for an inventory item
        /// </summary>
        /// <param name="ItemID"></param>
        private void LoadDetails(int ItemID)
        {
            try
            {
                InventoryClasses.InventoryUtilities iu = new InventoryClasses.InventoryUtilities();
                InventoryClasses.InventoryObject io = new InventoryClasses.InventoryObject();
                io = iu.GetInventoryDetails(ItemID.ToString());

                if (io == null)
                {
                    MessageBox.Show("There was a problem retrieving that inventory item", Properties.Settings.Default.MessageBoxTitle, MessageBoxButtons.OK);
                }
                else
                {
                    txtItemID.Text = io.ItemID;
                    txtDescription.Text = io.Description;
                    txtAskPrice.Text = decimal.Round(io.Price, 2).ToString();
                    txtDateIn.Text = io.DateIn.ToString();
                    txtSellPrice.Text = decimal.Round(io.SellPrice, 2).ToString();
                    if (DateTime.Compare(io.DateSold, DateTime.MinValue) == 0)
                    {
                        txtDateSold.Text = string.Empty;
                    }
                    else
                    {
                        txtDateSold.Text = io.DateSold.ToString();
                    }
                    if (DateTime.Compare(io.DatePaid, DateTime.MinValue) == 0)
                    {
                        txtDatePaid.Text = string.Empty;
                    }
                    else
                    {
                        txtDatePaid.Text = io.DatePaid.ToString();
                    }

                    txtPaidAmount.Text = decimal.Round(io.PaidAmount, 2).ToString();
                    txtComment.Text = io.Comment;
                    cboSoldStatus.SelectedIndex = io.SoldStatus;
                    this.ckReturn.Checked = io.Returnable;
                    txtConsignID.Text = io.Consignor.ToString();
                    txtConsignor.Text = io.ConsignorName;

                    if (io.Donate)
                    {
                        lblDonateCheck.Text = "x";
                    }
                    else
                    {
                        lblDonateCheck.Text = "o";
                    }
                }
            }
            catch (Exception e)
            {
                MessageBox.Show(string.Format("There was an error: {0}", e.Message), Properties.Settings.Default.MessageBoxTitle, MessageBoxButtons.OK);
            }
        }
        public InventoryObject GetInventoryDetails(string itemID)
        {
            InventoryObject returnItem = new InventoryObject();
            var d = new Decode();
            SqlConnection cn = new SqlConnection(d.ConnectionString);
            SqlCommand cmd = new SqlCommand("DTUSER.ItemID_Select");
            SqlDataReader dr;
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@pItemID", SqlDbType.Int).Value = itemID;
            try
            {
                cn.Open();
                cmd.Connection = cn;
                dr = cmd.ExecuteReader();

                while (dr.Read())
                {
                    var foundInventory = new InventoryObject();
                    foundInventory.ItemID = dr.GetValue(0).ToString();
                    foundInventory.Description = dr.GetValue(1).ToString();
                    foundInventory.Price = dr.GetSqlMoney(2).Value;
                    foundInventory.DateIn = dr.GetSqlDateTime(3).Value;
                    //HAVE TO CHECK FOR NULL VALUES ON SOLD RANGE
                    if (dr.IsDBNull(4) == true)
                    {
                        foundInventory.SellPrice = 0;
                    }
                    else
                    {
                        foundInventory.SellPrice = dr.GetSqlMoney(4).Value;
                    }

                    if (dr.IsDBNull(5) == true)
                    {
                        foundInventory.DateSold = DateTime.MinValue;
                    }
                    else
                    {
                        foundInventory.DateSold = dr.GetSqlDateTime(5).Value;
                    }

                    if (dr.IsDBNull(6) == true)
                    {
                        foundInventory.DatePaid = DateTime.MinValue;
                    }
                    else
                    {
                        foundInventory.DatePaid = dr.GetSqlDateTime(6).Value;
                    }

                    if (dr.IsDBNull(7) == true)
                    {
                        foundInventory.PaidAmount = 0;
                    }
                    else
                    {
                        foundInventory.PaidAmount = dr.GetSqlMoney(7).Value;

                    }

                    foundInventory.Comment = dr.GetValue(8).ToString();
                    foundInventory.SoldStatus = dr.GetInt32(9);
                    foundInventory.Returnable = dr.GetBoolean(10);
                    foundInventory.Consignor = dr.GetSqlInt32(11).Value;
                    foundInventory.ConsignorName = dr.GetValue(13) + ", " + dr.GetValue(12);
                    foundInventory.Donate = dr.GetBoolean(14);
                    returnItem = foundInventory;
                }

                dr.Close();
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                if ( cn.State != ConnectionState.Closed)
                {
                    cn.Close();
                }
            }

            return returnItem;
        }
        /// <summary>
        /// updates a given inventory object
        /// </summary>
        /// <param name="io"></param>
        /// <returns></returns>
        public bool UpdateInventory(InventoryObject io)
        {
            var d = new Decode();
            SqlConnection cn = new SqlConnection(d.ConnectionString);
            SqlCommand cmd = new SqlCommand("DTUSER.Inventory_Update");
            cmd.CommandType = CommandType.StoredProcedure;
            SqlParameter returnValue = new SqlParameter("@Return_Value", DbType.Int32);
            returnValue.Direction = ParameterDirection.ReturnValue;
            cmd.Parameters.Add(returnValue);

            try
            {
                cn.Open();
                cmd.Connection = cn;
                cmd.Parameters.Add("@pItemNumber", SqlDbType.Int).Value = io.ItemID;
                cmd.Parameters.Add("@pItemDescription", SqlDbType.NVarChar).Value = io.Description;
                cmd.Parameters.Add("@pAskingPrice", SqlDbType.Decimal).Value = io.Price;
                cmd.Parameters.Add("@pSellingPrice", SqlDbType.Decimal).Value = io.SellPrice;
                cmd.Parameters.Add("@pComment", SqlDbType.NVarChar).Value = io.Comment;
                cmd.Parameters.Add("@pSoldStatus", SqlDbType.Int).Value = io.SoldStatus;
                cmd.Parameters.Add("@pReturned", SqlDbType.Bit).Value = io.Returnable;
                cmd.Parameters.Add("@pDateIn", SqlDbType.DateTime).Value = io.DateIn;

                if (DateTime.Compare(io.DateSold, DateTime.MinValue) == 0)
                {
                    cmd.Parameters.Add("@pDateSold", SqlDbType.DateTime).Value = DBNull.Value;
                }
                else
                {
                    cmd.Parameters.Add("@pDateSold", SqlDbType.DateTime).Value = io.DateSold;
                }

                if (DateTime.Compare(io.DatePaid, DateTime.MinValue) == 0)
                {
                    cmd.Parameters.Add("@pDatePaid", SqlDbType.DateTime).Value = DBNull.Value;
                }
                else
                {
                    cmd.Parameters.Add("@pDatePaid", SqlDbType.DateTime).Value = io.DatePaid;
                }

                cmd.Parameters.Add("@pAmountPaid", SqlDbType.Money).Value = io.PaidAmount;
                cmd.ExecuteNonQuery();
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                if (cn.State != ConnectionState.Closed)
                {
                    cn.Close();
                }
            }
            return true;
        }
        public int SaveInventory(InventoryObject newInventory)
        {
            int newInventoryID = 0;
            var d = new Decode();
            SqlConnection cn = new SqlConnection(d.ConnectionString);
            SqlCommand cmd = new SqlCommand("DTUSER.Inventory_Insert");
            SqlParameter returnValue = new SqlParameter("@Return_Value", DbType.Int32);
            returnValue.Direction = ParameterDirection.ReturnValue;
            cmd.Parameters.Add(returnValue);
            cmd.CommandType = CommandType.StoredProcedure;
            try
            {
                cn.Open();
                cmd.Connection = cn;
                cmd.Parameters.Add("@pConsignorID", SqlDbType.Int).Value = newInventory.Consignor;
                cmd.Parameters.Add("@pItemDescription", SqlDbType.NVarChar).Value = newInventory.Description;
                cmd.Parameters.Add("@pAskingPrice", SqlDbType.Decimal).Value = newInventory.Price;
                if (string.IsNullOrEmpty(newInventory.Comment))
                {
                    cmd.Parameters.Add("@pComment", SqlDbType.NVarChar).Value = DBNull.Value;
                }
                else
                {
                    cmd.Parameters.Add("@pComment", SqlDbType.NVarChar).Value = newInventory.Comment;
                }

                cmd.ExecuteNonQuery();
                cmd.Parameters.Clear();
                newInventoryID = (int)returnValue.Value;
            }
            catch (Exception)
            {
                newInventoryID = -1;
            }
            finally
            {
                if (cn.State != ConnectionState.Closed)
                {
                    cn.Close();
                }
            }
            return newInventoryID;
        }