public List <dynamic> ResolveCounselling([FromBody] Counselling_Request groups) { ReviveCommunicationsDBEntities3 db = new ReviveCommunicationsDBEntities3(); Counselling_Request group = db.Counselling_Request.Where(x => x.CounsellingRequestID == groups.CounsellingRequestID).FirstOrDefault(); db.Counselling_Request.Remove(group); db.SaveChanges(); return(GetCounsellingRequest()); }
public List <dynamic> AddCounsellingRequest([FromBody] Counselling_Request AddCounsellingRequest) { ReviveCommunicationsDBEntities3 db = new ReviveCommunicationsDBEntities3(); if (AddCounsellingRequest != null) { db.Configuration.ProxyCreationEnabled = false; string PhoneNumber = db.People.Where(x => x.PersonID == AddCounsellingRequest.PersonID).Select(o => o.Number).FirstOrDefault(); string MemberName = db.People.Where(x => x.PersonID == AddCounsellingRequest.PersonID).Select(o => o.Name).FirstOrDefault(); AddCounsellingRequest.PhoneNumber = PhoneNumber; db.Counselling_Request.Add(AddCounsellingRequest); db.SaveChanges(); List <string> SentimentAnalysis = AddCounsellingRequest.CounsellingDescription.ToLower().Split(' ').ToList(); List <Sentiment_Analysis> getCriticalWords = db.Sentiment_Analysis.ToList(); for (int i = 0; i < SentimentAnalysis.Count(); i++) { string wordCheck = SentimentAnalysis[i].Replace(".", "") + "\r\n"; foreach (var word in getCriticalWords) { if (wordCheck == word.CriticalWord.ToLower()) { message = AddCounsellingRequest.CounsellingDescription; Emailsubject = "Alert - Urgent Counselling Request"; toName = MemberName; sendEmail(); } } } return(GetCounsellingRequest()); } else { return(null); } }
public dynamic GetCounsellingByID(int ID) { ReviveCommunicationsDBEntities3 db = new ReviveCommunicationsDBEntities3(); db.Configuration.ProxyCreationEnabled = false; //retrieve object where id is equal to id received Counselling_Request thisRequest = db.Counselling_Request.Where(x => x.CounsellingRequestID == ID).Include("Person").FirstOrDefault(); dynamic counsellingReq = new ExpandoObject(); counsellingReq = db.Counselling_Request.Where(x => x.CounsellingRequestID == ID).FirstOrDefault(); try { return(thisRequest); //return object } catch (Exception e) { //else return error dynamic toReturn = new ExpandoObject(); toReturn.Error = e.Message; return(toReturn); } }