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 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 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 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 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 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 !!!!"; } } } }