public static TravelReporting GetTravelReporting(TravelReportingDTO dtoTravelReporting)
{
TravelReporting travelReporting = new TravelReporting()
{
IdTravelingDriver = dtoTravelReporting.IdTravelingDriver,
Date = dtoTravelReporting.Date,
NumPassengers = dtoTravelReporting.NumPassengers,
NumComplainants = dtoTravelReporting.NumComplainants,
IsPay = dtoTravelReporting.IsPay
};
return(travelReporting);
}
public static TravelReportingDTO GetTravelReportingDTO(TravelReporting travelReporting)
{
if (travelReporting == null)
{
return(null);
}
TravelReportingDTO dtoTravelReporting = new TravelReportingDTO()
{
IdTravelingDriver = travelReporting.IdTravelingDriver,
Date = travelReporting.Date,
NumPassengers = travelReporting.NumPassengers,
NumComplainants = travelReporting.NumComplainants,
IsPay = travelReporting.IsPay
};
return(dtoTravelReporting);
}
public static void AddTravelReport(int travelingId, DateTime date)
{
try
{
using (Travel_In_GroupDBEntities ctx = new Travel_In_GroupDBEntities())
{
var travelDate = ctx.TravelDriverRanges.FirstOrDefault(t => t.Id == travelingId && t.Date.Date == date.Date);
var travel = ctx.TravelingDrivers.FirstOrDefault(t => t.TravelingIdDriver == travelingId);
int numPassenger = travel.NumSeats - travelDate.NumSeatsAvailable;
TravelReporting travelReporting = new TravelReporting()
{
IdTravelingDriver = travelingId,
Date = date,
NumPassengers = numPassenger,
NumComplainants = 0,
IsPay = false
};
ctx.TravelReportings.Add(travelReporting);
ctx.SaveChanges();
}
}
catch { throw; }
}