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 orderInformation_Load(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"); dataGridView1.DataSource = c.OrderTables; textBox1.Hide(); }
private void Customer_Load(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"); dataGridView1.DataSource = c.CustomerTables; textBox1.Hide(); dataGridView1.Columns[7].Visible = false; }
private void Customer_product_Load(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"); dataGridView1.DataSource = c.VehicleInfos; textBox2.Hide(); textBox3.Hide(); }
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs 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"); if (e.RowIndex >= 0) { DataGridViewRow dr = this.dataGridView1.Rows[e.RowIndex]; textBox2.Text = dr.Cells["Id"].Value.ToString(); try { textBox1.Text = dr.Cells["Car_Brand"].Value.ToString(); } catch (Exception ex) { catcombo.Text = ""; } try { catcombo.Text = dr.Cells["Category"].Value.ToString(); } catch (Exception ex) { catcombo.Text = ""; } try { textBox4.Text = dr.Cells["Car_Model"].Value.ToString(); } catch (Exception ex) { catcombo.Text = ""; } try { textBox5.Text = dr.Cells["Quantity"].Value.ToString(); } catch (Exception ex) { catcombo.Text = ""; } try { textBox6.Text = dr.Cells["Price"].Value.ToString(); } catch (Exception ex) { catcombo.Text = ""; } try { textBox7.Text = dr.Cells["Color"].Value.ToString(); } catch (Exception ex) { catcombo.Text = ""; } } }
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs 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"); if (e.RowIndex >= 0) { DataGridViewRow dr = this.dataGridView1.Rows[e.RowIndex]; textBox1.Text = dr.Cells["Customer_Id"].Value.ToString(); } }
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 button6_Click_1(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.CustomerTables where a.First_Name == search.Text select a; try { search.Text = x.First().First_Name.ToString(); } catch (Exception ex) { MessageBox.Show("Not found. Try again"); } dataGridView1.DataSource = x.ToList(); }
private void button6_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.Car_Brand == textBox1.Text select a; try { textBox5.Text = x.First().Quantity.ToString(); } catch (Exception ex) { MessageBox.Show("Not found. Try again"); } dataGridView1.DataSource = x.ToList(); }
private void login_Click(object sender, EventArgs e) { string uname = username.Text; string pass = password.Text; CarDataContext c = new CarDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\adi\Documents\New folder\csms.mdf;Integrated Security=True;Connect Timeout=30"); if (uname == "" || pass == "") { MessageBox.Show("Provide Your Username and Password"); } else { var i = (from a in c.RegistationTables where a.Username == uname && a.Password == pass select a); if (i.Any()) { if (uname == "admin" && pass == "admin") { Home h = new Home(); h.Show(); Visible = false; } else { ClientView cv = new ClientView(); OrderInfo co = new OrderInfo(); cv.textBox3.Text = uname; cv.Show(); Visible = false; } } else { MessageBox.Show("Invalid Username or Password "); } } }
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"); } }
public void GridViewUpdate() { CarDataContext c = new CarDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\adi\Documents\New folder\csms.mdf;Integrated Security=True;Connect Timeout=30"); dataGridView1.DataSource = c.CustomerTables; }
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."); } }