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());
}
