示例#1
0
        public void UpdateConsignor()
        {
            // SETUP
            ConsignorClasses.Consignor c = new Consignor();
            ConsignorClasses.ConsignorUtilities u = new ConsignorUtilities();
            c.Address1City = testAddressCity;
            c.Address1State = testAddressState;
            c.Address1Street = testStreet;
            c.Address1Zip = testZip;
            c.CellPhone = testCell;
            c.Comments = testComments;
            c.ConsignorID = GetMaxConsignorID();
            c.Donate = true;
            c.EmailAddress = testEmail;
            c.FirstName = testUpdatedFirstName;
            c.HomePhone = testHomePhone;
            c.LastName = testUpdatedLastName;
            c.WorkPhone = testWorkPhone;

            // TRIGGER
            bool updateResult = u.Consignor_Update(c);
            ConsignorClasses.Consignor updated = new Consignor();
            updated = u.GetExistingConsignor(GetMaxConsignorID());

            // VALIDATE
            Assert.AreEqual(true, updateResult, "expected different result");
            Assert.AreEqual(c.LastName, updated.LastName, "expected same updated last name");
            Assert.AreEqual(c.FirstName, updated.FirstName, "expected same updated first name");
        }
示例#2
0
        public void AddConsignor()
        {
            // SETUP
            int nextConsignor = GetMaxConsignorID() + 1;
            ConsignorClasses.Consignor c = new Consignor();
            ConsignorClasses.ConsignorUtilities u = new ConsignorUtilities();
            c.Address1City = testAddressCity;
            c.Address1State = testAddressState;
            c.Address1Street = testStreet;
            c.Address1Zip = testZip;
            c.CellPhone = testCell;
            c.Comments = testComments;
            c.ConsignorID = 0;
            c.Donate = true;
            c.EmailAddress = testEmail;
            c.FirstName = testFirstName;
            c.HomePhone = testHomePhone;
            c.LastName = testLastName;
            c.WorkPhone = testWorkPhone;

            // TRIGGER
            int newConsignorID = u.AddNewConsignor(c);

            // VALIDATE
            Assert.AreEqual(nextConsignor, newConsignorID, "expected different number");
        }
示例#3
0
        private bool ConsignorUpdate()
        {
            ConsignorClasses.Consignor c = new ConsignorClasses.Consignor();
            ConsignorClasses.ConsignorUtilities cu = new ConsignorClasses.ConsignorUtilities();

            // set the updated consignor
            c.Address1City = txtCity.Text;
            c.Address1State = txtState.Text;
            c.Address1Street = txtAddress.Text;
            c.Address1Zip = txtZipCode.Text;
            c.CellPhone = txtCellPhone.Text;
            c.Comments = txtComments.Text;
            c.ConsignorID = int.Parse(txtConsignorID.Text);
            c.Donate = ckDonate.Checked;
            c.EmailAddress = txtemail.Text;
            c.FirstName = txtFirstName.Text;
            c.HomePhone = txtHomePhone.Text;
            c.LastName = txtLastName.Text;
            c.WorkPhone = txtWorkPhone.Text;

            // update the consignor
            bool result = cu.Consignor_Update(c);
            ClearConsignor();
            return result;
        }
 /// <summary>
 /// Navigate to the report when list box items have been selected
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 private void cmdGo_Click(object sender, EventArgs e)
 {
     if (listBox1.SelectedItems.Count != 0)
     {
         List<string> collection = ParseSelectedItems(listBox1.SelectedItems);
         string sqlParams = ConvertToSqlParam(collection);
         ConsignorClasses.ConsignorUtilities cu = new ConsignorClasses.ConsignorUtilities();
         ConsignorClasses.Consignor c = new ConsignorClasses.Consignor();
         c = cu.GetExistingConsignor(GlobalClass.ConsignerID);
         ConsignorID = c.ConsignorID;
         LoadReport(c.ConsignorID, sqlParams);
     }
 }
