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