private void button2_Click(object sender, EventArgs e) { CarDataContext c = new CarDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\adi\Documents\New folder\csms.mdf;Integrated Security=True;Connect Timeout=30"); try { VehicleInfo ct = new VehicleInfo { Category = catcombo.SelectedItem.ToString(), Car_Brand = textBox1.Text, Car_Model = textBox4.Text, Color = textBox7.Text, Quantity = int.Parse(textBox5.Text), Price = int.Parse(textBox6.Text) }; c.VehicleInfos.InsertOnSubmit(ct); c.SubmitChanges(); GridViewUpdate(); MessageBox.Show("vehicle added"); } catch (Exception ex) { MessageBox.Show("Add failed. Please try again"); } }
private void button1_Click(object sender, EventArgs e) { var x = from a in c.OrderTables where a.Order_Id == int.Parse(textBox1.Text) select a; foreach (OrderTable vi in x) { c.OrderTables.DeleteOnSubmit(vi); } c.SubmitChanges(); GridViewUpdate(); }
private void button4_Click(object sender, EventArgs e) { CarDataContext c = new CarDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\adi\Documents\New folder\csms.mdf;Integrated Security=True;Connect Timeout=30"); var x = from a in c.VehicleInfos where a.Id == int.Parse(textBox2.Text) select a; foreach (VehicleInfo vi in x) { c.VehicleInfos.DeleteOnSubmit(vi); } c.SubmitChanges(); GridViewUpdate(); }
private void button4_Click(object sender, EventArgs e) { try { var x = from a in c.CustomerTables where a.Customer_Id == int.Parse(textBox1.Text.ToString()) select a; foreach (CustomerTable b in x) { c.CustomerTables.DeleteOnSubmit(b); } c.SubmitChanges(); MessageBox.Show(" Deleted"); GridViewUpdate(); } catch { MessageBox.Show("Failed to Delete"); } }
private void button3_Click_1(object sender, EventArgs e) { try { CarDataContext c = new CarDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\adi\Documents\New folder\csms.mdf;Integrated Security=True;Connect Timeout=30"); var x = from a in c.VehicleInfos where a.Id == int.Parse(textBox2.Text.ToString()) select a; x.First().Category = catcombo.SelectedItem.ToString(); x.First().Quantity = int.Parse(textBox5.Text.ToString()); x.First().Car_Model = textBox4.Text; x.First().Price = float.Parse(textBox6.Text.ToString()); x.First().Car_Brand = textBox1.Text; x.First().Color = textBox7.Text; c.SubmitChanges(); GridViewUpdate(); MessageBox.Show("Updated"); } catch { MessageBox.Show("failed"); } }
private void button2_Click(object sender, EventArgs e) { try { OrderTable ot = new OrderTable { Vehicle_Id = int.Parse(textBox4.Text), Customer_Id = textBox1.Text, Catagory = textBox9.Text, Brand_Name = textBox8.Text, Car_Model = textBox2.Text, Order_Quantity = int.Parse(textBox5.Text), Price = int.Parse(textBox6.Text), Color = textBox7.Text, Order_Date = dateTimePicker1.Text }; c.OrderTables.InsertOnSubmit(ot); c.SubmitChanges(); GridViewUpdate(); var x = from a in c.VehicleInfos where a.Id == int.Parse(textBox4.Text.ToString()) select a; int oq = int.Parse(textBox5.Text.ToString()); int vq; int rslt; vq = x.First().Quantity; if ((vq > 0) && (oq < vq)) { rslt = vq - oq; x.First().Quantity = rslt; c.SubmitChanges(); GridViewUpdate(); MessageBox.Show("Your order has been placed in queue. Please be with us untill we contact with you"); } else { var z = from a in c.OrderTables where a.Customer_Id == textBox1.Text select a; foreach (OrderTable vi in z) { c.OrderTables.DeleteOnSubmit(vi); } c.SubmitChanges(); GridViewUpdate(); MessageBox.Show(oq + " cars is not available right now"); } } catch (Exception ex) { if (textBox5.Text == "" && textBox8.Text != "") { MessageBox.Show("Please provide order quantity"); } else { MessageBox.Show("Please provide all the information correctly"); } } }
private void button1_Click(object sender, EventArgs e) { CarDataContext c = new CarDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\adi\Documents\New folder\csms.mdf;Integrated Security=True;Connect Timeout=30"); try { RegistationTable rt = new RegistationTable { First_Name = textBox1.Text, Last_Name = textBox2.Text, Gender = gcombo.SelectedItem.ToString(), phone = textBox4.Text, Email = textBox5.Text, Address = textBox6.Text, Username = textBox7.Text, Password = textBox8.Text }; CustomerTable cta = new CustomerTable { First_Name = textBox1.Text, Last_Name = textBox2.Text, Email = textBox5.Text, Phone = textBox4.Text }; try { if (textBox1.Text == "") { MessageBox.Show("Provide Your First Name"); } else if (textBox2.Text == "") { MessageBox.Show("Provide Your Last Name"); } else if (textBox4.Text == "") { MessageBox.Show("Phone Number can't be empty"); } else if (!textBox4.Text.StartsWith("016") && !textBox4.Text.StartsWith("017")) { MessageBox.Show("Provide a valid phone number "); } else if (textBox4.Text.Length < 11) { MessageBox.Show("Provide a 11 digit valid phone number"); } else if (textBox5.Text == "") { MessageBox.Show("Provide your email address"); } else if (textBox7.Text == "") { MessageBox.Show("Provide your username"); } else if (textBox8.Text == "") { MessageBox.Show("Provide a password"); } else if (textBox7.Text != "") { var j = (from a in c.RegistationTables where a.Username == textBox7.Text select a); if (textBox7.Text == j.First().Username) { MessageBox.Show("username is not available. provide anything new"); } } } catch (Exception ex) { c.RegistationTables.InsertOnSubmit(rt); c.CustomerTables.InsertOnSubmit(cta); c.SubmitChanges(); MessageBox.Show("Registration Succesfull"); this.Hide(); LoginPage f1 = new LoginPage(); f1.Show(); } } catch (Exception ex) { MessageBox.Show("Registration failed. Please provide all the information correctly."); } }