private void label1_Click(object sender, EventArgs e) { FlightList F = new FlightList(ps); F.FuncProfession("Manager"); F.Show(); this.Hide(); }
private void label1_Click(object sender, EventArgs e) { FlightList F2 = new FlightList(ps); F2.FuncProfession("Admin"); F2.Show(); this.Hide(); }
public Add(string FlName, string time, string Date, string Route, FlightList F) { if (FlName.Equals("") || time.Equals("") || Date.Equals("") || Route.Equals("")) { F.ErrorMassage("Fill all the entries correctly"); } else { FLIGHT = FlName; DTIME = time; DATE = Date; ROUTE = Route; } }
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"); }