public int add(ProcessComplianceSummary summary)
{
int datarows = 0;
datarows = this._db.Execute(@"INSERT ProcessComplianceSummary([AccountID],[ProjectID],[Year],[Quarter],[Rating]) values (@AccountId,@ProjectId,@Year,@Quarter,@Rating)",
new { AccountId = summary.AccountId, ProjectId = summary.ProjectId, Year = summary.Year, Quarter = summary.Quarter, Rating = summary.Rating });
return(datarows);
}
public HttpResponseMessage add([FromBody] string resulteddata)
{
if (authRepo.getAdminRights())
{
Debug.WriteLine("Retr " + resulteddata);
string[] outputArray = resulteddata.Split('|');
ProcessComplianceResults results = new ProcessComplianceResults();
ProcessComplianceSummary summary = new ProcessComplianceSummary();
results.AccountId = Convert.ToInt32(outputArray[1]);
results.ProjectId = Convert.ToInt32(outputArray[0]);
Debug.WriteLine("Account " + results.AccountId + " Project" + results.ProjectId);
results.Year = Convert.ToInt32(outputArray[2]);
results.Quarter = Convert.ToInt32(outputArray[3]);
summary.AccountId = Convert.ToInt32(outputArray[1]);
summary.ProjectId = Convert.ToInt32(outputArray[0]);
summary.Year = Convert.ToInt32(outputArray[2]);
summary.Quarter = Convert.ToInt32(outputArray[3]);
summary.Rating = Convert.ToDouble(outputArray[4]);
summary.ProcessVersion = Convert.ToString(outputArray[5]);
string[] parameterArray = outputArray[6].Split(':');
Debug.WriteLine("gd " + parameterArray[0] + " " + parameterArray.Length);
for (int i = 0; i < (parameterArray.Length - 1); i++)
{
string val = parameterArray[i];
string id = val.Split('-')[0];
string quality = val.Split('-')[1];
results.QualityParameterId = Convert.ToInt32(id);
results.Rating = quality;
repo.add(results);
Debug.WriteLine("Qualities " + id + " " + quality);
}
int x = summaryRepo.add(summary);
return(Request.CreateResponse(HttpStatusCode.OK, x));
}
else
{
return(Request.CreateResponse(HttpStatusCode.Forbidden, "Unauthorized action. Access denied"));
}
}
public int add([FromBody] string resulteddata)
{
Debug.WriteLine("Retr " + resulteddata);
string[] outputArray = resulteddata.Split('|');
ProcessComplianceResults results = new ProcessComplianceResults();
ProcessComplianceSummary summary = new ProcessComplianceSummary();
results.AccountId = Convert.ToInt32(outputArray[1]);
results.ProjectId = Convert.ToInt32(outputArray[0]);
Debug.WriteLine("Account " + results.AccountId + " Project" + results.ProjectId);
results.Year = Convert.ToInt32(outputArray[2]);
results.Quarter = Convert.ToInt32(outputArray[3]);
summary.AccountId = Convert.ToInt32(outputArray[1]);
summary.ProjectId = Convert.ToInt32(outputArray[0]);
summary.Year = Convert.ToInt32(outputArray[2]);
summary.Quarter = Convert.ToInt32(outputArray[3]);
summary.Rating = Convert.ToDouble(outputArray[4]);
summary.ProcessVersion = Convert.ToString(outputArray[5]);
string[] parameterArray = outputArray[6].Split(':');
Debug.WriteLine("gd " + parameterArray[0] + " " + parameterArray.Length);
for (int i = 0; i < (parameterArray.Length - 1); i++)
{
string val = parameterArray[i];
string id = val.Split('-')[0];
string quality = val.Split('-')[1];
results.QualityParameterId = Convert.ToInt32(id);
results.Rating = quality;
repo.add(results);
Debug.WriteLine("Qualities " + id + " " + quality);
}
int x = summaryRepo.add(summary);
return(x);
}
