public static WebChatSession GetOne(long webChatSessionNum) { if (RemotingClient.RemotingRole == RemotingRole.ClientWeb) { return(Meth.GetObject <WebChatSession>(MethodBase.GetCurrentMethod(), webChatSessionNum)); } WebChatSession session = null; WebChatMisc.DbAction(delegate() { session = Crud.WebChatSessionCrud.SelectOne(webChatSessionNum); }); return(session); }
///<summary>Also sets primary key and DateTcreated.</summary> public static long Insert(WebChatSession webChatSession) { if (RemotingClient.RemotingRole == RemotingRole.ClientWeb) { webChatSession.WebChatSessionNum = Meth.GetLong(MethodBase.GetCurrentMethod(), webChatSession); return(webChatSession.WebChatSessionNum); } WebChatMisc.DbAction(delegate() { Crud.WebChatSessionCrud.Insert(webChatSession); }); WebChatMisc.DbAction(delegate() { Signalods.SetInvalid(InvalidType.WebChatSessions); //Signal OD HQ to refresh sessions. }, false); return(webChatSession.WebChatSessionNum); }
public static WebChatSession GetActiveSessionsForEmployee(string techName) { if (RemotingClient.RemotingRole == RemotingRole.ClientWeb) { return(Meth.GetObject <WebChatSession>(MethodBase.GetCurrentMethod(), techName)); } WebChatSession webChatSession = null; WebChatMisc.DbAction(() => { string command = "SELECT * FROM webchatsession WHERE DateTend < " + POut.DateT(new DateTime(1880, 1, 1)) + " AND webchatsession.TechName = '" + POut.String(techName) + "'" + " ORDER BY webchatsession.DateTcreated "; webChatSession = Crud.WebChatSessionCrud.SelectOne(command); }); return(webChatSession); }
public static void Update(WebChatSession webChatSession, WebChatSession oldWebChatSession, bool hasSignal = true) { if (RemotingClient.RemotingRole == RemotingRole.ClientWeb) { Meth.GetVoid(MethodBase.GetCurrentMethod(), webChatSession, oldWebChatSession, hasSignal); return; } WebChatMisc.DbAction(delegate() { Crud.WebChatSessionCrud.Update(webChatSession, oldWebChatSession); }); if (hasSignal) { WebChatMisc.DbAction(delegate() { Signalods.SetInvalid(InvalidType.WebChatSessions); //Signal OD HQ to refresh sessions. }, false); } }