コード例 #1
0
        private void jobCardToolStripMenuItem_Click(object sender, EventArgs e)
        {
            Jobcard jc = new Jobcard();

            jc.Show();
            this.Close();
        }
コード例 #2
0
        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                con.Open();
                string services = string.Empty;
                foreach (String s in CheckBoxList1.CheckedItems)
                {
                    services += s + ",";
                }

                cmd = new SqlCommand("insert into Customer_Details values('" + name.Text + "','" + cust_id.Text + "','" + contact_no.Text + "','" + address.Text + "','" + veichle_name.Text + "','" + veichle_no.Text + "','" + this.dateTimePicker1.Text + "','" + services + "')", con);
                cmd.ExecuteNonQuery();

                SqlCommand cmd1 = new SqlCommand("insert into Pending values('" + cust_id.Text + "','" + veichle_name.Text + "','" + services + "','" + name.Text + "')", con);
                cmd1.ExecuteNonQuery();

                MessageBox.Show("Database Updated Successfully");



                Jobcard f2 = new Jobcard();
                f2.Show();

                this.Close();

                con.Close();
            }

            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
コード例 #3
0
        private void button2_Click(object sender, EventArgs e)
        {
            con.Open();
            string services = string.Empty;

            foreach (String s in CheckBoxList1.CheckedItems)
            {
                services += s + ",";
            }
            SqlCommand cmd1 = new SqlCommand("update Customer_Details set ser_req='" + CheckBoxList1.CheckedItems + "' where cust_id='" + cust_id.Text.ToString() + "'", con);

            cmd1.ExecuteNonQuery();

            SqlCommand cmd2 = new SqlCommand("insert into Pending values('" + cust_id.Text + "','" + veichle_name.Text + "','" + services + "','" + name.Text + "')", con);

            cmd2.ExecuteNonQuery();
            MessageBox.Show("Databse Updated Successfully", "", MessageBoxButtons.OK, MessageBoxIcon.Information);

            Jobcard f2 = new Jobcard();

            f2.Show();

            con.Close();
            this.Close();
        }
コード例 #4
0
        private void button1_Click(object sender, EventArgs e)
        {
            con.Open();
            SqlCommand cmd = new SqlCommand("insert into jobspares values('" + job_spares_id.Text + "','" + item_code.Text + "','" + item_name.Text + "','" + units_sold.Text + "','" + unit_price.Text + "','" + handling.Text + "','" + vat.Text + "')", con);

            cmd.ExecuteNonQuery();

            Jobcard f2 = new Jobcard();

            f2.Refresh();

            this.Close();
            MessageBox.Show("Saved Successfully", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
        }