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