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