public static VM_Event ByID(long EventID)
{
using (exodusEntities exodusDB = new exodusEntities())
{
var rez = exodusDB.stp_Event_ByID(EventID).FirstOrDefault();
if (rez != null)
{
var tag = rez.fk_TagID.HasValue ? _DL.Tag.Get.ByID(rez.fk_TagID.Value) : null;
//
var _event = new VM_Event()
{
ID = rez.EventID,
Title = rez.EventTitle,
Added = rez.EventAdded,
Category = new VM_EventCategory()
{
ID = rez.fk_EventCategoryID
},
Type = Global.Cache.dicEventTypes[(EN_EventType)rez.fk_EventTypeID],
Tag = tag ?? new VM_Tag(),
Application = (tag == null) ? new VM_Application() : Global.Cache.dicApplications[tag.ApplicationType],
ImportanLevel = new VM_ImportanLevel()
{
ID = (int)Global.Cache.dicEventTypes[(EN_EventType)rez.fk_EventTypeID].ImportantLevel
}
};
// load XML
_event.Content.LoadXml(rez.EventContent);
_event.Thumbnail.LoadXml(rez.EventThumbnail);
return(_event);
}
;
}
return(null);
}
public static long Event(VM_Event Event)
{
using (var exodusDB = new exodusEntities())
{
ObjectParameter eventID = new ObjectParameter("EventID", 0);
//
exodusDB.stp_Event_Add(
eventTypeID: Event.Type.ID,
eventTitle: Event.Title,
eventContent: Event.Content.OuterXml,
eventThumbnail: Event.Thumbnail.OuterXml,
tagID: Event.Tag == null ? new long?() : Event.Tag.TagID,
applicationID: Event.Application == null ? new int?() : Event.Application.ApplicationID,
eventID: eventID);
//
return(Convert.ToInt64(eventID.Value));
}
}
