public static void AddEventCategory(EventCategory newEventCategory)
{
using (ArgaamAnalyticsDataContext aadc = new ArgaamAnalyticsDataContext())
{
aadc.EventCategories.InsertOnSubmit(newEventCategory);
aadc.SubmitChanges();
}
}
public JsonResult AddEvent(Event globalEvent)
{
using (ArgaamAnalyticsDataContext aadc = new ArgaamAnalyticsDataContext())
{
aadc.Events.InsertOnSubmit(globalEvent);
aadc.SubmitChanges();
}
return(Json("SUCCESS"));
}
public JsonResult DeleteEvent(int eventID)
{
using (ArgaamAnalyticsDataContext aadc = new ArgaamAnalyticsDataContext())
{
//var ge = (from rec in aadc.GlobalEvents
// where rec.GlobalEventID == eventID
// select rec).Single();
var ge = new Event()
{
EventID = eventID
};
aadc.Events.Attach(ge);
aadc.Events.DeleteOnSubmit(ge);
aadc.SubmitChanges();
}
return(Json("SUCCESS", JsonRequestBehavior.AllowGet));
}