//private Boolean CheckIfContractRequirementExists(int id) //{ // string sql = @"SELECT COUNT(*) FROM TFS_ContractRequirement AS ContractRequirement WHERE RequirementId = @id"; // DynamicParameters parameters = new DynamicParameters(); // parameters.Add("@id", id); // using (var conn = GetOpenConnection()) // { // int countContractRequirements = conn.ExecuteScalar<int>(sql, parameters); // if (countContractRequirements > 0) // { // return true; // } // else // { // return false; // } // } //} private void InsertMectRequirementAsync(MectRequirement entity) { var sql = @"INSERT OR REPLACE INTO TFS_MectRequirement AS MectRequirement (MectRequirementId, MectTitle, Description, MectName, MectCriteria, MectSource, Scope) VALUES (@MectRequirementId, @MectTitle, @Description, @MectName, @MectCriteria, @MectSource, @Scope)"; using (var conn = GetOpenConnection()) { conn.Execute(sql, entity); } }
private async Task <MectRequirement> GatherMectRequirementIdAndName(int workItemId) { var requestUri = "/APHP/_apis/wit/workitems/" + workItemId + "?api-version=3.0"; var method = new HttpMethod("GET"); var request = new HttpRequestMessage(method, requestUri) { }; var response = await _client.SendAsync(request); string wiqlWorkItem = await response.Content.ReadAsStringAsync(); JObject jo = JObject.Parse(wiqlWorkItem); MectRequirement currRequirement = new MectRequirement(); currRequirement.MectRequirementId = Convert.ToInt32(jo["id"]); if (jo["fields"]["MES.MECTName"] != null) { currRequirement.MectName = jo["fields"]["MES.MECTName"].ToString(); } if (jo["fields"]["MES.MECTSource"] != null) { currRequirement.MectSource = jo["fields"]["MES.MECTSource"].ToString(); } if (jo["fields"]["MES.MECTCriteria"] != null) { currRequirement.MectCriteria = jo["fields"]["MES.MECTCriteria"].ToString(); } if (jo["fields"]["System.Title"] != null) { currRequirement.MectTitle = jo["fields"]["System.Title"].ToString(); } if (jo["fields"]["System.Description"] != null) { currRequirement.Description = jo["fields"]["System.Description"].ToString(); } if (jo["fields"]["MES.Scope"] != null) { currRequirement.Scope = jo["fields"]["MES.Scope"].ToString(); } return(currRequirement); }
private async Task <MectRequirement> GatherMectRequirementFromId(int id) { MectRequirement res = new MectRequirement(); var requestUri = "/APHP/_apis/wit/workitems/" + id + "?$expand=relations&api-version=3.0"; var method = new HttpMethod("GET"); var request = new HttpRequestMessage(method, requestUri) { }; _logger.Log(requestUri); var response = await _client.SendAsync(request); string responseTxt = response.Content.ReadAsStringAsync().Result; _logger.Log(responseTxt); if (response.IsSuccessStatusCode) { JObject jo = JObject.Parse(responseTxt); if (jo["fields"]["MES.RequirementType"] != null && jo["fields"]["MES.RequirementType"].ToString() == "MECT") { res.MectRequirementId = Convert.ToInt32(jo["id"]); if (jo["fields"]["MES.MECTName"] != null) { res.MectName = jo["fields"]["MES.MECTName"].ToString(); } if (jo["fields"]["MES.MECTSource"] != null) { res.MectSource = jo["fields"]["MES.MECTSource"].ToString(); } if (jo["fields"]["MES.MECTCriteria"] != null) { res.MectCriteria = jo["fields"]["MES.MECTCriteria"].ToString(); } if (jo["fields"]["System.Title"] != null) { res.MectTitle = jo["fields"]["System.Title"].ToString(); } if (jo["fields"]["System.Description"] != null) { res.Description = jo["fields"]["System.Description"].ToString(); } if (jo["fields"]["MES.Scope"] != null) { res.Scope = jo["fields"]["MES.Scope"].ToString(); } } return(res); } else { return(res); } }
public void Post(MectRequirement entity) { _mectRequirementRepository.InsertAsync(entity); }