public Resrvation get_reservation(int id) { Resrvation r = (from res in resrvations where res.Id == id select res).FirstOrDefault(); return(r); }
public void save_location(int idv, string date_dd, string date_ff, int idc) { Resrvation r = new Resrvation() { Id = db.GetTable <Resrvation>().Count() + 1, Date_d = DateTime.Parse(date_dd), Date_f = DateTime.Parse(date_ff), Id_v = idv, Id_u = idc, Etat = "initiale" }; db.GetTable <Resrvation>().InsertOnSubmit(r); db.SubmitChanges(); }
public bool set_accepted(int id) { Resrvation r = (from user in resrvations where user.Id == id select user).FirstOrDefault(); r.Etat = "confirmee"; Voiture v = (from voi in voitures where voi.Id == r.Id_v select voi ).FirstOrDefault(); v.Joignable = "non"; db.SubmitChanges(); return(true); }
public bool terminer(int id) { Resrvation r = (from user in resrvations where user.Id == id select user).FirstOrDefault(); r.Etat = "terminee"; Voiture v = (from voi in voitures where voi.Id == r.Id_v select voi ).FirstOrDefault(); v.Joignable = "oui"; db.SubmitChanges(); return(true); }
public bool set_refused(int id) { Resrvation r = (from user in resrvations where user.Id == id select user).FirstOrDefault(); db.GetTable <Resrvation>().DeleteOnSubmit(r); Voiture v = (from voi in voitures where voi.Id == r.Id_v select voi ).FirstOrDefault(); v.Joignable = "oui"; db.SubmitChanges(); return(true); }