public bool uploadResponses(string user, UDArray[] decisions)
{
foreach (UDArray row in decisions)
{
Report rep = _db.Report.Find(row.UniqueID);
DateTime date = DateTime.Today;
if (rep != null)
{
rep.Status = "Updated(" + date.ToString("MM/dd/yyyy") + ")";
Response resp = new Response();
resp.UserID = user;
resp.PluginUniqueID = rep.UniqueID;
resp.Decision = row.Decision;
resp.Comment = row.Comment;
resp.Date = date;
//Add response insert here insert into [dbo].[Response] values(@UserID,@UniqueID,@Decision,@Comment,@Date)
_db.Response.Add(resp);
}
}
int res = _db.SaveChanges();
if (res > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool uploadResponses(string user, ServerResponse[] decisions)
{
DateTime date = DateTime.Today;
foreach (ServerResponse serverRow in decisions)
{
Server server = _db.ServerSummary.Where(t => t.ID == serverRow.ID).ToList().ElementAt(0);
int reportID = server.ReportNameID;
//Report rep = _db.Report.Find(row.UniqueID);
IQueryable <Report> reports = _db.Report.Where(t => t.IPAddress == serverRow.IPAddress && t.ReportNameID == reportID && t.Status != "Closed");
foreach (Report row in reports)
{
row.Status = "Updated(" + date.ToString("MM/dd/yyyy") + ")";
Response resp = new Response();
resp.UserID = user;
resp.PluginUniqueID = row.UniqueID;
resp.Decision = serverRow.Decision;
resp.Comment = serverRow.Comments;
resp.Date = date;
//Add response insert here insert into [dbo].[Response] values(@UserID,@UniqueID,@Decision,@Comment,@Date)
_db.Response.Add(resp);
}
}
int res = _db.SaveChanges();
if (res > 0)
{
return(true);
}
else
{
return(false);
}
}
