// GET: OverViewController
public ActionResult OverviewDay(int id)
{
DateTimeFormatInfo dfi = DateTimeFormatInfo.CurrentInfo;
Calendar cal = dfi.Calendar;
var date = DateTime.Now;
var datum = date.ToString("yyyy-MM-dd");
var day = date.ToString("dddd");
ViewBag.Dagens = datum;
ViewBag.Veckodag = day;
var week = cal.GetWeekOfYear(date, dfi.CalendarWeekRule, dfi.FirstDayOfWeek);
ViewBag.vecka = week;
var viewModel = new UnitResViewModel();
var resource = _context.Resources.FirstOrDefault(r => r.ResId == id);
viewModel.Resource = resource;
var unit = _context.Units.FirstOrDefault(u => u.UnitId == resource.UnitId);
viewModel.Unit = unit;
ViewBag.EnhetsAdress = unit.Address;
List <string> weekdays = new List <string> {
"må", "ti", "on", "to", "fr", "lö", "sö"
};
ViewBag.WeekDays = weekdays;
return(View(viewModel));
}
//public IActionResult Overview()
//{
// var viewModel = new UnitResViewModel();
// var unit = _context.Units.ToList();
// IEnumerable<Unit> units = unit;
// viewModel.UnitsList = units;
// return View(viewModel);
//}
public IActionResult Search()
{
var viewModel = new UnitResViewModel();
var unit = _context.Units.ToList();
IEnumerable <Unit> units = unit;
viewModel.UnitsList = units;
return(View(viewModel));
}
public ActionResult Overview(int?id, string datePicker)
{
var datum = string.Empty;
var date = DateTime.Now;
if (datePicker != null)
{
datum = datePicker;
date = Convert.ToDateTime(datum);
}
else
{
datum = date.ToString("yyyy-MM-dd");
}
DateTimeFormatInfo dfi = DateTimeFormatInfo.CurrentInfo;
Calendar cal = dfi.Calendar;
var day = date.ToString("dddd");
ViewBag.Dagens = datum;
ViewBag.Veckodag = day;
ViewBag.yearWeeks = Dates.LastWeekOfYear(date);
var week = cal.GetWeekOfYear(date, dfi.CalendarWeekRule, dfi.FirstDayOfWeek);
ViewBag.vecka = week;
DateTime dt = date.StartOfWeek(DayOfWeek.Monday);
DateTime dt7 = dt.AddDays(7);
List <string> datesForward = new List <string>();
foreach (DateTime loopDay in dt.EachDay(dt7))
{
datesForward.Add(loopDay.ToString("yyyy-MM-dd"));
}
ViewBag.ForwardDates = datesForward;
/* Filtrerar ut bokningar baserat på nuvarande vecka */
List <Booking> bookings = _context.Bookings.Where(b => b.StartTime > dt && b.StopTime < dt7).ToList();
var viewModel = new UnitResViewModel();
/* Filtrerar ut bokningar baserat på nuvarande vecka */
//var filteredBookings = from booking in bookings
// where cal.GetWeekOfYear(booking.StartDate, dfi.CalendarWeekRule, dfi.FirstDayOfWeek) == week
// select booking;
//viewModel.BookingList = filteredBookings;
viewModel.BookingList = bookings;
var resource = _context.Resources.OrderBy(u => u.UnitId).ToList();
IEnumerable <Resource> resources = resource;
viewModel.ResourcesList = resources;
var unit = _context.Units.ToList();
IEnumerable <Unit> filteredUnits = null;
IEnumerable <Unit> units = unit;
if (id != null && id != 0)
{
filteredUnits = unit.Where(u => u.UnitId == id);
}
else
{
filteredUnits = unit;
}
//IEnumerable<Unit> units = unit;
viewModel.FilteredUnitsList = filteredUnits;
viewModel.UnitsList = units;
IEnumerable <Resource> filteredResources = null;
if (id != null && id != 0)
{
filteredResources = resource.Where(r => r.UnitId == id);
}
else
{
filteredResources = resources;
}
viewModel.FilteredResourceList = filteredResources;
List <string> weekdays = new List <string> {
"må", "ti", "on", "to", "fr", "lö", "sö"
};
ViewBag.WeekDays = weekdays;
return(View(viewModel));
}
//("yyyy’-‘MM’-‘dd’");
// GET: OverViewController
public ActionResult OverviewResource(int id, string datePicker)
{
var datum = string.Empty;
var date = DateTime.Now;
if (datePicker != null)
{
datum = datePicker;
date = Convert.ToDateTime(datum);
}
else
{
datum = date.ToString("yyyy-MM-dd");
}
DateTimeFormatInfo dfi = DateTimeFormatInfo.CurrentInfo;
Calendar cal = dfi.Calendar;
datum = date.ToString("yyyy-MM-dd");
var day = date.ToString("dddd");
//var year = cal.GetYear(date);
//DateTime lastDate = new DateTime(year, 12, 31);
//var lastWeek = cal.GetWeekOfYear(lastDate, dfi.CalendarWeekRule,
// dfi.FirstDayOfWeek);
//List<int> weeksOfYear = new List<int>();
//for (int i = 1; i <= lastWeek; i++)
//{
// weeksOfYear.Add(cal.GetWeekOfYear(date.AddDays(i * 7), dfi.CalendarWeekRule, dfi.FirstDayOfWeek));
//}
//ViewBag.yearWeeks = weeksOfYear;
ViewBag.yearWeeks = Dates.LastWeekOfYear(date);
ViewBag.Dagens = datum;
ViewBag.Veckodag = day;
var week = cal.GetWeekOfYear(date, dfi.CalendarWeekRule, dfi.FirstDayOfWeek);
// Get date for monday in this week
DateTime dt = DateTime.Now.StartOfWeek(DayOfWeek.Monday);
DateTime dt210 = dt.AddDays(30 * 7);
List <string> datesForward = new List <string>();
foreach (DateTime loopDay in dt.EachDay(dt210))
{
datesForward.Add(loopDay.ToString("yyyy-MM-dd"));
}
ViewBag.ForwardDates = datesForward;
//List<int> weeks = new List<int>();
//for(int i=0; i < 30; i++)
//{
// weeks.Add(cal.GetWeekOfYear(date.AddDays(i * 7), dfi.CalendarWeekRule, dfi.FirstDayOfWeek));
//}
DateTime date30w = date.AddDays(30 * 7);
var week30 = cal.GetWeekOfYear(date30w, dfi.CalendarWeekRule, dfi.FirstDayOfWeek);
ViewBag.vecka = week;
ViewBag.vecka30 = week30;
//ViewBag.veckor30 = weeks;
ViewBag.veckor30 = Dates.Get30Weeks(date);
var viewModel = new UnitResViewModel();
var resource = _context.Resources.FirstOrDefault(r => r.ResId == id);
viewModel.Resource = resource;
var unit = _context.Units.FirstOrDefault(u => u.UnitId == resource.UnitId);
viewModel.Unit = unit;
ViewBag.EnhetsAdress = unit.Address;
List <string> weekdays = new List <string> {
"må", "ti", "on", "to", "fr", "lö", "sö"
};
ViewBag.WeekDays = weekdays;
/* Behöver ändras till att inte läsa in alla bokningar */
//var bookings = _context.Bookings.ToList();
//viewModel.BookingList = bookings;
/* Filtrerar ut bokningar baserat på 30 veckor och resurs. */
List <Booking> bookings = _context.Bookings.Where(b => b.ResourceId == id && b.StartTime > dt && b.StopTime < dt210).ToList();
//var filteredBookings = from booking in bookings
// where cal.GetWeekOfYear(booking.StartDate, dfi.CalendarWeekRule, dfi.FirstDayOfWeek) == week
// select booking;
//viewModel.BookingList = filteredBookings;
viewModel.BookingList = bookings;
return(View(viewModel));
}