internal static List <Suggestion> GetCurrentSuggestion(int userId) { List <Suggestion> results; DateTime timeFrom = DateTime.Now.Date; DateTime timeTo = DateTime.Now; using (OstrichTimeEntities en = new OstrichTimeEntities()) { results = en.Suggestions.Where(tl => tl.UserId == userId && timeFrom <= tl.TimeStamp && timeTo >= tl.TimeStamp).ToList(); } return(results); }
internal static Suggestion InsertSuggestion(int userId, DateTime time, string label) { var Suggestion = new Suggestion() { UserId = userId, TimeStamp = time, Label = label }; using (OstrichTimeEntities en = new OstrichTimeEntities()) { en.Suggestions.AddObject(Suggestion); en.SaveChanges(); } return(Suggestion); }