示例#5
0
        /// <summary>
        /// validations
        /// </summary>
        /// <returns></returns>
        private bool DoValidations()
        {
            if (txtConsignerID.Text == "")
            {
                return false;
            }

            if (txtConsignerID.Text != "")
            {
                try
                {
                    int itest = int.Parse(txtConsignerID.Text.ToString());
                }
                catch
                {
                    return false;
                }
            }

            // valid consignor?
            ConsignorClasses.ConsignorUtilities cu = new ConsignorClasses.ConsignorUtilities();
            if (!cu.ValidConsignor(txtConsignerID.Text))
            {
                return false;
            }

            // NOW test the data grid
            if (dgInventory.Rows.Count == 1)
            {
                return false;
            }

            for (int iRow = 0; iRow < dgInventory.Rows.Count -1; iRow++)
            {
                if (dgInventory[0, iRow].Value == null)
                {
                    return false;
                }
                try
                {
                    decimal dTest = decimal.Parse(dgInventory[1, iRow].Value.ToString());
                }
                catch
                {
                    return false;
                }
            }
            return true;
        }
 /// <summary>
 /// load the active only to start
 /// </summary>
 private void LoadActiveOnly()
 {
     string sqlParams = ConvertToSqlParam(ActiveOnlyStatus);
     ConsignorClasses.ConsignorUtilities cu = new ConsignorClasses.ConsignorUtilities();
     ConsignorClasses.Consignor c = new ConsignorClasses.Consignor();
     c = cu.GetExistingConsignor(GlobalClass.ConsignerID);
     ConsignorID = c.ConsignorID;
     LoadReport(c.ConsignorID, sqlParams);
 }
        /// <summary>
        /// load up the report
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void Report_ConsignorDetailReport_Load(object sender, EventArgs e)
        {
            this.soldStatus_Select1TableAdapter.Fill(this.doubletakeDataSet.SoldStatus_Select1);
            ConsignorClasses.ConsignorUtilities cu = new ConsignorClasses.ConsignorUtilities();
            ConsignorClasses.Consignor c = new ConsignorClasses.Consignor();
            c = cu.GetExistingConsignor(GlobalClass.ConsignerID);
            ConsignorID = c.ConsignorID;
            lblConsignorName.Text = string.Format("{0} {1}", c.FirstName, c.LastName);

            // check if this is coming from the right click on the search
            if (string.IsNullOrEmpty(GlobalClass.WhateverString))
            {
                listBox1.SelectedItems.Clear();
            }
            else
            {
                LoadReport(c.ConsignorID, GlobalClass.WhateverString);
            }
        }
示例#8
0
        private void NewConsignorInsert()
        {
            int count;
            ConsignorClasses.ConsignorUtilities cu = new ConsignorClasses.ConsignorUtilities();
            ConsignorClasses.Consignor c = new ConsignorClasses.Consignor();
            c.LastName = txtLastName.Text;
            c.FirstName = txtFirstName.Text;
            c.Address1Street = txtAddress.Text;
            c.Address1City = txtCity.Text;
            c.Address1State = txtState.Text;
            c.Address1Zip = txtZipCode.Text;
            c.HomePhone = txtHomePhone.Text;
            c.WorkPhone = txtWorkPhone.Text;
            c.CellPhone = txtCellPhone.Text;
            c.EmailAddress = txtemail.Text;
            c.Comments = txtComments.Text;
            c.Donate = ckDonate.Checked;
            c.CreateBy = "NewConsignor";

            count = cu.AddNewConsignor(c);

            switch (count)
            {
                case -1:
                    MessageBox.Show("There was a SQL Data Error", Properties.Settings.Default.MessageBoxTitle,  MessageBoxButtons.OK);
                    break;
                case -2:
                    MessageBox.Show("C# Error", Properties.Settings.Default.MessageBoxTitle, MessageBoxButtons.OK);
                    break;
                default:
                    txtConsignorID.Visible = true;
                    txtConsignorID.Text = count.ToString();
                    txtConsignorID.Enabled = false;
                    ClearConsignor();
                    break;
            }
        }
示例#9
0
        private void GetConsignor(int ConsignorID)
        {
            ConsignorClasses.ConsignorUtilities u = new ConsignorClasses.ConsignorUtilities();
            var returnedConsignor = new ConsignorClasses.Consignor();
            returnedConsignor = u.GetExistingConsignor(ConsignorID);

            // check for C# exceptions
            if (returnedConsignor.LastName.Contains("SQL Exception"))
            {
                MessageBox.Show(returnedConsignor.Comments, "SQL Data Error", MessageBoxButtons.OK);
                ClearConsignor();
            }
            else if (returnedConsignor.LastName.Contains("C# Exception"))
            {
                MessageBox.Show(returnedConsignor.Comments, "C# Error", MessageBoxButtons.OK);
                ClearConsignor();
            }
            else
            {
                txtConsignorID.Text = ConsignorID.ToString();
                txtLastName.Text = returnedConsignor.LastName;
                txtFirstName.Text = returnedConsignor.FirstName;
                txtAddress.Text = returnedConsignor.Address1Street;
                txtCity.Text = returnedConsignor.Address1City;
                txtState.Text = returnedConsignor.Address1State;
                txtZipCode.Text = returnedConsignor.Address1Zip;
                txtHomePhone.Text = returnedConsignor.HomePhone;
                txtWorkPhone.Text = returnedConsignor.WorkPhone;
                txtCellPhone.Text = returnedConsignor.CellPhone;
                txtemail.Text = returnedConsignor.EmailAddress;
                txtComments.Text = returnedConsignor.Comments;
                ckDonate.Checked = returnedConsignor.Donate;
            }
            ClearConsignor();
        }