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); }