public void UpdateSessionSpeaker(SessionSpeakerBase sessionSpeaker, int userId)
{
Requires.NotNull(sessionSpeaker);
Requires.NotNull(sessionSpeaker.SessionId);
Requires.NotNull(sessionSpeaker.SpeakerId);
sessionSpeaker.LastModifiedByUserID = userId;
sessionSpeaker.LastModifiedOnDate = DateTime.Now;
using (var context = DataContext.Instance())
{
var rep = context.GetRepository <SessionSpeakerBase>();
rep.Update("SET CreatedByUserID=@0, CreatedOnDate=@1, LastModifiedByUserID=@2, LastModifiedOnDate=@3, Sort=@4 WHERE SpeakerId=@5 AND SessionId=@6",
sessionSpeaker.CreatedByUserID, sessionSpeaker.CreatedOnDate, sessionSpeaker.LastModifiedByUserID, sessionSpeaker.LastModifiedOnDate, sessionSpeaker.Sort, sessionSpeaker.SpeakerId, sessionSpeaker.SessionId);
}
}
public void AddSessionSpeaker(SessionSpeakerBase sessionSpeaker, int userId)
{
Requires.NotNull(sessionSpeaker);
Requires.NotNull(sessionSpeaker.SessionId);
Requires.NotNull(sessionSpeaker.SpeakerId);
sessionSpeaker.CreatedByUserID = userId;
sessionSpeaker.CreatedOnDate = DateTime.Now;
sessionSpeaker.LastModifiedByUserID = userId;
sessionSpeaker.LastModifiedOnDate = DateTime.Now;
using (var context = DataContext.Instance())
{
context.Execute(System.Data.CommandType.Text,
"IF NOT EXISTS (SELECT * FROM {databaseOwner}{objectQualifier}Connect_Conference_SessionSpeakers " +
"WHERE SpeakerId=@0 AND SessionId=@1) " +
"INSERT INTO {databaseOwner}{objectQualifier}Connect_Conference_SessionSpeakers (SpeakerId, SessionId, CreatedByUserID, CreatedOnDate, LastModifiedByUserID, LastModifiedOnDate, Sort) " +
"SELECT @0, @1, @2, @3, @4, @5, @6", sessionSpeaker.SpeakerId, sessionSpeaker.SessionId, sessionSpeaker.CreatedByUserID, sessionSpeaker.CreatedOnDate, sessionSpeaker.LastModifiedByUserID, sessionSpeaker.LastModifiedOnDate, sessionSpeaker.Sort);
}
}
public void DeleteSessionSpeaker(SessionSpeakerBase sessionSpeaker)
{
DeleteSessionSpeaker(sessionSpeaker.SpeakerId, sessionSpeaker.SessionId);
}
