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