public IHttpActionResult SavePushMessage(tbl_PushMessage_ForAllApps allApps)
{
if (string.IsNullOrWhiteSpace(allApps.Body) || string.IsNullOrWhiteSpace(allApps.Title))
{
return(Ok(new
{
result = "Failed"
}));
}
else
{
if (allApps.ServiceName.ToLower().Contains("song"))
{
// DelPreviousInsertNewFromMYSql();
}
allApps.TimeStamp = DateTime.Now;
allApps.ServiceName = "Songster";
_contextFirebaseEntities.tbl_PushMessage_ForAllApps.Add(allApps);
_contextFirebaseEntities.SaveChanges();
var aa = allApps.Id;
_contextFirebaseEntities.Database.ExecuteSqlCommand("sp_InsertIntoDesktopTableRenew_ForAllApps_SongSter @id",
new SqlParameter("@id", aa));
return(Ok(new
{
result = "Success"
}));
}
}
public IHttpActionResult pushSave(pushTemp push)
{
FirebaseEntities db = new FirebaseEntities();
tbl_PushMessage_ForAllApps pushMessage = new tbl_PushMessage_ForAllApps();
tbl_FirebaseSendDesktopNotification_ForAllApps sendPushMsg = new tbl_FirebaseSendDesktopNotification_ForAllApps();
pushMessage.Title = push.title;
pushMessage.Body = push.body;
pushMessage.ImageUrl = push.imgUrl;
pushMessage.TimeStamp = DateTime.Now;
pushMessage.ProcessTime = push.sendTime;
pushMessage.ContentCode = push.id;
pushMessage.ServiceName = "Songster-Audio-Push";
db.tbl_PushMessage_ForAllApps.Add(pushMessage);
db.SaveChanges();
int refId = (int)pushMessage.Id;
sendPushMsg.ImageUrl = push.imgUrl;
sendPushMsg.isSent = 0;
sendPushMsg.AppType = "Songster_Service_Name";
sendPushMsg.ServiceName = "Songster_Service_Name";
sendPushMsg.Refid = refId;
sendPushMsg.Title = push.title;
sendPushMsg.Body = push.body;
sendPushMsg.ProcessTime = push.sendTime;
sendPushMsg.SendTime = push.sendTime;
sendPushMsg.TimeStamp = DateTime.Now;
sendPushMsg.ContentCode = push.id;
sendPushMsg.Token = "";
sendPushMsg.MSISDN = "";
sendPushMsg.PushTblId = refId;
sendPushMsg.RedirectUrl = "";
db.tbl_FirebaseSendDesktopNotification_ForAllApps.Add(sendPushMsg);
db.SaveChanges();
return(Ok());
}
