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); }