public ActionResult Details(int Id)
{
RiskSenti context = new RiskSenti();
RiskSentiAnalysi RiskSentiAnalysiData = new RiskSentiAnalysi();
var query = (from x in context.RiskSentiAnalysis
where x.id == Id
select x);
foreach (RiskSentiAnalysi RiskSentiAnalysi in query.ToList())
{
RiskSentiAnalysiData = RiskSentiAnalysi;
break;
}
return(PartialView("_Details", RiskSentiAnalysiData));
}
public ActionResult updateComments(Sentimeter.Models.RiskSentiAnalysi data)
{
RiskSentiAnalysi dataModel = new RiskSentiAnalysi();
//Checking the sentiments of new data - start
decimal?positivityOutput = 0;
int sentimeterOutput = 0;
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(URL);
request.Method = "POST";
request.ContentType = "application/json";
request.ContentLength = data.Comment.Length;
//request.ProtocolVersion = HttpVersion.Version10; // fix 1
//request.KeepAlive = false; // fix 2
//request.Timeout = 1000000000; // fix 3
//request.ReadWriteTimeout = 1000000000; // fix 4
using (Stream webStream = request.GetRequestStream())
using (StreamWriter requestWriter = new StreamWriter(webStream, System.Text.Encoding.ASCII))
{
requestWriter.Write(data.Comment);
}
try
{
WebResponse webResponse = request.GetResponse();
using (Stream webStream = webResponse.GetResponseStream())
{
if (webStream != null)
{
using (StreamReader responseReader = new StreamReader(webStream))
{
string response = responseReader.ReadToEnd();
var data2 = (JObject)JsonConvert.DeserializeObject(response);
positivityOutput = data2["positivity"].Value <decimal>();
sentimeterOutput = data2["sentimeter"].Value <int>();
}
}
}
}
catch (Exception e)
{
Console.Out.WriteLine("-----------------");
Console.Out.WriteLine(e.Message);
}
//End
using (RiskSenti context = new RiskSenti())
{
DateTime now = DateTime.Now;
dataModel.CurrentStatus = data.CurrentStatus;
dataModel.Comment = data.Comment;
dataModel.id = data.id;
dataModel.positivity = positivityOutput;
dataModel.AnalysisCode = sentimeterOutput;
dataModel.AssetId = data.AssetId;
dataModel.updateddate = now;
context.Entry(dataModel).State = EntityState.Added;
context.SaveChanges();
}
RiskSenti context1 = new RiskSenti();
var query = (from x in context1.RiskSentiAnalysis
group x by x.AssetId into a
select a.OrderByDescending(f => f.updateddate).FirstOrDefault()
);
List <RiskSentiAnalysi> data1 = query.ToList();
return(View("Index", data1));
}
