public int add(ProcessComplianceResults results) { int datarows = 0; datarows = this._db.Execute(@"INSERT ProcessComplianceResults([AccountID],[ProjectID],[Year],[Quarter],[QualityParameterId],[Rating]) values (@AccountId,@ProjectId,@Year,@Quarter,@QualityParameterId,@Rating)", new { AccountId = results.AccountId, ProjectId = results.ProjectId, Year = results.Year, Quarter = results.Quarter, QualityParameterId = results.QualityParameterId, Rating = results.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); }