How to insert data from two forms into SQL table

Question

0.00/5 (No votes)

See more:

I am developing a small pos application where user can make payments and save db. Until now I stored data from one form(datagridview, textboxes etc), but now I decided to add one more form (for payments and the change). The idea is that the user call data from db in datagridview(***barcode, qty, name, price, total, vat et***c) , then press the btnpayment(***opens the 2nd form***), then the user give the the required data(give payment), then after clicking the pay button the data from two forms should be inserted into sql table

Now I want to save data from two forms into sql db in same time using same stored procedures.





The 2nd form has some textboxes (payments and change). Now upper code I want to put into 2nd form insert button , but don't know how to link two forms together. My question is what should I change in upper code to be able to put in 2nd form insert button, then insert 2 forms in same time

What I have tried:

   try

{

    conn.Open();





    foreach (DataGridViewRow row in dtgartikuj.Rows)

    {

        if (!row.IsNewRow)

        {

            SqlCommand cmd = new SqlCommand("insertfaturimi", conn);

            cmd.CommandType = CommandType.StoredProcedure;

            cmd.Parameters.Clear();

            cmd.Parameters.Add(new SqlParameter("@nrfatures", int.Parse(txtnrfatures.Text)));

            cmd.Parameters.Add(new SqlParameter("@klienti", cmbklienti.Text));

            cmd.Parameters.Add(new SqlParameter("@pagesa", faturimi));

            cmd.Parameters.Add(new SqlParameter("@nentotali", txttotali.Text));

            cmd.Parameters.Add(new SqlParameter("@zbritje", txtzbritja.Text));

            cmd.Parameters.Add(new SqlParameter("@totali", totali.Text));

            cmd.Parameters.Add(new SqlParameter("@vleratvsh", textBox1.Text));

            cmd.Parameters.Add(new SqlParameter("@nrartikujve", lblnumri.Text));

            cmd.Parameters.Add(new SqlParameter("@kasieri", lbluser.Text));

            cmd.Parameters.Add(new SqlParameter("@koha", DateTime.Now));

            cmd.Parameters.Add(new SqlParameter("@barkodi", row.Cells[0].Value));

            cmd.Parameters.Add(new SqlParameter("@emertimi", row.Cells[1].Value));

            cmd.Parameters.Add(new SqlParameter("@sasia", row.Cells[2].Value));

            cmd.Parameters.Add(new SqlParameter("@tvsh", row.Cells[4].Value));

            cmd.Parameters.Add(new SqlParameter("@cmimi", row.Cells[3].Value));

            cmd.Parameters.Add(new SqlParameter("@totalipcs", row.Cells[5].Value));

            cmd.Parameters.Add(new SqlParameter("@vlerapatvshpcs", row.Cells[6].Value));

            cmd.Parameters.Add(new SqlParameter("@vleraetvshpcs", row.Cells[7].Value));

            cmd.ExecuteNonQuery();

        }





    }

}

catch (Exception ex)

{

    MessageBox.Show("Faturimi deshtoi" + ex.ToString());

}

finally

{

    conn.Close();

}

Posted 20-May-20 8:31am

Member 12456995

Updated 20-May-20 8:43am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

phil.o · Answer 1 · 2020-05-20T08:44:00

Ideally, the second form shouldn't ever have to know anything about the details in the first form (it only should know about the total fee). Instead, the second form should validate the payment details. The first form can then use the return result of the second form to actually proceed; either by savinf the data to the database, if the second form returned a success, or by not saving and issuing a failure message, if the second form returned a failure.

Form1:

C#

using (Form2 form = new Form2(total))
{
   if (form.ShowDialog(this) == DialogResult.OK)
   {
      // Save to database and issue success message
   }
   else
   {
      // Issue a failure message
   }
}

Form2:

C#

private decimal Total;

public Form2()
{
   InitializeComponent();
}

public Form2(decimal total) : this()
{
   Total = total;
}

private void buttonPlay_Click(object sender, EventArgs e)
{
   bool paymentIsValid = ProcessPayment();
   DialogResult = paymentIsValid ? DialogResult.OK : DialogResult.Cancel;
   this.Close();
}

private bool ProcessPayment()
{
   // Handle the payment here.
   // Return true on success.
   // Return false on failure.
}