public int GetIncomeBoatRentalsByWeekAndBoat(int week, int id)
{
DateTimeFormatInfo dfi = DateTimeFormatInfo.CurrentInfo;
Calendar calendar = dfi.Calendar;
var linqQuery = from row in dbc.BoatRentals where row.FKRentedBoat.BoatId.Equals(id) select row;
List <BoatRentalsEntity> BoatRentalsList = linqQuery.ToList();
int RentalCount = 0;
int Income = 0;
for (int i = 0; i < BoatRentalsList.Count; i++)
{
if (calendar.GetWeekOfYear(BoatRentalsList[i].StartingDate, dfi.CalendarWeekRule, DayOfWeek.Monday)
.Equals(week))
{
List <BoatRentalsEntity> BoatRentalsList2 = linqQuery.ToList();
BoatsDaoImpl boatsDaoImpl = new BoatsDaoImpl();
BoatsEntity boatsEntity = boatsDaoImpl.GetBoatsById(id);
for (int g = 0; g < BoatRentalsList2.Count; g++)
{
Income += (BoatRentalsList[i].EndDate - BoatRentalsList[i].StartingDate).Days *
Convert.ToInt32(boatsEntity.DailyPrice);
}
}
}
return(Income);
}
public int GetIncomeBoatRentalsByMonthAndBoat(int month, int id)
{
var linqQuery = from row in dbc.BoatRentals
where (row.StartingDate.Month.Equals(month) & row.FKRentedBoat.BoatId.Equals(id))
select row;
List <BoatRentalsEntity> BoatRentalsList = linqQuery.ToList();
BoatsDaoImpl boatsDaoImpl = new BoatsDaoImpl();
BoatsEntity boatsEntity = boatsDaoImpl.GetBoatsById(id);
int Income = 0;
for (int i = 0; i < BoatRentalsList.Count; i++)
{
Income += (BoatRentalsList[i].EndDate - BoatRentalsList[i].StartingDate).Days *
Convert.ToInt32(boatsEntity.DailyPrice);
}
return(Income);
}
