public List <Objects.Attendance> FindAttendances(Int64 dateID)
{
IUnitOfWork unitOfWork = SessionFactory.GetUnitOfWork;
IRepository <Attendance> repository = new Repositor <Attendance>(unitOfWork);
try
{
return(repository.Find(k => k.AttendanceDateID == dateID).Select(c => new Objects.Attendance()
{
DateID = c.AttendanceDateID,
WorkerID = c.AttendanceWorkerID,
FirstName = c.Worker.WorkerFirstName,
LastName = c.Worker.WorkerLastName,
SapNumber = c.Worker.WorkerSapNumber,
WorkerStateID = c.AttendanceWorkerStateID,
WorkerState = c.WorkerState.WorkerStateName,
WorkerTourID = c.AttendanceWorkerTourID,
WorkerTour = c.Tour.TourStartTime.ToString("hh\\:mm") + " - " + c.Tour.TourEndTime.ToString("hh\\:mm"),
Description = c.AttendanceDescription
}).ToList());
}
catch (Exception e)
{
throw new FaultException <WcfException>(ExceptionProvider.CreateFaultContract(e));
}
}
public List <Objects.Changeover> FindChangeovers(Int32 detachmentID)
{
IUnitOfWork unitOfWork = SessionFactory.GetUnitOfWork;
IRepository <Changeover> repository = new Repositor <Changeover>(unitOfWork);
try
{
return(repository.Find(c => c.ChangeoverDetachmentID == detachmentID).Select(c => new Objects.Changeover()
{
ID = c.ChangeoverID,
DateID = c.ChangeoverDateID,
DateContent = c.Date.DateDate,
IsNight = c.Date.DateIsNight,
VehicleID = c.ChangeoverVehicleID,
VehicleNumber = c.Vehicle.VehicleNumber,
WorkTypeID = c.ChangeoverWorkTypeID,
WorkTypeName = c.WorkType.WorkTypeName,
Description = c.ChangeoverDescription,
DetachmentID = c.ChangeoverDetachmentID
}).ToList());
}
catch (Exception e)
{
throw new FaultException <WcfException>(ExceptionProvider.CreateFaultContract(e));
}
}
public Int64 AddDate(Objects.Date date)
{
IUnitOfWork unitOfWork = SessionFactory.GetUnitOfWork;
IRepository <Date> repository = new Repositor <Date>(unitOfWork);
try
{
ObjectValidator.IsValid(date);
Date d = new Date();
d.DateDate = date.DateContent;
d.DateIsNight = date.IsNight;
d.DateIsClosed = false;
d.DateDetachmentID = date.DetachmentID;
d.DateDescription = String.IsNullOrWhiteSpace(date.Description) ? null : date.Description;
unitOfWork.BeginTransaction();
var de = repository.Find(c => c.DateDate.Date >= date.DateContent.Date && c.DateDetachmentID == date.DetachmentID).ToList();
if (de != null)
{
if (de.Any(c => c.DateDate.Date > date.DateContent.Date) || de.Any(c => c.DateDate.Date == date.DateContent.Date && c.DateIsNight == true))
{
throw new FormatException("Není možné vytvářet směnu zpětně!");
}
}
repository.Add(d);
unitOfWork.CommitTransaction();
return(d.DateID);
}
catch (Exception e)
{
unitOfWork.RollbackTransaction();
throw new FaultException <WcfException>(ExceptionProvider.CreateFaultContract(e));
}
}
public List <string> GetTopCauseWorks(Int32 count, Int32 detachmentID)
{
IUnitOfWork unitOfWork = SessionFactory.GetUnitOfWork;
IRepository <Work> repository = new Repositor <Work>(unitOfWork);
try
{
return(repository.Find(c => c.Date.DateDetachmentID == detachmentID).
GroupBy(c => c.WorkCauseDescription).OrderByDescending(
c => c.Count()).Select(c => c.Key).Take(count).ToList());
}
catch (Exception e)
{
throw new FaultException <WcfException>(ExceptionProvider.CreateFaultContract(e));
}
}
public List <Objects.Vehicle> FindVehicles(Int32 detachmentID)
{
IUnitOfWork unitOfWork = SessionFactory.GetUnitOfWork;
IRepository <Vehicle> repository = new Repositor <Vehicle>(unitOfWork);
try
{
return(repository.Find(c => c.VehicleDetachmentID == detachmentID).Select(c => new Objects.Vehicle()
{
ID = c.VehicleID,
Number = c.VehicleNumber,
DetachmentID = c.VehicleDetachmentID,
Description = c.VehicleDescription
}).ToList());
}
catch (Exception e)
{
throw new FaultException <WcfException>(ExceptionProvider.CreateFaultContract(e));
}
}
public List <Objects.Tour> FindTours(Int32 detachmentID)
{
IUnitOfWork unitOfWork = SessionFactory.GetUnitOfWork;
IRepository <Tour> repository = new Repositor <Tour>(unitOfWork);
try
{
return(repository.Find(c => c.TourDetachmentID == detachmentID).Select(c => new Objects.Tour()
{
ID = c.TourID,
EndTime = c.TourEndTime,
StartTime = c.TourStartTime,
DetachmentID = c.TourDetachmentID,
Description = c.TourDescription
}).ToList());
}
catch (Exception e)
{
throw new FaultException <WcfException>(ExceptionProvider.CreateFaultContract(e));
}
}
public List <Objects.Worker> FindWorkers(Int32 detachmentID)
{
IUnitOfWork unitOfWork = SessionFactory.GetUnitOfWork;
IRepository <Worker> repository = new Repositor <Worker>(unitOfWork);
try
{
return(repository.Find(c => c.WorkerDetachmentID == detachmentID).Select(c => new Objects.Worker()
{
ID = c.WorkerID,
FirstName = c.WorkerFirstName,
LastName = c.WorkerLastName,
SapNumber = c.WorkerSapNumber,
ServicePhone = c.WorkerServicePhone,
DetachmentID = c.WorkerDetachmentID,
}).ToList());
}
catch (Exception e)
{
throw new FaultException <WcfException>(ExceptionProvider.CreateFaultContract(e));
}
}
public List <Objects.Date> FindDates(int year, int month, Int32 detachmentID)
{
IUnitOfWork unitOfWork = SessionFactory.GetUnitOfWork;
IRepository <Date> repository = new Repositor <Date>(unitOfWork);
try
{
return(repository.Find(c => c.DateDate.Year == year && c.DateDate.Month == month && c.DateDetachmentID == detachmentID).Select(c => new Objects.Date()
{
ID = c.DateID,
DateContent = c.DateDate,
IsClosed = c.DateIsClosed,
IsNight = c.DateIsNight,
DetachmentID = c.DateDetachmentID,
Description = c.DateDescription
}).OrderBy(c => c.DateContent).ToList());
}
catch (Exception e)
{
throw new FaultException <WcfException>(ExceptionProvider.CreateFaultContract(e));
}
}
public List <Objects.Work> FindWorks(Int64 dateID)
{
IUnitOfWork unitOfWork = SessionFactory.GetUnitOfWork;
IRepository <Work> repository = new Repositor <Work>(unitOfWork);
try
{
return(repository.Find(c => c.WorkDateID == dateID).Select(c => new Objects.Work()
{
ID = c.WorkID,
DateID = c.WorkDateID,
VehicleID = c.WorkVehicleID,
VehicleNumber = c.Vehicle.VehicleNumber,
WorkTypeID = c.WorkWorkTypeID,
WorkTypeName = c.WorkType.WorkTypeName,
FaultDescription = c.WorkFaultDescription,
CauseDescription = c.WorkCauseDescription
}).ToList());
}
catch (Exception e)
{
throw new FaultException <WcfException>(ExceptionProvider.CreateFaultContract(e));
}
}
