public CommonDbResponse ManageNotification(MobileNotificationCommon mnc)
{
var sql = "Exec Sproc_mobile_notification ";
sql += "@flag = '" + (string.IsNullOrEmpty(mnc.NotificationId) ? "i" : "u") + "' ";
sql += ",@notification_id=" + dao.FilterString(mnc.NotificationId);
sql += ",@notification_subject=" + dao.FilterString(mnc.NotificationSubject);
sql += ",@notification_subtitle=" + dao.FilterString(mnc.NotificationSubtitle);
sql += ",@notification_body=" + dao.FilterString(mnc.NotificationBody);
//sql += ",@notification_image_url=" + dao.FilterString(mnc.NotificationImageUrl);
sql += ",@notification_image_url=" + dao.FilterString(mnc.ImageUpload);
sql += ",@action_id=" + dao.FilterString(mnc.ActionId);
sql += ",@notification_type=" + dao.FilterString(mnc.NotificationType);
sql += ",@notification_importance_level=" + dao.FilterString(mnc.NotificationImportanceLevel);
sql += ",@notification_status=" + dao.FilterString(mnc.NotificationStatus);
sql += ",@is_background=" + dao.FilterString(mnc.IsBackground);
sql += ",@notification_to=" + dao.FilterString(mnc.NotificationTo);
sql += ",@agent_id=" + dao.FilterString(mnc.AgentId);
sql += ",@user_id=" + dao.FilterString(mnc.UserId);
sql += ",@action_user="******",@txn_id=" + dao.FilterString(mnc.TxnId);
sql += ",@read_status=" + dao.FilterString(mnc.ReadStatus);
sql += ",@txn_status_id=" + dao.FilterString(mnc.TxnStatusId);
sql += ",@txn_status=" + dao.FilterString(mnc.TxnStatus);
return(dao.ParseCommonDbResponse(sql));
}
public MobileNotificationCommon GetNotificationById(string notificationid, string username)
{
var sql = "Exec Sproc_mobile_notification ";
sql += "@flag = 'sid' ";
sql += "@notification_id =" + dao.FilterString(notificationid);
sql += "@action_user ="******"notification_id"].ToString();
common.NotificationSubject = dt["notification_subject"].ToString();
common.NotificationSubtitle = dt["notification_subtitle"].ToString();
common.NotificationBody = dt["notification_body"].ToString();
common.NotificationImageUrl = dt["notification_image_url"].ToString();
common.ActionId = dt["action_id"].ToString();
common.NotificationType = dt["notification_type"].ToString();
common.NotificationImportanceLevel = dt["notification_importance_level"].ToString();
common.NotificationStatus = dt["notification_status"].ToString();
common.IsBackground = dt["is_background"].ToString();
common.NotificationTo = dt["notification_to"].ToString();
common.AgentId = dt["agent_id"].ToString();
common.UserId = dt["user_id"].ToString();
common.CreateDate = dt["created_local_date"].ToString();
common.TxnId = dt["txn_id"].ToString();
common.ReadStatus = dt["read_status"].ToString();
common.TxnStatusId = dt["txn_status_id"].ToString();
common.TxnStatus = dt["txn_status"].ToString();
}
return(common);
}
public List <MobileNotificationCommon> GetNotificationList()
{
var sql = "Exec Sproc_mobile_notification ";
sql += "@flag = 's' ";
var dt = dao.ExecuteDataTable(sql);
var list = new List <MobileNotificationCommon>();
if (dt != null)
{
foreach (DataRow item in dt.Rows)
{
var common = new MobileNotificationCommon
{
NotificationId = item["notification_id"].ToString(),
NotificationSubject = item["notification_subject"].ToString(),
NotificationSubtitle = item["notification_subtitle"].ToString(),
NotificationType = item["notification_type"].ToString(),
NotificationStatus = item["notification_status"].ToString()
};
list.Add(common);
}
}
return(list);
}
public ActionResult Manage(MobileNotificationModel mnm, HttpPostedFileBase Image_Upload)
{
var ImagePath = "";
ViewBag.importancelevel = ApplicationUtilities.SetDDLValue(LoadDropdownList("importance"), "", "--select Importance Level--");
if (ModelState.IsValid)
{
MobileNotificationCommon mnc = new MobileNotificationCommon();
mnc = mnm.MapObject <MobileNotificationCommon>();
if (!string.IsNullOrEmpty(mnc.NotificationId))
{
if (string.IsNullOrEmpty(mnc.NotificationId.DecryptParameter()))
{
return(View("Manage", mnm));
}
mnc.NotificationId = mnc.NotificationId.DecryptParameter();
}
if (Image_Upload != null)
{
var contentType = Image_Upload.ContentType;
var allowedExtensions = new[] { ".jpg", ".png", ".jpeg" };
var fileName = Path.GetFileName(Image_Upload.FileName);
String timeStamp = DateTime.Now.ToString();
var ext = Path.GetExtension(Image_Upload.FileName);
if (Image_Upload.ContentLength > 1 * 1024 * 1024)//1 MB
{
this.ShowPopup(1, "Image Size must be less than 1MB");
return(View(mnm));
}
if (allowedExtensions.Contains(ext.ToLower()))
{
string datet = DateTime.Now.ToString().Replace('/', ' ').Replace(':', ' ');
string myfilename = "logo " + datet + ext.ToLower();
ImagePath = Path.Combine(Server.MapPath("~/Content/userupload/Notification"), myfilename);
mnc.ImageUpload = "/Content/userupload/Notification/" + myfilename;
}
else
{
this.ShowPopup(1, "File Must be .jpg,.png,.jpeg");
return(View(mnm));
}
}
mnc.ActionUser = ApplicationUtilities.GetSessionValue("username").ToString();
var dbresp = buss.ManageNotification(mnc);
if (dbresp.Code == 0)
{
if (Image_Upload != null)
{
Image_Upload.SaveAs(ImagePath);
}
this.ShowPopup(0, "successfully Inserted");
return(RedirectToAction("Index"));
}
}
this.ShowPopup(1, "Error");
return(View(mnm));
}
public ActionResult Manage(string id)
{
MobileNotificationModel mnm = new MobileNotificationModel();
string username = ApplicationUtilities.GetSessionValue("username").ToString();
ViewBag.importancelevel = ApplicationUtilities.SetDDLValue(LoadDropdownList("importance"), "", "--Select Importance Level--");
if (!string.IsNullOrEmpty(id))
{
if (!string.IsNullOrEmpty(id.DecryptParameter()))
{
MobileNotificationCommon mnc = new MobileNotificationCommon();
mnc = buss.GetNotificationById(id.DecryptParameter(), username);
}
}
return(View(mnm));
}
public CommonDbResponse ManageNotification(MobileNotificationCommon mnc)
{
return(repo.ManageNotification(mnc));
}
