public Object PostTakeBloques(object data)
{
TblCalendario Jloc = JsonConvert.DeserializeObject <TblCalendario>(data.ToString());
var Calendario = new DataCalendario();
DateTime dateTime1 = Convert.ToDateTime(Jloc.FechaCalendario);
DateTime dateTime2 = Convert.ToDateTime(Jloc.FechaCalendario).AddDays(1);
return(Calendario.InicializarCalendario(dateTime1, dateTime2, Convert.ToInt32(Jloc.IdLocalidad)));
}
public List <VistaLocalidadCalendario> InicializarCalendario(TblCalendario Calendario, DateTime SystemDate)
{
DataTable dt = new DataTable();
using (BDVideosUSAVEntitiesModelSolicitudes context = new BDVideosUSAVEntitiesModelSolicitudes())
{
DateTime Date1 = SystemDate.AddDays(-1 * ((int)SystemDate.DayOfWeek - 1));
DateTime Date2 = SystemDate.AddDays((-1 * ((int)SystemDate.DayOfWeek - 1)) + 5);
var Query = from C in context.VistaLocalidadCalendario
where C.FechaCalendario >= Date1 && C.FechaCalendario <= Date2
select C;
return(Query.ToList());
}
}
