public bool deleteEvent(Guid eventID)
{
eventsCalendarDataContext objEvents = new eventsCalendarDataContext();
using (objEvents)
{
var events = objEvents.brdhc_Events.Where(x => x.EventId == eventID);
objEvents.brdhc_Events.DeleteAllOnSubmit(events);
objEvents.SubmitChanges();
return true;
}
}
public void updateEvent(string eventId, string _title, string _description, string _date, string _start,
string _end, string _location, string _heldBy)
{
eventsCalendarDataContext objEvents = new eventsCalendarDataContext();
var events = objEvents.brdhc_Events.Single(x => x.EventId == new Guid(eventId));
events.EventTitle = _title;
events.EventDescription = _description;
events.EventDate = DateTime.Parse(_date.ToString());
events.EventStartTime = _start;
events.EventEndTime = _end;
events.EventLocation = _location;
events.EventsHeldBy = _heldBy;
objEvents.SubmitChanges();
}
public bool insertEvent(Guid eventID, string _title, string _description, Guid _createdBy, DateTime _date, string _start,
string _end, string _location, string _heldBy //bool _isApproved
)
{
eventsCalendarDataContext objEvents = new eventsCalendarDataContext();
using (objEvents)
{
brdhc_Event objNewEvent = new brdhc_Event();
objNewEvent.EventId = Guid.NewGuid();
objNewEvent.EventTitle = _title;
objNewEvent.EventDescription = _description;
objNewEvent.EventCreatedBy = Guid.Parse(_createdBy.ToString());
objNewEvent.EventDate = _date;
objNewEvent.EventStartTime = _start;
objNewEvent.EventEndTime = _end;
objNewEvent.EventLocation = _location;
objNewEvent.EventsHeldBy = _heldBy;
//objNewEvent.IsApproved = _isApproved;
objEvents.brdhc_Events.InsertOnSubmit(objNewEvent);
objEvents.SubmitChanges();
return true;
}
}