private bool CalendarEventExists(int id)
{
using (EventOrganizerEntities eventOrganizerEntities = new EventOrganizerEntities())
{
return(eventOrganizerEntities.CalendarEvents.Count(e => e.Id == id) > 0);
}
}
public ActionResult AdminLoginValidate(FormCollection formCollection)
{
try
{
//string userId = formCollection["UserId"];
string psswrd = formCollection["Password"];
if (psswrd.Equals("adminLogin"))
{
using (EventOrganizerEntities db = new EventOrganizerEntities())
{
ViewData["grouplist"] = db.EventGroupNames.ToList();
ViewData["EventGroupTitle"] = db.EventGroupTitles.ToList();
ViewData["EventTypeOne"] = db.EventTypeOnes.ToList();
}
return(View("AdminPanel"));
}
else
{
return(Content("There is problem while working on filter. Please try again."));
}
}
catch (Exception ex)
{
return(Content("There is problem while working on filter. Please try again."));
}
}
// 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 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 EventFilter(FormCollection formCollection)
{
try
{
string guid = Guid.NewGuid().ToString();
string filterValue = CreateFilterXml(formCollection);
using (EventOrganizerEntities db = new EventOrganizerEntities())
{
ObjectParameter guidOutput = new ObjectParameter("Guid", typeof(string));
guidOutput.Value = guid;
db.usp_AddEventFilter(filterValue, guidOutput);
guid = Convert.ToString(guidOutput.Value);
}
using (EventOrganizerEntities db = new EventOrganizerEntities())
{
List <CalendarEvent> calendarEvents = db.usp_GetEventsByGuid(guid).ToList();
if (calendarEvents == null || calendarEvents.Count == 0)
{
return(Content("No event is associated with your filter criteria. Please try different filter settings.,0"));
}
}
//guid changed to base 64 encrypted string
guid = Extensions.EncodeTo64(guid);
ViewData["eventUrl"] = HttpContext.Request.Url.ToString().Replace("EventFilter", "DownloadEvent/") + guid;
return(Content("Your filter has been applied, please download the calendar event!," + HttpContext.Request.Url.ToString().Replace("EventFilter", "DownloadEvent/") + guid));
}
catch (Exception)
{
return(Content("There is problem while working on filter. Please try again."));
}
}
// GET: /Event/
public ActionResult Index()
{
using (EventOrganizerEntities db = new EventOrganizerEntities())
{
return(View(db.CalendarEvents.ToList()));
}
}
// GET api/Event
public IQueryable <CalendarEvent> GetCalendarEvents()
{
using (EventOrganizerEntities eventOrganizerEntities = new EventOrganizerEntities())
{
return(eventOrganizerEntities.CalendarEvents);
}
}
public string SaveChanges(int id, string value, Purpose purpose)
{
try
{
switch (purpose)
{
case Purpose.DeleteGroupName:
DeleteGroupName(id);
break;
case Purpose.DeleteGroupTitle:
DeleteGroupTitle(id);
break;
case Purpose.DeleteTYpe:
DeleteTitleType(id);
break;
case Purpose.EditGroupName:
EditGroupName(value, id);
break;
case Purpose.EditGroupTitle:
EditGroupTitle(value, id);
break;
case Purpose.EditType:
EditTitleType(value, id);
break;
case Purpose.AddGroupName:
AddGroupName(value);
break;
case Purpose.AddGroupTitle:
AddGroupTitle(value);
break;
case Purpose.AddTitleType:
AddTitleType(value);
break;
}
using (EventOrganizerEntities db = new EventOrganizerEntities())
{
ViewData["grouplist"] = db.EventGroupNames.ToList();
ViewData["EventGroupTitle"] = db.EventGroupTitles.ToList();
ViewData["EventTypeOne"] = db.EventTypeOnes.ToList();
}
return("true");
}
catch
{
return("false");
}
}
/// <summary>
/// ics file download
/// </summary>
/// <param name="guid"></param>
private void Download(string guid)
{
if (!string.IsNullOrEmpty(guid))
{
List <CalendarEvent> calendarEvents;
using (EventOrganizerEntities db = new EventOrganizerEntities())
{
calendarEvents = db.usp_GetEventsByGuid(Extensions.DecodeFrom64(guid)).ToList();
}
string fileName = Guid.NewGuid().ToString() + ".ics";
Response.Write("BEGIN:VCALENDAR" + Environment.NewLine);
Response.Write("VERSION:2.0" + Environment.NewLine);
Response.Write("PRODID: -//ScheduleOnce//EN" + Environment.NewLine);
Response.Write("METHOD:PUBLISH" + Environment.NewLine);
Response.AddHeader("content-disposition", "attachment; filename=" + fileName);
StringBuilder eventInICSFormat = new StringBuilder();
foreach (CalendarEvent calEvent in calendarEvents)
{
eventInICSFormat.Append("BEGIN:VEVENT" + Environment.NewLine);
eventInICSFormat.Append("DTEND:" + (calEvent.EndDate.ToString("s").Replace("-", "").Replace(":", "")) + Environment.NewLine);
eventInICSFormat.Append("DTSTART:" + calEvent.StartDate.ToString("s").Replace("-", "").Replace(":", "") + Environment.NewLine);
StringBuilder eventDescription = new StringBuilder();
if (!string.IsNullOrWhiteSpace(calEvent.Abstract))
{
eventDescription.Append(calEvent.Abstract + "\\n");
}
if (!string.IsNullOrWhiteSpace(calEvent.EventDescription))
{
eventDescription.Append("Event Details : " + calEvent.EventDescription.Replace(Environment.NewLine, "\\n") + "\\n");
}
if (!string.IsNullOrWhiteSpace(calEvent.Url))
{
eventDescription.Append("Url : " + calEvent.Url + "\\n");
}
if (calEvent.Price.HasValue)
{
eventDescription.Append("Price : " + calEvent.Price.Value.ToString());
}
eventInICSFormat.Append("DESCRIPTION:" + eventDescription.ToString() + Environment.NewLine);
eventInICSFormat.Append("LOCATION:" + calEvent.Location + Environment.NewLine);
eventInICSFormat.Append("PRIORITY:5" + Environment.NewLine);
eventInICSFormat.Append("SEQUENCE:0" + Environment.NewLine);
eventInICSFormat.Append("SUMMARY;LANGUAGE=en-us:" + calEvent.EventTitle + Environment.NewLine);
eventInICSFormat.Append("TRANSP:OPAQUE" + Environment.NewLine);
eventInICSFormat.Append(string.Format("UID:{0}", Guid.NewGuid().ToString().ToUpper()) + Environment.NewLine);
eventInICSFormat.Append("BEGIN:VALARM" + Environment.NewLine);
eventInICSFormat.Append("TRIGGER:-PT15M" + Environment.NewLine);
eventInICSFormat.Append("ACTION:DISPLAY" + Environment.NewLine);
eventInICSFormat.Append("DESCRIPTION:Reminder" + Environment.NewLine);
eventInICSFormat.Append("END:VALARM" + Environment.NewLine);
eventInICSFormat.Append("END:VEVENT" + Environment.NewLine);
}
eventInICSFormat.Append("END:VCALENDAR" + Environment.NewLine);
Response.Write(eventInICSFormat);
Response.End();
}
}
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 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);
}
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 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 GetCalendarEvent(int id)
{
CalendarEvent calendarevent;
using (EventOrganizerEntities eventOrganizerEntities = new EventOrganizerEntities())
{
calendarevent = eventOrganizerEntities.CalendarEvents.Find(id);
}
if (calendarevent == null)
{
return(NotFound());
}
return(Ok(calendarevent));
}
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();
}
}
}
}
// GET: /Event/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
using (EventOrganizerEntities db = new EventOrganizerEntities())
{
CalendarEvent calendarevent = db.CalendarEvents.Find(id);
if (calendarevent == null)
{
return(HttpNotFound());
}
return(View(calendarevent));
}
}
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 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();
}
}
}
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));
}
public ActionResult EventFilter()
{
List <SelectListItem> liEventGroupTitles = new List <SelectListItem>();
List <SelectListItem> liEventGroupNames = new List <SelectListItem>();
List <SelectListItem> liEventTypes = new List <SelectListItem>();
using (EventOrganizerEntities db = new EventOrganizerEntities())
{
if (db.EventGroupTitles.Count() > 0)
{
foreach (EventGroupTitle group in db.EventGroupTitles.Where(x => !x.IsDeleted).OrderBy(x => x.Title).ToList())
{
liEventGroupTitles.Add(new SelectListItem {
Text = group.Title, Value = group.Title
});
}
}
if (db.EventGroupNames.Count() > 0)
{
foreach (EventGroupName group in db.EventGroupNames.Where(x => !x.IsDeleted).OrderBy(x => x.GroupName).ToList())
{
liEventGroupNames.Add(new SelectListItem {
Text = group.GroupName, Value = group.GroupName
});
}
}
if (db.EventTypeOnes.Count() > 0)
{
foreach (EventTypeOne typ in db.EventTypeOnes.Where(x => !x.IsDeleted).OrderBy(x => x.EventTypeName).ToList())
{
liEventTypes.Add(new SelectListItem {
Text = typ.EventTypeName, Value = typ.EventTypeName
});
}
}
}
ViewData["typeList"] = liEventTypes;
ViewData["groupList"] = liEventGroupTitles;
ViewData["groupNameList"] = liEventGroupNames;
return(View());
}
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();
}
}
}
}
