public static void UpdateConnectionDetail(String pConnID, DateTime pCurrentDateTime) { try { using (var ctx = new NotificationEngineDataContext()) { var query = "execute [dbo].[usp_UpdateConnectionDetail] @pConnID, @pCurrentDateTime"; var args = new DbParameter[] { new SqlParameter { ParameterName = "@pConnID", Value = pConnID }, new SqlParameter { ParameterName = "@pCurrentDateTime", Value = pCurrentDateTime }, }; ctx.Database.ExecuteSqlCommand(query, args); } } catch (Exception ex) { LogHandler.WriteLog(MethodBase.GetCurrentMethod().Name, ex.Message, PUCIT.AIMRL.Common.Logger.LogType.ErrorMsg, ex); } }
public static long SaveNotification(RealTimeNotifications obj) { try { using (var ctx = new NotificationEngineDataContext()) { var query = "execute [dbo].[usp_CreateAndUpdateNotifications] @pNotificationID, @senderAppID, @SenderID, @ReceiverAppID, @ReceiverID, @NotificationDetail,@IsRead,@datetime,@extraDataAsJson"; var args = new DbParameter[] { new SqlParameter { ParameterName = "@pNotificationID", Value = obj.NotificationID }, new SqlParameter { ParameterName = "@senderAppID", Value = obj.SenderAppID }, new SqlParameter { ParameterName = "@SenderID", Value = obj.SenderID }, new SqlParameter { ParameterName = "@ReceiverAppID", Value = obj.ReceiverAppID }, new SqlParameter { ParameterName = "@ReceiverID", Value = obj.ReceiverID }, new SqlParameter { ParameterName = "@NotificationDetail", Value = obj.NotificationDetail }, new SqlParameter { ParameterName = "@isRead", Value = obj.IsRead }, new SqlParameter { ParameterName = "@datetime", Value = obj.CreatedOn }, new SqlParameter { ParameterName = "@extraDataAsJson", Value = obj.extraDataAsJson }, }; var notificationID = ctx.Database.SqlQuery <long>(query, args).FirstOrDefault(); return(notificationID); } } catch (Exception ex) { LogHandler.WriteLog(MethodBase.GetCurrentMethod().Name, ex.Message, PUCIT.AIMRL.Common.Logger.LogType.ErrorMsg, ex); return(0); } }
public static List <NotificationApplications> GetNotifcationApplications() { try { using (var ctx = new NotificationEngineDataContext()) { var query = "execute dbo.usp_GetNotificationApps"; var args = new DbParameter[] { }; var data = ctx.Database.SqlQuery <NotificationApplications>(query, args).ToList(); return(data); } } catch (Exception ex) { LogHandler.WriteLog(MethodBase.GetCurrentMethod().Name, ex.Message, PUCIT.AIMRL.Common.Logger.LogType.ErrorMsg, ex); return(new List <NotificationApplications>()); } }
public static String UpdateNotificationReadStatus(String pNotificationID, String receiverAppID, String empID, Boolean isRead, Boolean markAll, DateTime dateTime) { try { using (var ctx = new NotificationEngineDataContext()) { var query = "execute dbo.UpdateNotificationReadStatus @pNotificationID,@ReceiverAppID,@empID, @isRead,@markAll, @dateTime"; var args = new DbParameter[] { new SqlParameter { ParameterName = "@pNotificationID", Value = pNotificationID }, new SqlParameter { ParameterName = "@ReceiverAppID", Value = receiverAppID }, new SqlParameter { ParameterName = "@empID", Value = empID }, new SqlParameter { ParameterName = "@isRead", Value = isRead }, new SqlParameter { ParameterName = "@markAll", Value = markAll }, new SqlParameter { ParameterName = "@dateTime", Value = dateTime }, }; var data = ctx.Database.SqlQuery <String>(query, args).FirstOrDefault(); return(data); } } catch (Exception ex) { LogHandler.WriteLog(MethodBase.GetCurrentMethod().Name, ex.Message, PUCIT.AIMRL.Common.Logger.LogType.ErrorMsg, ex); return(""); } }
public static long SaveConnectionDetail(String pConnID, String pUserID, String pAppID, String pAppUrl, String pIpAddress, DateTime pCurrentDateTime) { try { using (var ctx = new NotificationEngineDataContext()) { var query = "execute [dbo].[usp_AddConnectionDetail] @pConnID, @pUserID, @pAppID, @pAppUrl, @pIpAddress, @pCurrentDateTime"; var args = new DbParameter[] { new SqlParameter { ParameterName = "@pConnID", Value = pConnID }, new SqlParameter { ParameterName = "@pUserID", Value = pUserID }, new SqlParameter { ParameterName = "@pAppID", Value = pAppID }, new SqlParameter { ParameterName = "@pAppUrl", Value = pAppUrl }, new SqlParameter { ParameterName = "@pIpAddress", Value = pIpAddress }, new SqlParameter { ParameterName = "@pCurrentDateTime", Value = pCurrentDateTime }, }; return(ctx.Database.SqlQuery <long>(query, args).FirstOrDefault()); } } catch (Exception ex) { LogHandler.WriteLog(MethodBase.GetCurrentMethod().Name, ex.Message, PUCIT.AIMRL.Common.Logger.LogType.ErrorMsg, ex); return(0); } }
public static List <RealTimeNotifications> GetNotifcations(string appID, String empID, long max_notification_id) { try { using (var ctx = new NotificationEngineDataContext()) { var query = "execute [dbo].[usp_GetRealTimeNotification] @AppID , @EmployeeID , @maxNotificationId"; var args = new DbParameter[] { new SqlParameter { ParameterName = "@AppID", Value = appID }, new SqlParameter { ParameterName = "@EmployeeID", Value = empID }, new SqlParameter { ParameterName = "@maxNotificationId", Value = max_notification_id }, }; var data = ctx.Database.SqlQuery <RealTimeNotifications>(query, args).ToList(); foreach (var d in data) { d.CreatedOn = d.CreatedOn.ToTimeZoneTime(tzi); } return(data); } } catch (Exception ex) { LogHandler.WriteLog(MethodBase.GetCurrentMethod().Name, ex.Message, PUCIT.AIMRL.Common.Logger.LogType.ErrorMsg, ex); return(new List <RealTimeNotifications>()); } }