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