private void button2_Click(object sender, EventArgs e) { MydatabaseDataContext admin = new MydatabaseDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\lenovo\Documents\Visual Studio 2012\Projects\car\car\login.mdf;Integrated Security=True"); int lg = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value.ToString()); var query = admin.Logins.Where(w => w.Id == lg).FirstOrDefault(); admin.Logins.DeleteOnSubmit(query); admin.SubmitChanges(); dataGridView1.DataSource = admin.Logins; }
private void button2_Click(object sender, EventArgs e) { MydatabaseDataContext sr = new MydatabaseDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\lenovo\Documents\Visual Studio 2012\Projects\car\car\login.mdf;Integrated Security=True"); int s = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value.ToString()); var query = sr.Sales_Reports.Where(x => x.Serial_Number == s).FirstOrDefault(); sr.Sales_Reports.DeleteOnSubmit(query); sr.SubmitChanges(); dataGridView1.DataSource = sr.Sales_Reports; }
private void button1_Click(object sender, EventArgs e) { MydatabaseDataContext admin = new MydatabaseDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\lenovo\Documents\Visual Studio 2012\Projects\car\car\login.mdf;Integrated Security=True"); Login lg = new Login(); lg.Password = textBox1.Text; lg.Position = textBox2.Text; admin.Logins.InsertOnSubmit(lg); admin.SubmitChanges(); dataGridView1.DataSource = admin.Logins; }
private void button2_Click(object sender, EventArgs e) { MydatabaseDataContext pl = new MydatabaseDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\lenovo\Documents\Visual Studio 2012\Projects\car\car\login.mdf;Integrated Security=True"); int psn = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value.ToString()); var query = pl.Price_Lists.Where(x => x.Serial_Number == psn).FirstOrDefault(); query.Type_of_Vehicle = textBox1.Text; query.Model = textBox2.Text; query.Price = int.Parse(textBox3.Text); pl.SubmitChanges(); dataGridView1.DataSource = pl.Price_Lists; }
private void button1_Click(object sender, EventArgs e) { MydatabaseDataContext pl = new MydatabaseDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\lenovo\Documents\Visual Studio 2012\Projects\car\car\login.mdf;Integrated Security=True"); Price_List p = new Price_List(); p.Type_of_Vehicle = textBox1.Text; p.Model = textBox2.Text; p.Price = int.Parse(textBox3.Text); pl.Price_Lists.InsertOnSubmit(p); pl.SubmitChanges(); dataGridView1.DataSource = pl.Price_Lists; }
private void button3_Click(object sender, EventArgs e) { MydatabaseDataContext sr = new MydatabaseDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\lenovo\Documents\Visual Studio 2012\Projects\car\car\login.mdf;Integrated Security=True"); int s = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value.ToString()); var query = sr.Sales_Registers.Where(x => x.Serial_Number == s).FirstOrDefault(); query.Date = Convert.ToDateTime(textBox1.Text); query.Type_of_Vehicle = textBox2.Text; query.Model = textBox3.Text; query.Sales_Unit = int.Parse(textBox4.Text); query.Sales_Amount = textBox5.Text; sr.SubmitChanges(); dataGridView1.DataSource = sr.Sales_Registers; }
private void button1_Click(object sender, EventArgs e) { MydatabaseDataContext sr = new MydatabaseDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\lenovo\Documents\Visual Studio 2012\Projects\car\car\login.mdf;Integrated Security=True"); Sales_Register st = new Sales_Register(); st.Date = Convert.ToDateTime(textBox1.Text); st.Type_of_Vehicle = textBox2.Text; st.Model = textBox3.Text; st.Sales_Unit = int.Parse(textBox4.Text); st.Sales_Amount = textBox5.Text; sr.Sales_Registers.InsertOnSubmit(st); sr.SubmitChanges(); dataGridView1.DataSource = sr.Sales_Registers; }
private void button1_Click(object sender, EventArgs e) { MydatabaseDataContext sr = new MydatabaseDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\lenovo\Documents\Visual Studio 2012\Projects\car\car\login.mdf;Integrated Security=True"); Stock_Register s = new Stock_Register(); s.Date = Convert.ToDateTime(textBox1.Text); s.Type_of_Car = textBox2.Text; s.Model = textBox3.Text; s.Total_Num = int.Parse(textBox4.Text); s.Sales_Number = int.Parse(textBox5.Text); s.Current_Stock = int.Parse(textBox6.Text); sr.Stock_Registers.InsertOnSubmit(s); sr.SubmitChanges(); dataGridView1.DataSource = sr.Stock_Registers; }
private void button3_Click(object sender, EventArgs e) { MydatabaseDataContext emp = new MydatabaseDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\lenovo\Documents\Visual Studio 2012\Projects\car\car\login.mdf;Integrated Security=True"); int empl = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value.ToString()); var query = emp.Employee_lists.Where(w => w.Id == empl).FirstOrDefault(); query.Name = textBox1.Text; query.Address = richTextBox1.Text; query.Email = textBox2.Text; query.Phone_No_ = int.Parse(textBox3.Text); query.Position = textBox4.Text; query.Password = textBox5.Text; emp.SubmitChanges(); dataGridView1.DataSource = emp.Employee_lists; }
private void button1_Click(object sender, EventArgs e) { MydatabaseDataContext emp = new MydatabaseDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\lenovo\Documents\Visual Studio 2012\Projects\car\car\login.mdf;Integrated Security=True"); Employee_list em = new Employee_list(); em.Name = textBox1.Text; em.Address = richTextBox1.Text; em.Email = textBox2.Text; em.Phone_No_ = int.Parse(textBox3.Text); em.Position = textBox4.Text; em.Password = textBox5.Text; emp.Employee_lists.InsertOnSubmit(em); emp.SubmitChanges(); dataGridView1.DataSource = emp.Employee_lists; }
private void button1_Click(object sender, EventArgs e) { MydatabaseDataContext lg = new MydatabaseDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\lenovo\Documents\Visual Studio 2012\Projects\car\car\login.mdf;Integrated Security=True"); Login l = new Login(); var query = from login in lg.Logins where login.Id == int.Parse(textBox1.Text) && login.Password == textBox2.Text && login.Position == comboBox1.SelectedItem.ToString() select login; Employee_list el = new Employee_list(); var query2 = from Employee_list in lg.Employee_lists where Employee_list.Id == int.Parse(textBox1.Text) && Employee_list.Password == textBox2.Text && Employee_list.Position == comboBox1.SelectedItem.ToString() select Employee_list; if (query.Any()) { if (comboBox1.Text == "Super Admin") { SuperAdmin obj = new SuperAdmin(); this.Hide(); obj.Show(); } else if (comboBox1.Text == "Admin") { AdminPanel obj = new AdminPanel(); //obj.button2.Hide(); this.Hide(); obj.Show(); } } else if (query2.Any()) { SalesReport obj = new SalesReport(); obj.sadminbutton.Hide(); this.Hide(); obj.Show(); } else { MessageBox.Show("Sorry! Your id or password or position is incorrect.Try again"); } }
private void button3_Click(object sender, EventArgs e) { MydatabaseDataContext sr = new MydatabaseDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\lenovo\Documents\Visual Studio 2012\Projects\car\car\login.mdf;Integrated Security=True"); int s = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value.ToString()); var query = sr.Sales_Reports.Where(x => x.Serial_Number == s).FirstOrDefault(); query.Type_of_Vehicle = textBox2.Text; query.Model = textBox3.Text; query.Custoer_Name = textBox4.Text; query.Customer_Address = richTextBox1.Text; query.Customer_Phone_Number = int.Parse(textBox5.Text); query.Sales_Vlue = int.Parse(textBox6.Text); query.Money_Receipt_Number = textBox7.Text; query.Delivery_Number = textBox8.Text; query.Body_Number = textBox9.Text; query.Engine_Number = textBox10.Text; query.Employee_Id = int.Parse(textBox11.Text); sr.SubmitChanges(); dataGridView1.DataSource = sr.Sales_Reports; }
private void button1_Click(object sender, EventArgs e) { MydatabaseDataContext sr = new MydatabaseDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\lenovo\Documents\Visual Studio 2012\Projects\car\car\login.mdf;Integrated Security=True"); Sales_Report s = new Sales_Report(); s.Date = Convert.ToDateTime(textBox1.Text); s.Type_of_Vehicle = textBox2.Text; s.Model = textBox3.Text; s.Custoer_Name = textBox4.Text; s.Customer_Address = richTextBox1.Text; s.Customer_Phone_Number = int.Parse(textBox5.Text); s.Sales_Vlue = int.Parse(textBox6.Text); s.Money_Receipt_Number = textBox7.Text; s.Delivery_Number = textBox8.Text; s.Body_Number = textBox9.Text; s.Engine_Number = textBox10.Text; s.Employee_Id = int.Parse(textBox11.Text); sr.Sales_Reports.InsertOnSubmit(s); sr.SubmitChanges(); dataGridView1.DataSource = sr.Sales_Reports; }
private void SalesReport_Load(object sender, EventArgs e) { MydatabaseDataContext sr = new MydatabaseDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\lenovo\Documents\Visual Studio 2012\Projects\car\car\login.mdf;Integrated Security=True"); dataGridView1.DataSource = sr.Sales_Reports; }
private void VehicleInventory_Load(object sender, EventArgs e) { MydatabaseDataContext str = new MydatabaseDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\lenovo\Documents\Visual Studio 2012\Projects\car\car\login.mdf;Integrated Security=True"); dataGridView1.DataSource = str.Stock_Registers; }
private void Employeepro_Load(object sender, EventArgs e) { MydatabaseDataContext emp = new MydatabaseDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\lenovo\Documents\Visual Studio 2012\Projects\car\car\login.mdf;Integrated Security=True"); dataGridView1.DataSource = emp.Employee_lists; }