public string Delete(int id)
{
SessionFactory sessionsFactory = new SessionFactory();
SessionsTable <Session> instance = (SessionsTable <Session>)sessionsFactory.GetSessionInstance();
var list = Request.Headers.ToList();
var token = list.Where(a => a.Key == "token")?.FirstOrDefault().Value.FirstOrDefault()?.Replace("\"", string.Empty);
if (token == null)
{
return("NOT LOGED");
}
var dispatcher = instance.SelectDispatcherSession(token);
var driver = instance.SelectDriverSession(token);
var manager = instance.SelectManagerSession(token);
if (dispatcher == null && driver == null && manager == null)
{
return("NOT EXISTING USER");
}
MessageFactory messageFactory = new MessageFactory();
MessageTable <Message> instanceMessage = (MessageTable <Message>)messageFactory.GetMessageInstance();
instanceMessage.Delete(id);
return("OK");
}
public string Post([FromBody] Message obj)
{
SessionFactory sessionsFactory = new SessionFactory();
SessionsTable <Session> instance = (SessionsTable <Session>)sessionsFactory.GetSessionInstance();
var list = Request.Headers.ToList();
var token = list.Where(a => a.Key == "token")?.FirstOrDefault().Value.FirstOrDefault()?.Replace("\"", string.Empty);
if (token == null)
{
return("NOT LOGED");
}
var dispatcher = instance.SelectDispatcherSession(token);
var driver = instance.SelectDriverSession(token);
var manager = instance.SelectManagerSession(token);
if (dispatcher == null && driver == null && manager == null)
{
return("NOT EXISTING USER");
}
else if (obj == null)
{
return("NO OBJECT");
}
obj.dispatcher = new Dopravio.Models.Dispatcher();
obj.dispatcher.id = dispatcher.id;
MessageFactory messageFactory = new MessageFactory();
MessageTable <Message> instanceMessage = (MessageTable <Message>)messageFactory.GetMessageInstance();
instanceMessage.Insert(obj);
return("OK");
}
public string Post([FromBody] Vehicle obj)
{
SessionFactory sessionsFactory = new SessionFactory();
SessionsTable <Session> instance = (SessionsTable <Session>)sessionsFactory.GetSessionInstance();
var list = Request.Headers.ToList();
var token = list.Where(a => a.Key == "token")?.FirstOrDefault().Value.FirstOrDefault()?.Replace("\"", string.Empty);
if (token == null)
{
return("NOT LOGED");
}
var dispatcher = instance.SelectDispatcherSession(token);
var driver = instance.SelectDriverSession(token);
var manager = instance.SelectManagerSession(token);
if (dispatcher == null && driver == null && manager == null)
{
return("NOT EXISTING USER");
}
else if (obj == null)
{
return("NO OBJECT");
}
VehicleFactory vehicleFactory = new VehicleFactory();
var instanceVehicle = vehicleFactory.GetVehicleInstance();
instanceVehicle.Insert(obj);
return("OK");
}
public string Put(int id, [FromBody] Timetable timetable)
{
SessionFactory sessionFactory = new SessionFactory();
SessionsTable <Session> instanceSession = (SessionsTable <Session>)sessionFactory.GetSessionInstance();
TimetableFactory timetableFactory = new TimetableFactory();
TimetableTable <Timetable> instanceTimetable = (TimetableTable <Timetable>)timetableFactory.GetTimetableInstance();
var list = Request.Headers.ToList();
var token = list.Where(a => a.Key == "token")?.FirstOrDefault().Value.FirstOrDefault()?.Replace("\"", string.Empty);
if (token == null)
{
return("NOT LOGED");
}
var dispatcher = instanceSession.SelectDispatcherSession(token);
var driver = instanceSession.SelectDriverSession(token);
var manager = instanceSession.SelectManagerSession(token);
if (dispatcher == null && driver == null && manager == null)
{
return("NOT EXISTING USER");
}
else if (timetable == null)
{
return("NO OBJECT");
}
instanceTimetable.Update(timetable);
return("OK");
}
public string Put(int id, [FromBody] Request obj)
{
SessionFactory sessionsFactory = new SessionFactory();
SessionsTable <Session> instance = (SessionsTable <Session>)sessionsFactory.GetSessionInstance();
var list = Request.Headers.ToList();
var token = list.Where(a => a.Key == "token")?.FirstOrDefault().Value.FirstOrDefault()?.Replace("\"", string.Empty);
if (token == null)
{
return("NOT LOGED");
}
var dispatcher = instance.SelectDispatcherSession(token);
var driver = instance.SelectDriverSession(token);
var manager = instance.SelectManagerSession(token);
if (dispatcher == null && driver == null && manager == null)
{
return("NOT EXISTING USER");
}
else if (obj == null)
{
return("NO OBJECT");
}
RequestFactory requestFactory = new RequestFactory();
RequestTable <Request> instanceRequest = (RequestTable <Request>)requestFactory.GetRequestInstance();
instanceRequest.Update(obj);
return("OK");
}
public string Post([FromBody] Failure obj)
{
SessionFactory sessionsFactory = new SessionFactory();
SessionsTable <Session> instance = (SessionsTable <Session>)sessionsFactory.GetSessionInstance();
var list = Request.Headers.ToList();
var token = list.Where(a => a.Key == "token")?.FirstOrDefault().Value.FirstOrDefault()?.Replace("\"", string.Empty);
if (token == null)
{
return("NOT LOGED");
}
var driver = instance.SelectDriverSession(token);
if (driver == null)
{
return("NOT EXISTING USER");
}
else if (obj == null)
{
return("NO OBJECT");
}
FailureFactory failureFactory = new FailureFactory();
FailureTable <Failure> instanceFailure = (FailureTable <Failure>)failureFactory.GetFailureInstance();
instanceFailure.Insert(obj);
return("OK");
}
public Overview Get()
{
SessionFactory sessionsFactory = new SessionFactory();
SessionsTable <Session> instance = (SessionsTable <Session>)sessionsFactory.GetSessionInstance();
var list = Request.Headers.ToList();
var token = list.Where(a => a.Key == "token")?.FirstOrDefault().Value.FirstOrDefault()?.Replace("\"", string.Empty);
if (token == null)
{
return(new Overview());
}
var dispatcher = instance.SelectDispatcherSession(token);
var driver = instance.SelectDriverSession(token);
var manager = instance.SelectManagerSession(token);
if (dispatcher == null && driver == null && manager == null)
{
return(new Overview());
}
Overview obj = new Overview();
RequestFactory requestFactory = new RequestFactory();
RequestTable <Request> instanceRequest = (RequestTable <Request>)requestFactory.GetRequestInstance();
var requests = instanceRequest.Select();
obj.acceptedRequests = requests.Where(r => r.state == RequestState.ACCEPTED).Count();
obj.declinedRequests = requests.Where(r => r.state == RequestState.DECLINED).Count();
obj.newRequests = requests.Where(r => r.state == RequestState.NEW).Count();
decimal salary = 0;
DriverFactory driverFactory = new DriverFactory();
DriverTable <Driver> instanceDriver = (DriverTable <Driver>)driverFactory.GetDriverInstance();
var listDrivers = instanceDriver.Select();
obj.driverCount = listDrivers.Count();
salary += listDrivers.Sum(dr => dr.salary);
DispatcherFactory dispatcherFactory = new DispatcherFactory();
DispatcherTable <Dispatcher> instanceDispatcher = (DispatcherTable <Dispatcher>)dispatcherFactory.GetDispatcherInstance();
var listDispatchers = instanceDispatcher.Select();
obj.dispatcherCount = listDispatchers.Count();
salary += listDispatchers.Sum(dis => dis.salary);
obj.monthSalary = salary;
VehicleFactory vehicleFactory = new VehicleFactory();
var instanceVehicle = vehicleFactory.GetVehicleInstance();
obj.vehicleCount = instanceVehicle.Select().Count();
FailureFactory failureFactory = new FailureFactory();
FailureTable <Failure> instanceFailure = (FailureTable <Failure>)failureFactory.GetFailureInstance();
var listFailures = instanceFailure.Select();
DateTime lastMonth = DateTime.Now.AddMonths(-1);
obj.failurestInLastMonth = listFailures.Where(d => d.created > lastMonth).Count();
obj.failures = listFailures.Count();
return(obj);
}
