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