// notification_new.cshtml public ActionResult SaveNotification(Test2405.Models.NotificationModel notificationModel, Boolean apnsIOS, Boolean gcmAndroid) { string platformString = ""; string connectionString = @"Data Source = localhost; Initial Catalog = LoginDatabase; Integrated Security = True;"; using (SqlConnection sqlCon = new SqlConnection(connectionString)) { Console.WriteLine("Connected"); sqlCon.Open(); SqlCommand StrQuer = new SqlCommand("INSERT INTO [Notification] (ID,send_On,Platform,Notifications,Status,posted_By,action_Activity,Expiry,Priority,Icon,created_On)" + "values(NEWID(),@sendon,@platform,@message,@status,@postedby,@action_activity,@expiry,@priority,@icon,@created_on)", sqlCon); SqlParameter pNotificationSendOn = new SqlParameter("@sendon", notificationModel.NotificationSendOn); if (apnsIOS == true) { platformString += "APNS(iOS)"; } if (apnsIOS == true && gcmAndroid == true) { platformString += "/GCM(Android)"; } else if (gcmAndroid == true) { platformString += "GCM(Android)"; } SqlParameter pNotificationPlatform = new SqlParameter("@platform", platformString); SqlParameter pNotificationMsg = new SqlParameter("@message", notificationModel.NotificationMsg); SqlParameter pNotificationStatus = new SqlParameter("@status", "new"); var tmp = new Byte[20]; HttpContext.Session.TryGetValue("Username", out tmp); string name = System.Text.Encoding.UTF8.GetString(tmp); name = name.Replace("\0", ""); SqlParameter pNotificationPostedBy = new SqlParameter("@postedby", name); SqlParameter pNotificationActionActivity = new SqlParameter("@action_activity", notificationModel.NotificationActionActivity); SqlParameter pNotificationExpiry = new SqlParameter("@expiry", notificationModel.NotificationExpiry); SqlParameter pNotificationPriority = new SqlParameter("@priority", notificationModel.NotificationPriority); SqlParameter pNotificationIcon = new SqlParameter("@icon", notificationModel.NotificationIcon); SqlParameter pCreatedOn = new SqlParameter("@created_on", DateTime.Now.ToString("yyyy-MM-ddTHH:mm:ss.ff")); StrQuer.Parameters.Add(pNotificationSendOn); StrQuer.Parameters.Add(pNotificationPlatform); StrQuer.Parameters.Add(pNotificationMsg); StrQuer.Parameters.Add(pNotificationStatus); StrQuer.Parameters.Add(pNotificationPostedBy); StrQuer.Parameters.Add(pNotificationActionActivity); StrQuer.Parameters.Add(pNotificationExpiry); StrQuer.Parameters.Add(pNotificationPriority); StrQuer.Parameters.Add(pNotificationIcon); StrQuer.Parameters.Add(pCreatedOn); SqlDataReader dr = StrQuer.ExecuteReader(); dr.Close(); sqlCon.Close(); } return(RedirectToAction("Notifications", "Main")); }
public ActionResult UpdateNotification(Test2405.Models.NotificationModel notificationModel, Guid id, Boolean apnsIOS, Boolean gcmAndroid) { string connectionString = @"Data Source = localhost; Initial Catalog = LoginDatabase; Integrated Security = True;"; using (SqlConnection sqlCon = new SqlConnection(connectionString)) { sqlCon.Open(); //SqlCommand StrQuer = new SqlCommand("UPDATE [Notification] (Platform,send_On,Icon,Notifications,action_Activity,Expiry,Priority,updated_On)"+ // "values(@platform,@sendOn,@icon,@notifications,@action_Activity,@expiry,@priority,@updateOn) WHERE ID = @id", sqlCon); SqlCommand StrQuer = new SqlCommand("UPDATE [Notification] SET Platform = @platform," + "send_On = @sendOn, Icon = @icon, Notifications = @notifications," + "action_Activity = @action_Activity, Expiry = @expiry, Priority = @priority, updated_On = @updatedOn WHERE ID = @id", sqlCon); string platformString = "Null"; if (apnsIOS == true && gcmAndroid == true) { platformString = "APNS(iOS)/GCM(Android)"; } else if (apnsIOS == true) { platformString = "APNS(iOS)"; } else if (gcmAndroid == true) { platformString = "GCM(Android)"; } SqlParameter pPlatform = new SqlParameter("@platform", platformString); SqlParameter pSendOn = new SqlParameter("@sendOn", notificationModel.NotificationSendOn); SqlParameter pIcon = new SqlParameter("@icon", notificationModel.NotificationIcon); SqlParameter pNotification = new SqlParameter("@notifications", notificationModel.NotificationMsg); SqlParameter pActionActivity = new SqlParameter("@action_Activity", notificationModel.NotificationActionActivity); SqlParameter pExpiry = new SqlParameter("@expiry", notificationModel.NotificationExpiry); SqlParameter pPriority = new SqlParameter("@priority", notificationModel.NotificationPriority); SqlParameter pUpdatedOn = new SqlParameter("@updatedOn", DateTime.Now.ToString("yyyy-MM-ddTHH:mm:ss.ff")); SqlParameter pID = new SqlParameter("@id", id); StrQuer.Parameters.Add(pID); StrQuer.Parameters.Add(pPlatform); StrQuer.Parameters.Add(pSendOn); StrQuer.Parameters.Add(pIcon); StrQuer.Parameters.Add(pNotification); StrQuer.Parameters.Add(pActionActivity); StrQuer.Parameters.Add(pExpiry); StrQuer.Parameters.Add(pPriority); StrQuer.Parameters.Add(pUpdatedOn); SqlDataReader dr = StrQuer.ExecuteReader(); dr.Close(); sqlCon.Close(); } return(RedirectToAction("Notifications", "Main")); }