Example #1
0
        ///SqlCommand cmd;
        public S_Jewelry()
        {
            try
            {
                DB_CONNECTION dbObj = new DB_CONNECTION();
                conn = dbObj.GetConnection();
            }

            catch (Exception ex)
            {
                MessageBox.Show("Can't Open Connection!! " + ex);
            }

            InitializeComponent();

            pictureBoxes    = new PictureBox[9];
            pictureBoxes[0] = pictureBox1;
            pictureBoxes[1] = pictureBox2;
            pictureBoxes[2] = pictureBox3;
            pictureBoxes[3] = pictureBox4;
            pictureBoxes[4] = pictureBox5;
            pictureBoxes[5] = pictureBox6;
            pictureBoxes[6] = pictureBox7;
            pictureBoxes[7] = pictureBox8;
            pictureBoxes[8] = pictureBox9;

            picturePaths = new string[pictureBoxes.Length];
            pictureIsNew = new bool[pictureBoxes.Length];

            for (int i = 0; i < pictureIsNew.Length; ++i)
            {
                pictureIsNew[i] = false;
            }
        }
Example #2
0
        public S_Gems()
        {
            try
            {
                DB_CONNECTION dbObj = new DB_CONNECTION();
                conn = dbObj.getConnection();
            }

            catch (Exception ex)
            {
                MessageBox.Show("Can't Open Connection!! " + ex);
            }


            InitializeComponent();

            // create array of pixtureboxes so that it is easier to iterate

            pictureBoxes    = new PictureBox[10];
            pictureBoxes[0] = pictureBox1;
            pictureBoxes[1] = pictureBox2;
            pictureBoxes[2] = pictureBox3;
            pictureBoxes[3] = pictureBox4;
            pictureBoxes[4] = pictureBox5;
            pictureBoxes[5] = pictureBox6;
            pictureBoxes[6] = pictureBox7;
            pictureBoxes[7] = pictureBox8;
            pictureBoxes[8] = pictureBox9;
            pictureBoxes[9] = pictureBox10;

            picturePaths = new string[pictureBoxes.Length];
            pictureIsNew = new bool[pictureBoxes.Length];

            for (int i = 0; i < pictureIsNew.Length; ++i)
            {
                pictureIsNew[i] = false;
            }


            cmbStockType.SelectedIndex = 0;



            pictureBorders    = new Label[pictureBoxes.Length];
            pictureBorders[0] = currentimage1;
            pictureBorders[1] = currentimage2;
            pictureBorders[2] = currentimage3;
            pictureBorders[3] = currentimage4;
            pictureBorders[4] = currentimage5;
            pictureBorders[5] = currentimage6;
            pictureBorders[6] = currentimage7;
            pictureBorders[7] = currentimage8;
            pictureBorders[8] = currentimage9;
            pictureBorders[9] = currentimage10;

            foreach (var border in pictureBorders)
            {
                border.Visible = false;
            }
        }
Example #3
0
        public In_certi()
        {
            try
            {
                DB_CONNECTION dbObj = new DB_CONNECTION();
                conn = dbObj.getConnection();
            }

            catch (Exception ex)
            {
                MessageBox.Show("Can't Open Connection!! " + ex);
            }



            InitializeComponent();
            CalculateTotal();

            using (var cmd = new SqlCommand("SELECT * FROM dbo.[F_Currency]", conn))
            {
                using (var reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        cmbCurrency1.Items.Add(reader["FC_TYPE"].ToString());
                        cmbCurrency2.Items.Add(reader["FC_TYPE"].ToString());
                        cmbCurrency3.Items.Add(reader["FC_TYPE"].ToString());
                    }
                }
            }
            cmbCurrency1.SelectedIndex = 0;
            cmbCurrency2.SelectedIndex = 1;
            cmbCurrency3.SelectedIndex = 2;

            // btnFCupdate.Visible = false;

            using (var cmd = new SqlCommand("SELECT * FROM dbo.[Card_Vendor]", conn))
            {
                using (var reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        cmbCardTyp.Items.Add(reader["Vendor"].ToString());
                    }
                }
            }

            cmbPaymentTyp.SelectedIndex = 0;

            for (int i = 0; i < dgvItem.Columns.Count; ++i)
            {
                dt.Columns.Add(dgvItem.Columns[i].HeaderText);
            }

            dgvItem.AutoGenerateColumns = true;
            dgvItem.Columns.Clear();
            dgvItem.DataSource = dt;
        }
Example #4
0
        private void Updatebt_Click(object sender, EventArgs e)
        {
            DB_CONNECTION  x           = new DB_CONNECTION();
            SqlConnection  conn        = x.getConnection();
            String         UpdateQuery = "Update F_Currency set FC_Rate ='" + textBox1.Text + "' where FC_TYPE ='" + comboBox1.Text + "';";
            SqlDataAdapter execute     = new SqlDataAdapter(UpdateQuery, conn);

            execute.SelectCommand.ExecuteNonQuery();
            MessageBox.Show("You've updated successfully!", "Successful Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
            conn.Close();
            this.Hide();
        }
Example #5
0
        public NewUser()
        {
            try
            {
                DB_CONNECTION dbObj = new DB_CONNECTION();
                conn = dbObj.GetConnection();
            }

            catch (Exception ex)
            {
                MessageBox.Show("Can't Open Connection!! " + ex);
            }
            InitializeComponent();
        }
Example #6
0
        public Status_of_Stocks()
        {
            try
            {
                DB_CONNECTION dbObj = new DB_CONNECTION();
                conn = dbObj.GetConnection();
            }

            catch (Exception ex)
            {
                MessageBox.Show("Can't Open Connection!! " + ex);
            }

            InitializeComponent();
            DisplayData();
        }
Example #7
0
        public Invoice_Certificate()
        {
            try
            {
                DB_CONNECTION dbObj = new DB_CONNECTION();
                conn = dbObj.getConnection();
            }

            catch (Exception ex)
            {
                MessageBox.Show("Can't Open Connection!! " + ex);
            }

            InitializeComponent();
            DisplayData();
        }
Example #8
0
        public Foriegn_Currency_Update()
        {
            InitializeComponent();

            using (var conn = new DB_CONNECTION().getConnection())
            {
                using (var cmd = new SqlCommand("SELECT [FC_TYPE] FROM dbo.[F_Currency]", conn))
                {
                    using (var reader = cmd.ExecuteReader())
                    {
                        while (reader.Read())
                        {
                            comboBox1.Items.Add(reader["FC_TYPE"].ToString());
                        }
                    }
                }
            }
        }
Example #9
0
 private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
 {
     try {
         DB_CONNECTION x = new DB_CONNECTION();
         using (SqlConnection conn = x.getConnection())
         {
             Console.WriteLine(comboBox1.Text);
             using (var command = new SqlCommand("SELECT [FC_RATE] FROM dbo.[F_Currency] where [FC_TYPE]=@FC_Type", conn))
             {
                 //Combo
                 command.Parameters.AddWithValue("FC_Type", comboBox1.Text);
                 textBox1.Text = command.ExecuteScalar().ToString();
             }
         }
     } catch (Exception ex)
     {
         MessageBox.Show(ex.ToString());
     }
 }
Example #10
0
        public Stocks_Jewelry()
        {
            //this.showUser = showUser;

            try
            {
                DB_CONNECTION dbObj = new DB_CONNECTION();
                conn = dbObj.GetConnection();
            }

            catch (Exception ex)
            {
                MessageBox.Show("Can't Open Connection!! " + ex);
            }

            InitializeComponent();
            //dataGridView1.Columns.Clear();

            DisplayData();
        }