//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);
}
