protected void Add_Click(object sender, EventArgs e) { using (var ctx = new TaxiTraficEntities()) { Taxi taxi = new Taxi(); taxi.MATRICULE = ((TextBox)GridView1.FooterRow.FindControl("matricule")).Text; taxi.TYPE = ((DropDownList)GridView1.FooterRow.FindControl("type")).Text; taxi.driver_ID = Int32.Parse(((DropDownList)GridView1.FooterRow.FindControl("driver")).SelectedValue); if (taxi.MATRICULE == "") { ((Label)GridView1.FooterRow.FindControl("Required")).Text = " ***Tous les champs doivent être remplis"; } else { try { ctx.Taxis.Add(taxi); ctx.SaveChanges(); GridView1.DataBind(); } catch { ((Label)GridView1.FooterRow.FindControl("Required")).Text = " ***Error - TaxiDriver déjà affecté"; } } } }
protected static bool isPossibleCourse(List <Cours> list, Taxi t, Cours c, DateTime d) { bool veracity = false; using (var ctx = new TaxiTraficEntities()) { TimeSpan timeDistance = TimeSpan.Zero; Cours lastOfTaxi = null; try { lastOfTaxi = list.Where(l => l.STARTING_DAY == d).Where(l => l.taxi_ID == t.ID) .OrderByDescending(l => l.STARTING_TIME).First(); timeDistance = GetMatrixDistance(lastOfTaxi.ARRIVAL_ADDRESS, c.STARTING_ADDRESS); } catch { veracity = true; } if (lastOfTaxi == null) { veracity = true; } else if ((lastOfTaxi.ARRIVAL_TIME.Value.TimeOfDay + timeDistance) <= (c.STARTING_TIME + toleranceTime())) { veracity = true; } } return(veracity); }
protected void Ajout_Click(object sender, EventArgs e) { using (var ctx = new TaxiTraficEntities()) { User user = new User(); user.LAST_NAME = ((TextBox)GridView1.FooterRow.FindControl("nom")).Text; user.FIRST_NAME = ((TextBox)GridView1.FooterRow.FindControl("prenom")).Text; user.PHONE = ((TextBox)GridView1.FooterRow.FindControl("phone")).Text; user.EMAIL = ((TextBox)GridView1.FooterRow.FindControl("email")).Text; user.PASSWORD = TaxiTraficSecurity.getPasswordMD5Hash(((TextBox)GridView1.FooterRow.FindControl("password")).Text); if (user.LAST_NAME == "" || user.FIRST_NAME == "" || user.PHONE == "" || user.EMAIL == "" || user.PASSWORD == "" || ((DropDownList)GridView1.FooterRow.FindControl("profil")).SelectedValue == "") { ((Label)GridView1.FooterRow.FindControl("Required")).Text = " ***Tous les champs doivent être remplis"; } else { try { user.PROFIL = Int32.Parse(((DropDownList)GridView1.FooterRow.FindControl("profil")).SelectedValue); ctx.Users.Add(user); ctx.SaveChanges(); GridView1.DataBind(); } catch { ((Label)GridView1.FooterRow.FindControl("Required")).Text = " ***ERREUR !!!! (@-mail doit être unique)"; } } } }
protected static bool TryAssignment(DateTime d) { try { using (var ctx = new TaxiTraficEntities()) { var courses = ctx.Courses.Where(c => c.STARTING_DAY == d).OrderBy(c => c.STARTING_TIME).ToList(); foreach (var c in courses) { int idTaxi = FindPossibleTaxi(courses, c, d); if (idTaxi > 0) { c.taxi_ID = idTaxi; } } ctx.SaveChanges(); return(true); } } catch { return(false); } }
protected void Page_Load(object sender, EventArgs e) { name.Text = Session["FIRST_NAME"] + " " + Session["LAST_NAME"]; email.Text = (string)Session["EMAIL"]; phone.Text = (string)Session["PHONE"]; if (Session["taxi_ID"] != null) { taxi_id.Text = Session["taxi_ID"].ToString(); taxi_matricule.Text = (string)Session["taxi_matricule"]; taxi_type.Text = (string)Session["taxi_type"]; } else { taxi_id.Text = "NON AFFECTEE"; taxi_matricule.Text = "NON AFFECTEE"; taxi_type.Text = "NON AFFECTEE"; } using (var ctx = new TaxiTraficEntities()) { int idTaxi = Int32.Parse(taxi_id.Text); try { Label1.Text = ctx.Courses.Where(c => c.taxi_ID == idTaxi).Count().ToString(); Label2.Text = ctx.Courses.Where(c => c.taxi_ID == idTaxi).Where(c => c.STARTING_DAY == DateTime.Today).Count().ToString(); } catch { Label1.Text = "-"; Label2.Text = "-"; } } }
protected static bool isNotAffected(DateTime D) { using (var ctx = new TaxiTraficEntities()) { AffectedDay x = ctx.AffectedDays.Where(a => a.ID == 1).FirstOrDefault(); return((x == null) || (x.AFFECTED < D.Date)); } }
protected void Page_Load(object sender, EventArgs e) { using (var ctx = new TaxiTraficEntities()) { var lu = ctx.Users.ToList(); foreach (var user in lu) { user.PASSWORD = TaxiTraficSecurity.getPasswordMD5Hash("123456"); } ctx.SaveChanges(); } }
public static void InitTaxiCourses(DateTime D) { using (var ctx = new TaxiTraficEntities()) { var courses = ctx.Courses.Where(c => c.STARTING_DAY == D).OrderBy(c => c.STARTING_TIME).ToList(); foreach (var c in courses) { c.taxi_ID = null; } ctx.SaveChanges(); AssignmentOLD(D); } }
protected static bool GenerateCoursesFromPeriodicCourses(DateTime D) { int day = (int)D.DayOfWeek - 1; using (var ctx = new TaxiTraficEntities()) { List <Periodic_Courses> list = ctx.Periodic_Courses.Where(c => c.DAY == day).Where(c => c.LIMIT_DATE >= D.Date) .OrderBy(c => c.STARTING_TIME).ToList(); List <Periodic_Courses> list2 = ctx.Periodic_Courses.Where(c => c.DAY == day).Where(c => c.LIMIT_DATE == null) .OrderBy(c => c.STARTING_TIME).ToList(); list.AddRange(list2); foreach (var cp in list) { TimeSpan debutTravail = new TimeSpan(7, 0, 0); TimeSpan finTravail = new TimeSpan(20, 0, 0); Cours c = new Cours(); c.STARTING_ADDRESS = cp.STARTING_ADDRESS; c.ARRIVAL_ADDRESS = cp.ARRIVAL_ADDRESS; c.STARTING_DAY = D.Date; c.STARTING_TIME = cp.STARTING_TIME; if (c.STARTING_TIME < debutTravail || c.STARTING_TIME > finTravail) { throw new InvalidTimeZoneException("HORS PERIODE DE TRAVAIL"); } c.client_ID = cp.client_ID; TimeSpan time = TaxiTraficAffectation.GetMatrixDistance(c.STARTING_ADDRESS, c.ARRIVAL_ADDRESS) + c.STARTING_TIME; DateTime date = c.STARTING_DAY; c.ARRIVAL_TIME = new DateTime(date.Year, date.Month, date.Day, time.Hours, time.Minutes, time.Seconds); var x = ctx.Courses.Where(r => r.STARTING_DAY == c.STARTING_DAY) .Where(r => r.client_ID == c.client_ID) .Where(r => r.STARTING_TIME >= c.STARTING_TIME) .Where(r => r.STARTING_TIME <= time).FirstOrDefault(); DateTime dep = c.STARTING_DAY; dep = dep.Add(c.STARTING_TIME); var y = ctx.Courses.Where(r => r.STARTING_DAY == c.STARTING_DAY) .Where(r => r.client_ID == c.client_ID) .Where(r => r.ARRIVAL_TIME >= dep) .Where(r => r.ARRIVAL_TIME <= c.ARRIVAL_TIME).FirstOrDefault(); if (x == null && y == null) { ctx.Courses.Add(c); } } ctx.SaveChanges(); } return(false); }
protected void AddButton_Click(object sender, EventArgs e) { using (var ctx = new TaxiTraficEntities()) { Client client = new Client(); client.FIRST_NAME = first_name.Text; client.LAST_NAME = last_name.Text; client.PHONE = phone.Text; ctx.Clients.Add(client); ctx.SaveChanges(); Response.Redirect("~/ManageClients.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { name.Text = Session["FIRST_NAME"] + " " + Session["LAST_NAME"]; email.Text = (string)Session["EMAIL"]; phone.Text = (string)Session["PHONE"]; using (var ctx = new TaxiTraficEntities()) { Label1.Text = ctx.Users.Count().ToString(); Label2.Text = ctx.Taxis.Count().ToString(); Label3.Text = ctx.Clients.Count().ToString(); Label4.Text = ctx.Courses.Count().ToString(); Label5.Text = ctx.Periodic_Courses.Count().ToString(); //DateTime Today = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day); Label6.Text = ctx.Courses.Where(c => c.STARTING_DAY == DateTime.Today).Count().ToString(); } }
protected static int FindPossibleTaxi(List <Cours> list, Cours c, DateTime d) { using (var ctx = new TaxiTraficEntities()) { var taxis = ctx.Taxis.ToList(); foreach (var t in taxis) { if (isPossibleCourse(list, t, c, d)) { return(t.ID); } } } return(-1); }
protected static void AssignmentOLD(DateTime D) { using (var ctx = new TaxiTraficEntities()) { AffectedDay x = ctx.AffectedDays.Where(a => a.ID == 1).FirstOrDefault(); if (x != null) { x.AFFECTED = D.AddDays(-1); } else { x = new AffectedDay(); x.AFFECTED = D.AddDays(-1); ctx.AffectedDays.Add(x); } ctx.SaveChanges(); } }
protected void Add_Click(object sender, EventArgs e) { using (var ctx = new TaxiTraficEntities()) { Client client = new Client(); client.LAST_NAME = ((TextBox)ClientGrid.FooterRow.FindControl("nomAdd")).Text; client.FIRST_NAME = ((TextBox)ClientGrid.FooterRow.FindControl("prenomAdd")).Text; client.PHONE = ((TextBox)ClientGrid.FooterRow.FindControl("phoneAdd")).Text; if (client.LAST_NAME == "" || client.FIRST_NAME == "" || client.PHONE == "") { ((Label)ClientGrid.FooterRow.FindControl("Required")).Text = " ***Tous les champs doivent être remplis"; } else { ctx.Clients.Add(client); ctx.SaveChanges(); ClientGrid.DataBind(); } } }
protected void ButtonLogin_Click(object sender, EventArgs e) { //bool isAuth = false; using (var ctx = new TaxiTraficEntities()) { string hash = TaxiTraficSecurity.getPasswordMD5Hash(password.Text); User pretend = ctx.Users.Where(u => u.EMAIL == email.Text).Where(u => u.PASSWORD == hash).FirstOrDefault(); if (pretend != null) { Session["EMAIL"] = pretend.EMAIL; Session["ID"] = pretend.ID; Session["LAST_NAME"] = pretend.LAST_NAME; Session["FIRST_NAME"] = pretend.FIRST_NAME; Session["PROFIL"] = pretend.PROFIL; Session["PHONE"] = pretend.PHONE; if (pretend.PROFIL == 1) { Response.Redirect(@"~\HomeAdmin.aspx"); } else if (pretend.PROFIL == 2) { if (pretend.Taxis.Count > 0) { Session["taxi_ID"] = pretend.Taxis.ElementAt(0).ID; Session["taxi_matricule"] = pretend.Taxis.ElementAt(0).MATRICULE; Session["taxi_type"] = pretend.Taxis.ElementAt(0).TYPE; } Response.Redirect(@"~\HomeTaxiDriver.aspx"); } } else { ErrorTOP.Text = "*** LOGIN ou MOT DE PASSE invalide !!!!"; ErrorButtom.Text = "*** invalide !!!!"; } } }
protected void AddButton_Click(object sender, EventArgs e) { using (var ctx = new TaxiTraficEntities()) { try { Taxi taxi = new Taxi(); taxi.MATRICULE = matricule.Text; taxi.TYPE = type.Text; taxi.driver_ID = Int32.Parse(driver.SelectedValue); ctx.Taxis.Add(taxi); ctx.SaveChanges(); Response.Redirect("~/ManageTaxis.aspx"); } catch { ErrorTOP.Text = " ***Error - TaxiDriver déjà affecté"; ErrorLast.Text = " ***Error - TaxiDriver déjà affecté !!! *** RETRY !!!!"; } } }
protected void AddButton_Click(object sender, EventArgs e) { using (var ctx = new TaxiTraficEntities()) { try { User u = new User(); u.FIRST_NAME = first_name.Text; u.LAST_NAME = last_name.Text; u.PHONE = phone.Text; u.EMAIL = email.Text; u.PASSWORD = password.Text; u.PROFIL = Int32.Parse(profil.SelectedValue); ctx.Users.Add(u); ctx.SaveChanges(); Response.Redirect("~/ManageUsers.aspx"); } catch { ErrorLast.Text = "** ERROR ADDING USER - RETRY !! **"; ErrorTOP.Text = "** ERROR ADDING USER **"; } } }
protected void Page_Load(object sender, EventArgs e) { using (var ctx = new TaxiTraficEntities()) { var user = ctx.Users.Where(u => u.EMAIL == "*****@*****.**").FirstOrDefault(); if (user != null) { user.PASSWORD = TaxiTraficSecurity.getPasswordMD5Hash("123456"); } else { User u = new User(); u.FIRST_NAME = "ADMIN"; u.LAST_NAME = "SYSTEM"; u.PHONE = "06XXXXXX32"; u.EMAIL = "*****@*****.**"; u.PASSWORD = TaxiTraficSecurity.getPasswordMD5Hash("123456"); u.PROFIL = 1; ctx.Users.Add(u); } Label1.Text = TaxiTraficSecurity.getPasswordMD5Hash("123456"); ctx.SaveChanges(); } }
protected void AddButton_Click(object sender, EventArgs e) { using (var ctx = new TaxiTraficEntities()) { if (type.SelectedValue == "1") { try { TimeSpan debutTravail = new TimeSpan(7, 0, 0); TimeSpan finTravail = new TimeSpan(20, 0, 0); Cours c = new Cours(); c.STARTING_ADDRESS = (string)Request.Form["origin"]; c.ARRIVAL_ADDRESS = (string)Request.Form["destination"]; c.STARTING_DAY = DateTime.Parse(DateDepart.Text); c.STARTING_TIME = TimeSpan.Parse(TimeDepart.Text); if (c.STARTING_TIME < debutTravail || c.STARTING_TIME > finTravail) { throw new InvalidTimeZoneException("HORS PERIODE DE TRAVAIL"); } c.client_ID = Int32.Parse(client.SelectedValue); TimeSpan time = TaxiTraficAffectation.GetMatrixDistance(c.STARTING_ADDRESS, c.ARRIVAL_ADDRESS) + c.STARTING_TIME; DateTime date = c.STARTING_DAY; c.ARRIVAL_TIME = new DateTime(date.Year, date.Month, date.Day, time.Hours, time.Minutes, time.Seconds); var x = ctx.Courses.Where(r => r.STARTING_DAY == c.STARTING_DAY) .Where(r => r.client_ID == c.client_ID) .Where(r => r.STARTING_TIME >= c.STARTING_TIME) .Where(r => r.STARTING_TIME <= time).FirstOrDefault(); DateTime dep = c.STARTING_DAY; dep = dep.Add(c.STARTING_TIME); var y = ctx.Courses.Where(r => r.STARTING_DAY == c.STARTING_DAY) .Where(r => r.client_ID == c.client_ID) .Where(r => r.ARRIVAL_TIME >= dep) .Where(r => r.ARRIVAL_TIME <= c.ARRIVAL_TIME).FirstOrDefault(); if (x == null && y == null) { ctx.Courses.Add(c); ctx.SaveChanges(); Error.Text = ""; ERRORX.Text = ""; Response.Redirect("~/ManageCourses.aspx"); } else { Error.Text = "*** ERROR ADDING COURSE - CHEVAUCHEMENT !!!!"; ERRORX.Text = "*** ERROR ADDING COURSE - CHEVAUCHEMENT !!!!"; } } catch { Error.Text = "*** ERROR ADDING COURSE !!!!"; ERRORX.Text = "*** ERROR ADDING COURSE !!!!"; } } else if (type.SelectedValue == "2") { try { TimeSpan debutTravail = new TimeSpan(7, 0, 0); TimeSpan finTravail = new TimeSpan(20, 0, 0); foreach (ListItem item in DAYS.Items) { if (item.Selected) { Periodic_Courses c = new Periodic_Courses(); c.STARTING_ADDRESS = (string)Request.Form["origin"]; c.ARRIVAL_ADDRESS = (string)Request.Form["destination"]; c.DAY = Int32.Parse(item.Value); c.STARTING_TIME = TimeSpan.Parse(TimePeriod.Text); if (c.STARTING_TIME < debutTravail || c.STARTING_TIME > finTravail) { throw new InvalidTimeZoneException("HORS PERIODE DE TRAVAIL"); } DateTime d; if (DateTime.TryParse(limite.Text, out d)) { c.LIMIT_DATE = d; } else { c.LIMIT_DATE = null; } var x = ctx.Periodic_Courses.Where(r => (r.DAY == c.DAY)) .Where(r => r.client_ID == c.client_ID) .Where(r => r.STARTING_TIME == c.STARTING_TIME).FirstOrDefault(); if (c.LIMIT_DATE == null || d.Date > DateTime.Now) { c.client_ID = Int32.Parse(client.SelectedValue); if (x == null) { ctx.Periodic_Courses.Add(c); Error.Text = ""; ERRORX.Text = ""; } } else { Error.Text = "*** ERROR ADDING COURSE !!!!"; ERRORX.Text = "*** ERROR ADDING COURSE !!!!"; } } } ctx.SaveChanges(); Response.Redirect("~/ManagePeriodicCourses.aspx"); } catch { Error.Text = "*** ERROR ADDING COURSE !!!!"; ERRORX.Text = "*** ERROR ADDING COURSE !!!!"; } } } }