// Read the Data from the Data field public void ReadData(TabPage currentTab, string ID) { string Fname =null; string Lname = null; string Phone = null; string Addres = null; string cusomer_id = null; int Sum=0 ; int price = 0; #region Read_out // Check the personal datas and read from the text Boxes foreach (Control lapok in currentTab.Controls) { if (lapok.GetType().ToString() == "System.Windows.Forms.TextBox") { switch (lapok.Name) { case "Fname": if ( lapok.Text.Length <2) { MessageBox.Show("Please type in your Firs Name"); return; } Fname = lapok.Text; break; case "Lname": if (lapok.Text.Length < 2) { MessageBox.Show("Please type in your Last Name"); return; } Lname = lapok.Text; break; case "ID": if (lapok.Text.Length < 1) { MessageBox.Show("Please type in your ID"); return; } cusomer_id = lapok.Text; break; case "Addres": if (lapok.Text.Length < 2) { MessageBox.Show("Please type in your Addres"); return; } Addres = lapok.Text; break; case "Phone": if (lapok.Text.Length < 2) { MessageBox.Show("Please type in your Phone Number"); return; } Phone = lapok.Text; break; case "Sum": if (lapok.Text.Length > 2) { if (int.TryParse(lapok.Text, out Sum)) { Sum = int.Parse(lapok.Text); } else { MessageBox.Show("Please type in a valid amount"); return; } } else { MessageBox.Show("Please type in the amount"); return; } break; } } } #endregion // Insert data into Ugyfel class SqlCeCommand cmd; cmd = new SqlCeCommand("INSERT INTO Ugyfelek (ID,Kereszt_nev, Vezetek_nev, Cim, Telefon) VALUES (@Id,@Fname,@Lname, @Addres, @Phone)", Form1.con); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@Fname", Fname); cmd.Parameters.AddWithValue("@Lname", Lname); cmd.Parameters.AddWithValue("@Id", cusomer_id); cmd.Parameters.AddWithValue("@Phone", Phone); cmd.Parameters.AddWithValue("@Addres", Addres); // Check if the price is correct SqlCeCommand newcmd = new SqlCeCommand("SELECT *FROM Autok WHERE ID=@Car", Form1.con); newcmd.Parameters.AddWithValue("@Car", ID); SqlCeDataReader reader = newcmd.ExecuteReader(); while (reader.Read()) { price = (int)reader["Eladasi_ar"]; } if (Sum < price) { MessageBox.Show("The Price you typed is not enough!"); return; } else { // Update the Eladas Database with the customer personal data cmd.ExecuteNonQuery(); cmd = new SqlCeCommand("INSERT INTO Eladas (Auto_ID,Ugyfel_ID,Eladasi_datum,Fizetett) VALUES (@Car,@Customer,@Date,@Price)", Form1.con); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@Car", ID); cmd.Parameters.AddWithValue("@Customer", cusomer_id); cmd.Parameters.AddWithValue("@Date", DateTime.Now.ToShortDateString()); cmd.Parameters.AddWithValue("@Price", Sum); cmd.ExecuteNonQuery(); cmd = new SqlCeCommand("UPDATE Autok SET Allapot ='eladva' WHERE ID=@Id", Form1.con); cmd.Parameters.AddWithValue("@Id", ID); cmd.ExecuteNonQuery(); MessageBox.Show("Sold"); this.tabControl1.TabPages.Remove(currentTab); this.Close(); Buy form3 = new Buy(); form3.Show(); } }
private void button2_Click_1(object sender, EventArgs e) { //"Buy" menu Buy form3 = new Buy(); form3.Show(); }