public ActionResult DeleteConfirmed(int id) { HisNotification hisNotification = db.HisNotifications.Find(id); db.HisNotifications.Remove(hisNotification); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Id,RecType,Recipient,Message,DtSending,RefId,RefTable")] HisNotification hisNotification) { if (ModelState.IsValid) { db.Entry(hisNotification).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(hisNotification)); }
public ActionResult Create([Bind(Include = "Id,RecType,Recipient,Message,DtSending,RefId,RefTable")] HisNotification hisNotification) { if (ModelState.IsValid) { db.HisNotifications.Add(hisNotification); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(hisNotification)); }
// GET: HIS10/HisNotifications/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } HisNotification hisNotification = db.HisNotifications.Find(id); if (hisNotification == null) { return(HttpNotFound()); } //public int Id { get; set; } //public string HisNotificationId { get; set; } //public string Recipient { get; set; } //public string Name { get; set; } //public string DateSend { get; set; } //public string Status { get; set; } //public string Remarks { get; set; } //get list of notification logs from given notification id // List<HisNotificationLog> notiflist = db.HisNotificationLogs.Where(s=>s.HisNotificationRecipient.HisNotificationId == id).ToList(); List <HisNotificationLog> notiflist = db.HisNotificationLogs.Where(s => s.HisNotificationRecipient.HisNotificationId == id).ToList(); List <NotificationDetailsList> list = new List <NotificationDetailsList>(); foreach (var log in notiflist) { var recptNumber = db.HisNotificationRecipients.Where(r => r.Id == log.Id).Select(r => r.ContactInfo).FirstOrDefault(); var recpt = db.HisNotificationRecipients.Where(r => r.Id == log.Id).Select(r => r.HisNotificationId); var notif = db.HisNotifications.Where(n => recpt.Contains(n.Id)).Select(n => n.RefId); var request = db.HisProfileReqs.Where(r => notif.Contains(r.Id)).FirstOrDefault(); var PhysicianContact = db.HisPhysicians.Where(q => q.Id == request.HisPhysicianId).FirstOrDefault(); string number = recptNumber; list.Add(new NotificationDetailsList() { Id = log.Id, HisNotificationId = log.Id.ToString(), Recipient = number, Name = "-", DateSend = log.DtSending.ToString(), Status = log.Status, Remarks = log.Remarks }); } ViewBag.getNotificationLogs = list; return(View(hisNotification)); }
// GET: HIS10/HisNotifications public ActionResult Index(string statusType) { List <HisProfileReq> request = new List <HisProfileReq>(); List <NotifiedRequestLog> notif = new List <NotifiedRequestLog>(); if (statusType == "Sent") { request.AddRange(db.HisProfileReqs.Where(r => r.dtPerformed != null).ToList()); } else if (statusType == "Failed") { request.AddRange(db1.getFailedNotification()); } if (request == null) { return(HttpNotFound()); } else { foreach (HisProfileReq req in request) { //find the matched notification by id HisNotification n = db.HisNotifications.Where(s => s.RefId == req.Id).FirstOrDefault(); List <HisNotificationRecipient> rcpts = db.HisNotificationRecipients.Where(r => r.HisNotificationId == n.Id).ToList(); //make a list of recipients List <string> recipientList = new List <string>(); //add each recipient to the list foreach (var item in rcpts) { recipientList.Add(item.ContactInfo); } //concat recipients string RecipientsArray = string.Join("\n\r", recipientList); notif.Add(new NotifiedRequestLog() { Id = req.Id, HisNotificationId = n.Id, RecType = n.RecType, DateRequest = req.dtRequested.ToString(), DateSchedule = req.dtSchedule.ToString(), DateSent = req.dtPerformed.ToString(), Recipient = RecipientsArray, Message = n.Message, Status = statusType }); } return(View(notif)); } }
public ActionResult Create([Bind(Include = "Id,RecType,Recipient,Message,DtSending,RefId,RefTable")] HisNotification hisNotification) { if (ModelState.IsValid) { db.HisNotifications.Add(hisNotification); Models.HisProfileReq request = db.HisProfileReqs.Find(hisNotification.RefId); request.dtRequested = DateTime.Now; request.dtSchedule = hisNotification.DtSending; //create contact lists HisNotificationRecipient recipient = new HisNotificationRecipient(); recipient.HisNotificationId = hisNotification.Id; //get contact number of physician HisPhysician physician = db.HisPhysicians.Where(s => s.Id == request.HisPhysicianId).FirstOrDefault(); var notify_Physician = new HisNotificationRecipient //Make sure you have a table called test in DB { HisNotificationId = hisNotification.Id, ContactInfo = physician.ContactInfo }; //get contact number of incharge HisIncharge incharge = db.HisIncharges.Where(s => s.Id == request.HisInchargeId).FirstOrDefault(); HisNotificationRecipient notify_inchage = new HisNotificationRecipient { HisNotificationId = hisNotification.Id, ContactInfo = incharge.ContactInfo }; //get contact info of client (hisprofile) HisProfile client = db.HisProfiles.Where(s => s.Id == request.HisProfileId).FirstOrDefault(); HisNotificationRecipient notify_client = new HisNotificationRecipient { HisNotificationId = hisNotification.Id, ContactInfo = client.ContactInfo }; //add to database db.HisNotificationRecipients.Add(notify_Physician); db.HisNotificationRecipients.Add(notify_inchage); db.HisNotificationRecipients.Add(notify_client); db.SaveChanges(); //HIS10/HisProfileReqs?RptType=1&status=0 // return RedirectToAction("Details", "HisNotifications", new { id = hisNotification.Id }); View(hisNotification); } return(View(hisNotification)); }
// GET: HIS10/HisNotifications/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } HisNotification hisNotification = db.HisNotifications.Find(id); if (hisNotification == null) { return(HttpNotFound()); } return(View(hisNotification)); }
// GET: HIS10/HisNotifications/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } HisNotification hisNotification = db.HisNotifications.Find(id); if (hisNotification == null) { return(HttpNotFound()); } ViewBag.getNotificationLogs = db1.getNotificationLogs(id); return(View(hisNotification)); }
// GET: HIS10/HisNotificationLogs/Create public ActionResult Create(int?id) { ViewBag.HisNotificationId = new SelectList(db.HisNotifications, "Id", "RecType"); int requestid = (int)id; ViewBag.RefId = requestid.ToString(); HisProfileReq req = db.HisProfileReqs.Where(s => s.Id == requestid).FirstOrDefault(); //Models.HisRequest req = db.HisRequests.Find((int)requestid); if (requestid != 0) { Models.HisNotification temp = new HisNotification(); temp.DtSending = (DateTime)req.dtSchedule; temp.RefId = requestid; temp.RecType = "Client"; temp.RefTable = "HisProfileReqs"; temp.Message = db1.generateMessage((int)requestid); // temp.Message = requestid.ToString(); return(View(temp)); } return(View()); }