public bool CreateNewEvent(string Title, string NewEventDate, string NewEventAddress, string NewEventDescription, string NewEventSTime, string NewEventETime, string NewEventDuration, int EventSymbol) { try { Entities ent = new Entities(); EventCalendar evt = new EventCalendar(); evt.UserID = HttpContext.Current.User.Identity.GetUserId<int>(); evt.Title = Title; evt.Address = NewEventAddress; evt.DateTimeScheduled = DateTime.Parse(NewEventDate); evt.Description = NewEventDescription; evt.EndDay = evt.DateTimeScheduled; evt.StatusENUM = EventSymbol; evt.IsActive = true; ent.EventCalendars.Add(evt); ent.SaveChanges(); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } return false; } return true; }
public PlaceDAO() { db = new Entities(); }
public CalendarDAO() { ent = new Entities(); }
public void UpdateEvents(int id, string NewEventStart, string NewEventEnd) { using (Entities ent = new Entities()) { var rec = ent.EventCalendars.FirstOrDefault(s => s.ID == id); if (rec != null) { DateTime DateTimeStart = DateTime.Parse(NewEventStart, null, DateTimeStyles.RoundtripKind).ToLocalTime(); // and convert offset to localtime rec.DateTimeScheduled = DateTimeStart; if (!String.IsNullOrEmpty(NewEventEnd)) { TimeSpan span = DateTime.Parse(NewEventEnd, null, DateTimeStyles.RoundtripKind).ToLocalTime() - DateTimeStart; rec.EndDay = DateTime.Parse(NewEventEnd, null, DateTimeStyles.RoundtripKind).ToLocalTime(); } ent.SaveChanges(); } } }
public List<CalendarEvents> LoadAllEventsInDateRange(DateTime start, DateTime end) { var fromDate = start; var toDate = end; using (Entities ent = new Entities()) { var rslt = ent.EventCalendars.Where(s => s.DateTimeScheduled >= fromDate && s.EndDay <= toDate && s.IsActive == true); List<CalendarEvents> result = new List<CalendarEvents>(); foreach (var item in rslt) { CalendarEvents rec = new CalendarEvents(); rec.ID = item.ID; rec.UserId = item.UserID; string StringDate = string.Format("{0:yyyy-MM-dd}", item.DateTimeScheduled); rec.StartDateString = item.DateTimeScheduled.ToString("yyyy-MM-dd"); rec.EndDateString = item.EndDay.ToString("yyyy-MM-dd"); int enColor = EventExpired(rec.ID, rec.EndDateString, item.StatusENUM); rec.Title = item.Title; rec.StatusString = Enums.GetName<EventStatus>((EventStatus)enColor); rec.StatusColor = Enums.GetEnumDescription<EventStatus>(rec.StatusString); string ColorCode = rec.StatusColor.Substring(0, rec.StatusColor.IndexOf(":")); rec.ClassName = rec.StatusColor.Substring(rec.StatusColor.IndexOf(":") + 1, rec.StatusColor.Length - ColorCode.Length - 1); rec.StatusColor = ColorCode; rec.Address = item.Address; rec.Descriptions = item.Description; result.Add(rec); } return result; } }
public AskingDAO() { db = new Entities(); }
//public ActionResult VirtualTourist() //{ // return View(); //} public ActionResult IsNameAvailble(string Name) { using (Entities db = new Entities()) { try { var name = db.Places.Single(m => m.Name == Name); return Json(false, JsonRequestBehavior.AllowGet); } catch (Exception) { return Json(true, JsonRequestBehavior.AllowGet); } } }
public ArticleDAO() { db = new Entities(); }