private void Button_Click(object sender, RoutedEventArgs e)
{
Button b = sender as Button;
if (b.Name == "btnRemove")
{
//Look for the row in the database, in order to remove it.
if ((dg.SelectedItem as ScheduleSlot).idTimeSlot != 0)
{
int tsId = (dg.SelectedItem as ScheduleSlot).idTimeSlot;
ScheduleSlot sl = (from r in bdModel.ScheduleSlots where r.idTimeSlot == tsId select r).SingleOrDefault();
bdModel.ScheduleSlots.Remove(sl);
bdModel.SaveChanges();
dg.ItemsSource = bdModel.ScheduleSlots.ToList();
}
}
else if (b.Name == "btnUpdate")
{
int tsId = (dg.SelectedItem as ScheduleSlot).idTimeSlot;
ScheduleSlot s1 = (from r in bdModel.ScheduleSlots where r.idTimeSlot == tsId select r).SingleOrDefault();
ScheduleSlot tmp = s1;
AddPlotWindow apw = new AddPlotWindow(tmp, bdModel);
//bd.ScheduleSlots.Remove(s1);
apw.ShowDialog();
bdModel.SaveChanges();
dg.ItemsSource = bdModel.ScheduleSlots.ToList();
}
}
/// <summary>
/// Save to the database the slots showed in the scheduler.
/// </summary>
private void btnSlotScheduleGeneration_Click(object sender, RoutedEventArgs e)
{
//Create a ScheduleSlot foreach event in the scheduler
foreach (Event ev in slotGenerationScheduler.Events)
{
if (ev.IdShift == 0) //it's a new slot
{
bdModel.AbsencePreferences.Add(new AbsencePreference()
{
dayOfWeek = ev.DayOfWeek,
firstDay = ev.FirstDay,
lastDate = ev.LastDay,
startHour = new TimeSpan(ev.Start.Hour, ev.Start.Minute, 0),
endHour = new TimeSpan(ev.End.Hour, ev.End.Minute, 0),
idPerson = ((Person)(cbxPeople.SelectedItem)).idPerson
});
}
else //otherwise update it
{
AbsencePreference ss = bdModel.AbsencePreferences.Single(s => s.idTimeSlot == ev.IdShift);
ss.dayOfWeek = ev.DayOfWeek;
ss.lastDate = ev.LastDay;
ss.firstDay = ev.FirstDay;
ss.startHour = new TimeSpan(ev.Start.Hour, ev.Start.Minute, 0);
ss.endHour = new TimeSpan(ev.End.Hour, ev.End.Minute, 0);
}
}
bdModel.SaveChanges();
MessageBox.Show("Traitement terminé", "Plages horaires sauvegardées dans la BD");
LoadScheduleSlotFromDatabase();
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
if (!modify)
{
current = new Person();
current.password = pwdPassword.Password;
}
else if (pwdPassword.Password != null)
{
current.password = pwdPassword.Password;
}
current.firstName = txtFirstname.Text;
current.name = txtName.Text;
current.numberAVS = txtAvs.Text;
current.occupancyRate = float.Parse(txtOccupencyrate.Text);
current.idRole = (int)cbxRole.SelectedValue;
current.description = txtDescription.Text;
if (!modify)
{
bdModel.People.Add(current);
}
bdModel.SaveChanges();
this.Close();
}
// <summary>
/// Insert data in the database
/// if the record is already existing, it will update it
/// if the record isnt existing, it will create it and add it
/// </summary>
/// <param>None</param>
private void btnSave_Click(object sender, RoutedEventArgs e)
{
if (isDateChecked() && areDatesCorrect())
{
current.dayOfWeek = cbxDayOfWeek.SelectedIndex;
current.startHour = new TimeSpan(Int32.Parse(cbxStartHourHour.Text), Int32.Parse(cbxStartHourMinute.Text), 0);
current.endHour = new TimeSpan(Int32.Parse(cbxEndHourHour.Text), Int32.Parse(cbxEndHourMinute.Text), 0);
current.minAttendency = Int32.Parse(cbxAttendency.Text);
current.firstDay = (DateTime)dpFirstDay.SelectedDate;
current.lastDay = (DateTime)dpLastDay.SelectedDate;
if (!modified)
{
bdModel.ScheduleSlots.Add(current);
}
bdModel.SaveChanges();
this.Close();
}
else
{
MessageBox.Show("Veuillez remplir les champs \"Premier jour\" et \"Dernier Jour\"" +
"\n" + " et vérifier que le premier jour soit avant ou égal au dernier jour");
}
}
/// <summary>
/// Save in the database the workingshfits
/// </summary>
/// <param name="wsList">List of WorkingShift</param>
/// <param name="bd">database</param>
public static void PersistWorkingShiftDataBase(List <WorkingShift> wsList, bd_easyplannerEntities bd)
{
foreach (WorkingShift ws in wsList)
{
bd.WorkingShifts.Add(ws);
}
bd.SaveChanges();
}
private void button_Click(object sender, RoutedEventArgs e)
{
workingShift = new WorkingShift();
workingShift.start = DateTime.Now;
workingShift.end = null;
workingShift.description = "Test Plinio Sacchetti";
workingShift.idPerson = 1;
bd.WorkingShifts.Add(workingShift);
bd.SaveChanges();
}
/// <summary>
/// Remove from database the workingshifts listed in the paramater.
/// (if the workingShif id is in the list then it is removed)
/// </summary>
/// <param name="wsList">List of WorkingShift to remove</param>
/// <param name="bd">database</param>
public static void RemoveWorkingShiftDataBase(List <WorkingShift> wsList, bd_easyplannerEntities bd)
{
WorkingShift wsRemove = null;
foreach (WorkingShift ws in wsList)
{
wsRemove = bd.WorkingShifts.Find(ws.idShift);
if (wsRemove != null)
{
bd.WorkingShifts.Remove(wsRemove);
}
}
bd.SaveChanges();
}
/// <summary>
/// Save to the database the slots showed in the scheduler.
/// </summary>
private void btnSlotScheduleGeneration_Click(object sender, RoutedEventArgs e)
{
//Create a ScheduleSlot foreach event in the scheduler
foreach (Event ev in slotGenerationScheduler.Events)
{
if (ev.IdShift == 0) //it's a new slot
{
bdModel.ScheduleSlots.Add(new ScheduleSlot()
{
dayOfWeek = ev.DayOfWeek,
firstDay = ev.FirstDay,
lastDay = ev.LastDay,
minAttendency = ev.MinAttendency,
startHour = new TimeSpan(ev.Start.Hour, ev.Start.Minute, 0),
endHour = new TimeSpan(ev.End.Hour, ev.End.Minute, 0),
});
}
else if (ev.Color.ToString() == Colors.Red.ToString()) //if the color is red, then remove it from the database
{
ScheduleSlot ss = bdModel.ScheduleSlots.Single(s => s.idTimeSlot == ev.IdShift);
bdModel.ScheduleSlots.Remove(ss);
}
else //otherwise update it
{
ScheduleSlot ss = bdModel.ScheduleSlots.Single(s => s.idTimeSlot == ev.IdShift);
ss.dayOfWeek = ev.DayOfWeek;
ss.lastDay = ev.LastDay;
ss.firstDay = ev.FirstDay;
ss.minAttendency = ev.MinAttendency;
ss.startHour = new TimeSpan(ev.Start.Hour, ev.Start.Minute, 0);
ss.endHour = new TimeSpan(ev.End.Hour, ev.End.Minute, 0);
}
}
bdModel.SaveChanges();
MessageBox.Show("Traitement terminé", "Plages horaires sauvegardées dans la BD");
this.Close();
}
private void btnDelete_Click(object sender, RoutedEventArgs e)
{
bdModel.People.Remove((Person)dgPeople.SelectedItem);
bdModel.SaveChanges();
dgPeople.ItemsSource = bdModel.People.ToList();
}