public ActionResult saveNotif(tbl_notification notif)
{
notif.notifDate = DateTime.Now;
notif.seen = 0;
db.tbl_notification.Add(notif);
db.SaveChanges();
return(Json("", JsonRequestBehavior.AllowGet));
}
public ActionResult DeleteConfirmed(int id)
{
tbl_notification tbl_notification = db.tbl_notification.Find(id);
db.tbl_notification.Remove(tbl_notification);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "not_id,not_action,not_date")] tbl_notification tbl_notification)
{
if (ModelState.IsValid)
{
db.Entry(tbl_notification).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tbl_notification));
}
public ActionResult Create([Bind(Include = "not_id,not_action,not_date")] tbl_notification tbl_notification)
{
if (ModelState.IsValid)
{
db.tbl_notification.Add(tbl_notification);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tbl_notification));
}
public ActionResult Edit([Bind(Include = "notification_id,sender,notification,date,category_id")] tbl_notification tbl_notification)
{
if (ModelState.IsValid)
{
db.Entry(tbl_notification).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.category_id = new SelectList(db.tbl_income_category, "category_id", "category_name", tbl_notification.category_id);
return(View(tbl_notification));
}
// GET: tbl_notification/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbl_notification tbl_notification = db.tbl_notification.Find(id);
if (tbl_notification == null)
{
return(HttpNotFound());
}
return(View(tbl_notification));
}
// GET: /Notification/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbl_notification tbl_notification = db.tbl_notification.Find(id);
if (tbl_notification == null)
{
return(HttpNotFound());
}
ViewBag.category_id = new SelectList(db.tbl_income_category, "category_id", "category_name", tbl_notification.category_id);
return(View(tbl_notification));
}
//public static List<SelectListItem> GetDropDownItems(Dictionary<string, string> options)
//{
// List<SelectListItem> items = new List<SelectListItem>();
// foreach (var )
// {
// employeeDropDownList = (from emp in db.tbl_employee
// select new SelectListItem
// {
// Value = emp.emp_id.ToString(),
// Text = emp.emp_name
// }).ToList();
// }
// return employeeDropDownList;
//}
public static bool SendMessage(NotificationViewModel model)
{
bool send = false;
using (KDMDB db = new KDMDB())
{
tbl_notification tbl = new tbl_notification();
tbl.notf_title = model.Title;
tbl.notf_from = model.From;
tbl.notf_to = model.To;
tbl.notf_message = model.Message;
tbl.notf_time = DateTime.Now;
tbl.notf_status = "send";
db.tbl_notification.Add(tbl);
db.SaveChanges();
send = true;
}
return(send);
}
