private Int64 SaveNotification(string ReceiverAppId, int to, string message, DateTime messageTime, String extraDataAsJson) { RealTimeNotifications obj = new RealTimeNotifications(); obj.NotificationID = 0; obj.receiverAppID = ReceiverAppId; obj.SenderID = 0; obj.ReceiverID = to; obj.NotificationDetail = message; obj.IsRead = false; obj.CreatedOn = messageTime; obj.extraDataAsJson = extraDataAsJson; var result = NotificationEngineDataService.SaveNotification(obj); return(result); }
public static Int64 SaveNotification(RealTimeNotifications obj) { try { using (var ctx = new NotificationEngineDataContext()) { var query = "execute [dbo].[usp_CreateAndUpdateNotifications] @pNotificationID, @ReceiverAppID, @SenderID, @ReceiverID, @NotificationDetail,@IsRead,@datetime,@extraDataAsJson"; var args = new DbParameter[] { new SqlParameter { ParameterName = "@pNotificationID", Value = obj.NotificationID }, new SqlParameter { ParameterName = "@ReceiverAppID", Value = obj.receiverAppID }, new SqlParameter { ParameterName = "@SenderID", Value = obj.SenderID }, 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 data = ctx.Database.SqlQuery <Int64>(query, args).FirstOrDefault(); return(data); } } catch (Exception ex) { LogHandler.WriteLog(MethodBase.GetCurrentMethod().Name, ex.Message, PUCIT.AIMRL.Common.Logger.LogType.ErrorMsg, ex); return(0); } }
private long SaveNotification(CustomConnectionData src, CustomConnectionData target, String message, DateTime messageTime, String extraDataAsJson, out String uniqueNotificationID) { uniqueNotificationID = Guid.NewGuid().ToString(); RealTimeNotifications obj = new RealTimeNotifications(); obj.NotificationID = uniqueNotificationID; obj.SenderAppID = src.AppID; obj.SenderID = src.UserID; obj.ReceiverAppID = target.AppID; obj.ReceiverID = target.UserID; obj.NotificationDetail = message; obj.IsRead = false; obj.CreatedOn = messageTime; obj.extraDataAsJson = extraDataAsJson; var result = NotificationEngineDataService.SaveNotification(obj); return(result); }