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