public void UpdateManager(int id, string name, string pass, string email, string contNo, int sal, ManagerList MO) { MydbDataContext cntx = new MydbDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Oyan Computer\Desktop\Project\Project\Forms\Mydb.mdf;Integrated Security=True"); var str = from a in cntx.Managers where a.Id == id select a; Manager M = str.First(); M.Id = id; M.UserName = name; M.Password = pass; M.Email = email; M.ContactNo = contNo; // M.Salary = sal; M.Salary = sal; cntx.SubmitChanges(); name = M.UserName; pass = M.Password; email = M.Email; contNo = M.ContactNo; sal = Convert.ToInt32(M.Salary); cntx.SubmitChanges(); }
private void button2_Click(object sender, EventArgs e) { MydbDataContext cntx = new MydbDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Oyan Computer\Desktop\Project\Project\Forms\Mydb.mdf;Integrated Security=True"); var str = from a in cntx.Booking_Histories where a.No == int.Parse(textBox1.Text) select a; // Person p = new Person(); Booking_History B = str.First(); if (B != null) { cntx.Booking_Histories.DeleteOnSubmit(B); MessageBox.Show("Data Deleted"); cntx.SubmitChanges(); } else { MessageBox.Show("Data not found"); } BookingGetData(ps); }
public void SignUp(string fName, string mName, string lName, string uName, string pass, string aPass, string email, string gender, string address, string dOB, SignUp a) { MydbDataContext cntx = new MydbDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\USER\Desktop\Project\Project\Forms\Mydb.mdf;Integrated Security=True"); Person p = new Person(); People po = new People(); cntx.Persons.InsertOnSubmit(p); cntx.Peoples.InsertOnSubmit(po); p.FirstName = fName; p.MiddleName = mName; p.LastName = lName; p.UserName = uName; p.Password = pass; p.Email = email; p.Gender = gender; p.Address = address; p.BirthDate = dOB; po.UserName = uName; po.password = pass; po.UserType = "Customer"; cntx.SubmitChanges(); // cntx.SubmitChanges(); cntx.Dispose(); new SignUp().ErrorMassage("successfully signed up"); }
public void NewManager(string name, string pass, string email, string contNo, int sal, ManagerList M) { MydbDataContext cntx = new MydbDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\USER\Desktop\Project\Project\Forms\Mydb.mdf;Integrated Security=True"); Manager Man = new Manager(); People P = new People(); cntx.Managers.InsertOnSubmit(Man); cntx.Peoples.InsertOnSubmit(P); Man.UserName = name; Man.Password = pass; Man.Email = email; Man.ContactNo = contNo; Man.Salary = sal; P.UserName = name; P.password = pass; P.UserType = "Manager"; cntx.SubmitChanges(); new ManagerList().ErrorMassage("Successfully added"); cntx.Dispose(); }
public void NewEmployee(string ename, string contact, string email, string role, float esalary, int workingHour, string offday, Employee_List E) { MydbDataContext cntx = new MydbDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Oyan Computer\Desktop\Project\Project\Forms\Mydb.mdf;Integrated Security=True"); Employee em = new Employee(); cntx.Employees.InsertOnSubmit(em); em.Name = ename; em.Email = email; em.Role = role; em.Salary = esalary; em.WorkingHour = workingHour; em.OffDay = offday; }
public void GetManagerData(int id, string name, string pass, string email, string contNo, float sal, ManagerList MO) { MydbDataContext cntx = new MydbDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Oyan Computer\Desktop\Project\Project\Forms\Mydb.mdf;Integrated Security=True"); var str = from a in cntx.Managers where a.Id == id select a; // dataGridView1.DataSource = str; }
/* public void SearchManager(int ab,string name, string pass, string email, string contNo, int sal,AdminOperation A, ManagerList MO) { * * * /* foreach (var x in list) * { * productName = x.Item_name; * quantity = x.Quantity.ToString(); * categoryName = x.Category.Category_name; * price = x.Unit_price.ToString(); * details = x.Item_description; * sellerId = x.Seller_id.ToString(); * sellerName = x.Customer.Customer_name; * phn = x.Customer.Phone_number; * email = x.Customer.Email; * country = x.Customer.Addresses.Country.Country_name; * * } * * //Manager mo = str.First(); * foreach (var a in str) * { * // ab = a.Id; * name = a.UserName; * pass = a.Password; * email = a.Email; * contNo = a.ContactNo; * sal = a.Salary; * * } * * * * cnt.SubmitChanges(); * * }*/ public void DeleteManager(int id, string name, string pass, string email, string contNo, float sal, ManagerList MO) { MydbDataContext cntx = new MydbDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Oyan Computer\Desktop\Project\Project\Forms\Mydb.mdf;Integrated Security=True"); var str = from a in cntx.Managers where a.Id == id select a; Manager M = str.First(); cntx.Managers.DeleteOnSubmit(M); cntx.SubmitChanges(); }
public void DeleteFlight(int Fno, string flight, string dtime, string ddate, string route, FlightList F) { MydbDataContext cntx = new MydbDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Oyan Computer\Desktop\Project\Project\Forms\Mydb.mdf;Integrated Security=True"); var str = from a in cntx.Flights where a.Flight_No == Fno select a; Flight fl = str.First(); cntx.Flights.DeleteOnSubmit(fl); cntx.SubmitChanges(); cntx.Dispose(); }
/* public void DataLogin(string User, string password,int b,Add add,Login l) { * * MydbDataContext cntx = new MydbDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Oyan Computer\Desktop\Project\Project\Forms\Mydb.mdf;Integrated Security=True"); * * * b = l.a; * * * * * * if (b == 0) * { * var str = from a2 in cntx.Admins * where a2.UserName == User * * select a2; * * Admin A = str.First(); * * add.UNAME = A.UserName; * add.PASS = A.Password; * * } * * * if (b == 1) * { * var str = from a2 in cntx.Managers * where a2.UserName == User * * select a2; * * Manager M = str.First(); * * add.UNAME = M.UserName; * add.PASS = M.Password; * * } * * if (b == 2) * { * var str = from a2 in cntx.Persons * where a2.UserName == User * * select a2; * * Person p = str.First(); * * add.UNAME = p.UserName; * add.PASS = p.Password; * add.FNAME = p.FirstName; * add.MNAME = p.MiddleName; * add.LNAME = p.LastName; * add.DOB = p.BirthDate; * add.ADDRESS = p.Address; * * add.EMAIL = p.Email; * add.GENDER = p.Gender; * add.ID = p.Id; * * * //foreach(string k in flightlist) * var st = from a3 in cntx.Flights * * select new { Flightlist =a3 }; * * * * } * * * cntx.Dispose(); * * } * * */ public void AddFlight(string flight, string dtime, string ddate, string route, FlightList F) { MydbDataContext cntx = new MydbDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Oyan Computer\Desktop\Project\Project\Forms\Mydb.mdf;Integrated Security=True"); Flight fl = new Flight(); cntx.Flights.InsertOnSubmit(fl); fl.Flight_Name = flight; fl.Departure_Time = dtime; fl.Departure_Date = ddate; // fl.Route = route; cntx.Dispose(); // new ManagerList().ErrorMassage("New Flight Added"); }
private void button1_Click(object sender, EventArgs e) { MydbDataContext cntx = new MydbDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Oyan Computer\Desktop\Project\Project\Forms\Mydb.mdf;Integrated Security=True"); var str = from a in cntx.Flights where a.Flight_Name == textBox2.Text select a; Flight F = str.First(); var st = from b in cntx.Persons where b.UserName == textBox3.Text select b; Person P = st.First(); Booking_History B = new Booking_History(); if (F != null && P != null) { B.CustomerName = textBox2.Text; B.FlightName = textBox3.Text; B.No_Of_Orders = int.Parse(textBox4.Text); B.Cost_Per_Order_ = int.Parse(textBox5.Text); B.Total_Cost = int.Parse(textBox6.Text); cntx.Booking_Histories.InsertOnSubmit(B); cntx.SubmitChanges(); MessageBox.Show("Successfully inserted"); } else { MessageBox.Show("Data not found"); } BookingGetData(ps); }