public void Post(string defectId)
{
using (IOTMOdel context = new IOTMOdel())
{
// string query_1 = @"INSERT INTO [dbo].[Issues]([DefectID],[RequestTime],[ResponceTime],[status]) OUTPUT INSERTED.ID VALUES('" + defectId + "','"+ DateTime.Now + "','','"+false+ "')";
// string query_1 = @"Insert into Issues(DefectID, RequestTime, ResponceTime, status) Output Inserted.ID Values('" + defectId + "','" + DateTime.Now + "','','" + false + "')";
// Debug.WriteLine(query_1);
Issues issues = new Issues();
issues.status = true;
issues.DefectID = defectId;
issues.RequestTime = DateTime.Now;
issues.ResponceTime = DateTime.Now;
context.Issues.Add(issues);
context.SaveChanges();// end of the save
try
{
context.SaveChanges();
var lineInfo = context.IPs.Where(x => x.RaspBerryID == 2).FirstOrDefault();
string responce = TakeAction(lineInfo.IPAddress, defectId, issues.ID);
int issue = Int32.Parse(responce);
var issueEntity = context.Issues.SingleOrDefault(f => f.ID == issue);
issueEntity.status = true;
issueEntity.ResponceTime = DateTime.Now;
context.SaveChanges();
}
catch (Exception ex)
{
Debug.WriteLine("Error " + ex);
}
}
}
public string Get(string issueid)
{
using (IOTMOdel context = new IOTMOdel())
{
List <Issues> jcList = context.Issues.Where(x => x.DefectID == issueid).ToList();
string yourJson = Newtonsoft.Json.JsonConvert.SerializeObject(jcList);
return(yourJson);
}
}
public String Get()
{
using (IOTMOdel context = new IOTMOdel())
{
List <Issues> jcList = context.Issues.Where(x => x.status == true || x.status == false).ToList();
string yourJson = Newtonsoft.Json.JsonConvert.SerializeObject(jcList);
return(yourJson);
}
}
