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 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;
}
