public Employee(Dictionary <string, string> dictionary)
{
DictonaryAdapter dictionaryAdapter = new DictonaryAdapter(dictionary);
//Person
Id = int.Parse(dictionaryAdapter.GetValue("persons_id"));
Name = dictionaryAdapter.GetValue("name");
Password = dictionaryAdapter.GetValue("password");
Phone = int.Parse(dictionaryAdapter.GetValue("phone"));
Mail = dictionaryAdapter.GetValue("mail");
// Notifications =;//Ainda e preciso ver como sera
//Role
IdEmployee = int.Parse(dictionaryAdapter.GetValue("employees_id"));
Salary = double.Parse(dictionaryAdapter.GetValue("salary"));
}
public IList <Schedule> GetSchedules()
{
// Time now
DateTime date = new DateTime();
var day = date.Day;
var month = date.Month;
var year = date.Year;
// Schedules
var properties = new [] { "*" };
var table = new [] { "schedules" };
var schedulesSQL = SqlOperations.Instance.Select(properties, table);
var schedules = DBConnection.Instance.Query(schedulesSQL);
List <Schedule> schedulesList = new List <Schedule>();
foreach (var schedule in schedules)
{
var scheduleAdapter = new DictonaryAdapter(schedule);
var startDateValue = scheduleAdapter.GetValue("firstDay");
var lastDateValue = scheduleAdapter.GetValue("lastDay");
var startDayMonthYear = startDateValue.Split('-');
var endDayMonthYear = lastDateValue.Split('-');
if (month.ToString().Equals(startDayMonthYear[1]) && year.ToString().Equals(endDayMonthYear[1]))
{
if (day.ToString().Equals(startDayMonthYear[0]) || day.ToString().Equals(endDayMonthYear[0]))
{
var selectedSchedule = new Schedule(schedule);
schedulesList.Add(selectedSchedule);
}
else if (day > int.Parse(startDayMonthYear[0]) && day < int.Parse(endDayMonthYear[0]))
{
var selectedSchedule = new Schedule(schedule);
schedulesList.Add(selectedSchedule);
}
}
}
if (schedulesList.Count == 0)
{
return(null);
}
else
{
return(schedulesList);
}
}
public IList <Room> GetAvailableRooms(Schedule schedule)
{
var roomsAvailable = new List <Room>();
var desiredStartDayMonthYear = schedule.FirstDay.Split('-');
var desiredEndDayMonthYear = schedule.LastDay.Split('-');
var desiredStartTime = schedule.StartTime.Split(':');
var desiredEndTime = schedule.EndTime.Split(':');
//Adiciona as salas vazias que nao possuem eventos
var properties = new [] { "*" };
var table = new [] { "rooms" };
var keys = new [] { "events_id" };
var values = new [] { "null" };
var Rooms = SqlOperations.Instance.Select(properties, table, keys, values);
var roomsList = DBConnection.Instance.Query(Rooms);
foreach (var room in roomsList)
{
var availableRoom = new Room(room);
roomsAvailable.Add(availableRoom);
}
table[0] = "temporaries";
var temporarySQL = SqlOperations.Instance.Select(properties, table);
var temporaryEventsDictionary = DBConnection.Instance.Query(temporarySQL);
foreach (var temporaryEvent in temporaryEventsDictionary)
{
var adapter = new DictonaryAdapter(temporaryEvent);
properties = new [] { "*" };
table = new [] { "schedule" };
keys = new [] { "id" };
values = new [] { adapter.GetValue("schedules_id") };
var specificScheduleSQL = SqlOperations.Instance.Select(properties, table, keys, values);
var schedules = DBConnection.Instance.Query(specificScheduleSQL);
var available = true;
foreach (var individualSchedule in schedules)
{
var scheduleAdapter = new DictonaryAdapter(individualSchedule);
var startDateValue = scheduleAdapter.GetValue("firstDay");
var lastDateValue = scheduleAdapter.GetValue("lastDay");
var startTime = scheduleAdapter.GetValue("startTime");
var endTime = scheduleAdapter.GetValue("endTime");
var startHourMin = startTime.Split(':');
var endHourMin = endTime.Split(':');
var startDayMonthYear = startDateValue.Split('-');
var endDayMonthYear = lastDateValue.Split('-');
if (startDayMonthYear[1].Equals(desiredStartDayMonthYear[1]) &&
endDayMonthYear[1].Equals(desiredEndDayMonthYear[1]))
{
if (int.Parse(startDayMonthYear[0]) > int.Parse(desiredStartDayMonthYear[0]))
{
if (int.Parse(startDayMonthYear[0]) < int.Parse(desiredEndDayMonthYear[0]))
{
}
else if (int.Parse(startDayMonthYear[0]) > int.Parse(desiredEndDayMonthYear[0]))
{
available = false;
break;
}
else if (int.Parse(startDayMonthYear[0]) == int.Parse(desiredEndDayMonthYear[0]))
{
if (!CheckTimeConflict(desiredStartTime, desiredEndTime, startHourMin, endHourMin))
{
available = false;
break;
}
}
}
else if (int.Parse(startDayMonthYear[0]) < int.Parse(desiredStartDayMonthYear[0]))
{
if (int.Parse(startDayMonthYear[0]) < int.Parse(desiredEndDayMonthYear[0]))
{
}
else if (int.Parse(endDayMonthYear[0]) > int.Parse(desiredStartDayMonthYear[0]))
{
available = false;
break;
}
else if (int.Parse(endDayMonthYear[0]) == int.Parse(desiredStartDayMonthYear[0]))
{
if (!CheckTimeConflict(desiredStartTime, desiredEndTime, startHourMin, endHourMin))
{
available = false;
break;
}
}
}
else if (int.Parse(endDayMonthYear[0]) == int.Parse(desiredStartDayMonthYear[0]))
{
if (!CheckTimeConflict(desiredStartTime, desiredEndTime, startHourMin, endHourMin))
{
available = false;
break;
}
}
else
{
available = false;
break;
}
}
else if (endDayMonthYear[1].Equals(desiredStartDayMonthYear[1]))
{
if (int.Parse(endDayMonthYear[0]) < int.Parse(desiredStartDayMonthYear[0]))
{
}
else if (int.Parse(endDayMonthYear[0]) > int.Parse(desiredStartDayMonthYear[0]))
{
available = false;
break;
}
else if (int.Parse(endDayMonthYear[0]) == int.Parse(desiredStartDayMonthYear[0]))
{
if (!CheckTimeConflict(desiredStartTime, desiredEndTime, startHourMin, endHourMin))
{
available = false;
break;
}
}
}
else if (startDayMonthYear[1].Equals(desiredEndDayMonthYear[1]))
{
if (int.Parse(desiredEndDayMonthYear[1]) < int.Parse(startDayMonthYear[1]))
{
}
else if (int.Parse(desiredEndDayMonthYear[1]) > int.Parse(startDayMonthYear[1]))
{
available = false;
break;
}
else if (int.Parse(endDayMonthYear[0]) == int.Parse(desiredStartDayMonthYear[1]))
{
if (!CheckTimeConflict(desiredStartTime, desiredEndTime, startHourMin, endHourMin))
{
available = false;
break;
}
}
}
}
if (!available)
{
AddRoomAvailable(adapter.GetValue("events_id"), roomsAvailable);
}
}
return(roomsAvailable);
}