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