public IHttpActionResult PostCalendarEvent(CalendarEvent calendarevent)
{
if (!ModelState.IsValid)
{
return BadRequest(ModelState);
}
using (EventOrganizerEntities eventOrganizerEntities = new EventOrganizerEntities())
{
eventOrganizerEntities.CalendarEvents.Add(calendarevent);
eventOrganizerEntities.SaveChanges();
}
return CreatedAtRoute("DefaultApi", new { id = calendarevent.Id }, calendarevent);
}
public IHttpActionResult DeleteCalendarEvent(int id)
{
CalendarEvent calendarevent;
using (EventOrganizerEntities eventOrganizerEntities = new EventOrganizerEntities())
{
calendarevent = eventOrganizerEntities.CalendarEvents.Find(id);
if (calendarevent == null)
{
return NotFound();
}
else
{
eventOrganizerEntities.CalendarEvents.Remove(calendarevent);
eventOrganizerEntities.SaveChanges();
}
}
return Ok(calendarevent);
}
// PUT api/Event/5
public IHttpActionResult PutCalendarEvent(int id, CalendarEvent calendarevent)
{
if (!ModelState.IsValid)
{
return BadRequest(ModelState);
}
if (id != calendarevent.Id)
{
return BadRequest();
}
using (EventOrganizerEntities eventOrganizerEntities = new EventOrganizerEntities())
{
try
{
eventOrganizerEntities.Entry(calendarevent).State = EntityState.Modified;
eventOrganizerEntities.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!CalendarEventExists(id))
{
return NotFound();
}
else
{
throw;
}
}
}
return StatusCode(HttpStatusCode.NoContent);
}
public ActionResult Edit([Bind(Include = "Id,EventTitle,Abstract,EventDescription,StartDate,EndDate,Location,Url,Price,EventGroupTitle,EventGroupName,EventTypeOne,CreatedDateTime,LastUpdateDateTime,IsDeleted")] CalendarEvent calendarevent)
{
if (ModelState.IsValid)
{
using (EventOrganizerEntities db = new EventOrganizerEntities())
{
db.Entry(calendarevent).State = EntityState.Modified;
db.SaveChanges();
}
return RedirectToAction("Index");
}
return View(calendarevent);
}
public ActionResult Create([Bind(Include = "Id,EventTitle,Abstract,EventDescription,StartDate,EndDate,Location,Url,Price,EventGroupTitle,EventGroupName,EventTypeOne")] CalendarEvent calendarevent)
{
if (ModelState.IsValid)
{
using (EventOrganizerEntities db = new EventOrganizerEntities())
{
try
{
calendarevent.CreatedDateTime = DateTime.UtcNow;
calendarevent.LastUpdateDateTime = DateTime.UtcNow;
calendarevent.IsDeleted = false;
db.CalendarEvents.Add(calendarevent);
db.SaveChanges();
return Content("Event has been created successfully!");
}
catch (Exception ex)
{
return Content("There is problem in saving the event. Please try again.");
}
}
}
else
{
return View(calendarevent);
}
}
public ActionResult Create([Bind(Include = "Id,EventTitle,Abstract,EventDescription,StartDate,EndDate,Location,Url,Price,EventGroupTitle,EventGroupName,EventTypeOne")] CalendarEvent calendarevent)
{
if (ModelState.IsValid)
{
using (EventOrganizerEntities db = new EventOrganizerEntities())
{
try
{
calendarevent.CreatedDateTime = DateTime.UtcNow;
calendarevent.LastUpdateDateTime = DateTime.UtcNow;
calendarevent.IsDeleted = false;
db.CalendarEvents.Add(calendarevent);
db.SaveChanges();
return Content("Event has been created successfully!");
}
catch (DbEntityValidationException e)
{
StringBuilder sb = new StringBuilder();
foreach (var eve in e.EntityValidationErrors)
{
sb.Append(string.Format("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State));
foreach (var ve in eve.ValidationErrors)
{
sb.Append(string.Format("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage));
}
}
return Content(sb.ToString());
}
catch (Exception ex)
{
//return Content(ex.Message.ToString());
return Content("There is problem in saving the event. Please try again.");
}
}
}
else
{
return View(calendarevent);
}
}
public ActionResult DeleteConfirmed(int id)
{
using (EventOrganizerEntities db = new EventOrganizerEntities())
{
CalendarEvent calendarevent = db.CalendarEvents.Find(id);
db.CalendarEvents.Remove(calendarevent);
db.SaveChanges();
}
return RedirectToAction("Index");
}
private void EditTitleType(string titleType, int id)
{
if (!string.IsNullOrEmpty(titleType))
{
using (EventOrganizerEntities db = new EventOrganizerEntities())
{
var item = db.EventTypeOnes.Where(x => x.Id == id).FirstOrDefault();
db.Usp_UpdateCalendarEvents(titleType, item.EventTypeName, (int)Purpose.EditType);
if (item != null)
{
item.EventTypeName = titleType;
db.SaveChanges();
}
}
}
}
private void EditGroupTitle(string groupTitle, int id)
{
if (!string.IsNullOrEmpty(groupTitle))
{
using (EventOrganizerEntities db = new EventOrganizerEntities())
{
var item = db.EventGroupTitles.Where(x => x.Id == id).FirstOrDefault();
db.Usp_UpdateCalendarEvents(groupTitle, item.Title, (int)Purpose.EditGroupTitle);
if (item != null)
{
item.Title = groupTitle;
db.SaveChanges();
}
}
}
}
private bool DeleteTitleType(int Id)
{
using (EventOrganizerEntities db = new EventOrganizerEntities())
{
var item = db.EventTypeOnes.Where(x => x.Id == Id).FirstOrDefault();
if (item != null)
{
item.IsDeleted = true;
db.SaveChanges();
}
}
return false;
}
private void AddTitleType(string name)
{
using (EventOrganizerEntities db = new EventOrganizerEntities())
{
var item = db.EventTypeOnes.Where(x => x.EventTypeName == name).FirstOrDefault();
if (item == null)
{
EventTypeOne obj = new EventTypeOne();
obj.EventTypeName = name;
obj.IsDeleted = false;
obj.CreatedDateTime = DateTime.UtcNow;
obj.LastUpdateDateTime = DateTime.UtcNow;
db.EventTypeOnes.Add(obj);
db.SaveChanges();
}
}
}
private void AddGroupName(string name)
{
if (!string.IsNullOrEmpty(name))
{
using (EventOrganizerEntities db = new EventOrganizerEntities())
{
var item = db.EventGroupNames.Where(x => x.GroupName == name).FirstOrDefault();
if (item == null)
{
EventGroupName obj = new EventGroupName();
obj.GroupName = name;
obj.IsDeleted = false;
obj.CreatedDateTime = DateTime.UtcNow;
obj.LastUpdateDateTime = DateTime.UtcNow;
db.EventGroupNames.Add(obj);
db.SaveChanges();
}
}
}
}
