Exemple #1
0
        private void Add(String recordname, String description, string year, string price)
        {
            // method for adding into db
            String sql = "Insert into Records(RecordName,Description,Year,Price) Values (@recordname,@description,@year,@price)";

            sqlcom = new SqlCommand(sql, sqlconn);
            sqlcom.Parameters.AddWithValue("@recordname", recordname);
            sqlcom.Parameters.AddWithValue("@description", description);

            sqlcom.Parameters.AddWithValue("@year", year);
            sqlcom.Parameters.AddWithValue("@price", price);

            try
            {
                if (sqlconn.State == ConnectionState.Closed)
                {
                    sqlconn.Open();
                }


                if (sqlcom.ExecuteNonQuery() > 0)
                {
                    MessageBox.Show("Data Successfully Added!");
                }
                sqlconn.Close();
                int recordID = GetRecordId(recordname);
                AddShipping(recordID, 0);
                Records newadd = new Records();
                newadd.UserUsers = FunctionUsers;
                newadd.Text      = "Records - Admin";
                newadd.Show();
                this.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Error!");
            }
        }
Exemple #2
0
        public void Search()
        {
            // method for searching info using parameters based on checked checkboxes
            searchparams = "";


            if (!chkRecord.Checked && !chkDescription.Checked && !chkYear.Checked && !chkPrice.Checked)
            {
                MessageBox.Show("Please CHECK search parameter and ENTER data into CHECKED field!", "WARNING");
                return;
            }

            try
            {
                if (chkRecord.Checked)
                {
                    if (string.IsNullOrEmpty(txtRecord.Text))
                    {
                        MessageBox.Show("Search field \"RECORD NAME\" must not be EMPTY!", "ERROR!");
                        return;
                    }
                    if (string.IsNullOrEmpty(searchparams))
                    {
                        searchparams += "RecordName like '" + txtRecord.Text + "%" + "'";
                    }
                    else
                    {
                        searchparams += " and RecordName like '" + txtRecord.Text + "%" + "'";
                    }
                }

                if (chkDescription.Checked)
                {
                    if (string.IsNullOrEmpty(txtDescription.Text))
                    {
                        MessageBox.Show("Search field \"DESCRIPTION\" must not be EMPTY!", "ERROR!");
                        return;
                    }
                    if (string.IsNullOrEmpty(searchparams))
                    {
                        searchparams += "Description like '" + txtDescription.Text + "%" + "'";
                    }
                    else
                    {
                        searchparams += " and Description like '" + txtDescription.Text + "%" + "'";
                    }
                }

                if (chkYear.Checked)
                {
                    if (string.IsNullOrEmpty(txtYear.Text))
                    {
                        MessageBox.Show("Search field \"YEAR\" must not be EMPTY!", "ERROR!");
                        return;
                    }
                    if (string.IsNullOrEmpty(searchparams))
                    {
                        searchparams += "Year like " + txtYear.Text;
                    }
                    else
                    {
                        searchparams += " and Year like " + txtYear.Text;
                    }
                }

                if (chkPrice.Checked)
                {
                    int plus1 = Convert.ToInt32(txtPrice.Text) + 1;
                    if (string.IsNullOrEmpty(txtPrice.Text))
                    {
                        MessageBox.Show("Search field \"PRICE\" must not be EMPTY!", "ERROR!");
                        return;
                    }
                    if (string.IsNullOrEmpty(searchparams))
                    {
                        searchparams += "Price between " + txtPrice.Text + " and " + plus1;
                    }
                    else
                    {
                        searchparams += " and Price between " + txtPrice.Text + " and " + plus1;
                    }
                }

                Records passdata = new Records();
                passdata.Trial    += searchparams;
                passdata.UserUsers = FunctionUsers;
                passdata.Text      = "Records - Admin";
                passdata.TrialRetrieve();
                passdata.Show();

                this.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "ERROR!");
            }
        }