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