public void GetDoubleMark_ShouldReturnValidResults_WithVisitorWinResult(int homeScore, int visitorScore) { var finalResult = new FinalResult(this.mockedMatch, homeScore, visitorScore); var results = finalResult.GetDoubleMark(); Assert.AreEqual("X2", results[0]); Assert.AreEqual("_12", results[1]); }
public void DisplayResult(FinalResult result) { //TO DO foreach (var anim in result.unit) { Animate(anim); StartCoroutine(Wait()); } }
private FinalResult GetResult() { var finalResult = new FinalResult(); finalResult.FinalState = new FinalState(_positionState.X, _positionState.Y, _positionState.Facing.ToString()); finalResult.Battery = _positionState.LeftBattery; finalResult.Visited = _instructionExecutor.GetVisited(); finalResult.Cleaned = _instructionExecutor.GetCleaned(); return(finalResult); }
public void CalculateFinalResult() { FinalResult newResult = new FinalResult(); newResult.InterArrivalTime = interArrivalTiemInputed; foreach (var finalResult in getAllFinalTableInfo()) { newResult.ArrivalTime = finalResult.ArrivalTime + newResult.InterArrivalTime; } newResult.ServiceTime = serviceTimeInputed; int previousServiceEndTiem = 0; foreach (var finalResult in getAllFinalTableInfo()) { previousServiceEndTiem = finalResult.ServiceEndTime; } if (previousServiceEndTiem <= newResult.ArrivalTime) { newResult.ServiceStartTime = newResult.ArrivalTime; } else { newResult.ServiceStartTime = previousServiceEndTiem; } newResult.ServiceEndTime = newResult.ServiceStartTime + newResult.ServiceTime; int initialQueue = 0; if (newResult.ServiceStartTime > newResult.ArrivalTime) { newResult.Queue = newResult.ServiceStartTime - newResult.ArrivalTime; } else { newResult.Queue = initialQueue; } newResult.TimeSpends = newResult.ServiceEndTime - newResult.ArrivalTime; int initialIdleTime = 0; if (previousServiceEndTiem < newResult.ArrivalTime) { newResult.IdleTime = newResult.ArrivalTime - previousServiceEndTiem; } else { newResult.IdleTime = initialIdleTime; } SaveFinalTableData(newResult); }
public void SaveFinalTableData(FinalResult finalResult) { string query = "Insert into tbl_TotalSimulation values(" + arrivalRD + "," + finalResult.InterArrivalTime + "," + finalResult.ArrivalTime + "," + serviceRD + "," + finalResult.ServiceTime + "," + finalResult.ServiceStartTime + "," + finalResult.ServiceEndTime + "," + finalResult.Queue + "," + finalResult.TimeSpends + "," + finalResult.IdleTime + ")"; SqlCommand command = new SqlCommand(); command.Connection = connection; command.CommandText = query; connection.Open(); command.ExecuteNonQuery(); connection.Close(); }
static void Main(string[] args) { //Check for arguments if (args != null && args.Length > 0 && !string.IsNullOrEmpty(args[0])) { var path = args[0]; if (File.Exists(path)) { try { //read csv file into list var lines = File.ReadAllLines(path).Skip(1); List <Equity> equities = new List <Equity>(); Equity equity; foreach (var line in lines) { equity = new Equity(); string[] words = line.Split(','); equity.InvestmentDate = Convert.ToDateTime(words[0].Trim()); equity.SharesPurchased = Convert.ToInt32(words[1].Trim()); equity.CashPaid = Convert.ToDouble(words[2].Trim()); equity.Investor = words[3].Trim(); equities.Add(equity); } //Get data by investors var ownership = equities.GroupBy(e => e.Investor).Select(equity => new { investor = equity.Key, shares = equity.Sum(x => x.SharesPurchased), cash_paid = equity.Sum(x => x.CashPaid), ownership = String.Format("{0:0.00}", (double)equity.Sum(x => x.SharesPurchased) * 100 / equities.Sum(e => e.SharesPurchased)) }); var f = new FinalResult(); f.date = equities.OrderByDescending(e => e.InvestmentDate).First().InvestmentDate.ToString("MM/dd/yyyy"); f.cash_raised = equities.Sum(e => e.CashPaid); f.total_number_of_shares = equities.Sum(e => e.SharesPurchased); f.ownership = ownership; Console.WriteLine(JsonConvert.SerializeObject(f)); } catch (Exception ex) { Console.WriteLine("Some error occured. Details:" + ex.Message); } } else { Console.WriteLine("File don't exist on given path."); } } else { Console.WriteLine("Please enter valid path."); } }
public override void DisplayFinalResult(FinalResult toDisplay) { this.gameObject.SetActive(true); print(toDisplay.m_Name); print(toDisplay.m_Color); m_DisplayText.text = toDisplay.m_Name; m_CocktailGlassFillDisplay.color = new Color(toDisplay.m_Color.r, toDisplay.m_Color.g, toDisplay.m_Color.b, 0.5f); m_FoamDisplay.sprite = toDisplay.m_Foam; m_FoamDisplay.color = toDisplay.m_FoamColor; }
public FinalResult GetMinimum(InitialData data) { _func = data.Func; _iterationCount = 0; _result = new FinalResult { Results = new List <IterationResult>() }; if (_method == FibonacciMethod) { GenerateFibonacci((long)((data.To - data.From) / _error)); } var segment = new Segment { From = data.From, To = data.To }; _x = _v = _w = segment.Mid; _d = _e = segment.Length; _brantError = _error / 1000; _initialSegment = new Segment() { From = segment.From, To = segment.To }; _lastIterationResult = new IterationResult { Segment = _initialSegment }; _result.Results.Add(new IterationResult { Segment = segment, From = segment.From, To = segment.To, LengthRatio = segment.Length / _initialSegment.Length, Res1 = _func(segment.From), Res2 = _func(segment.To) }); while (segment.Length >= _error) { _iterationCount++; segment = _method(segment); _result.Results.Add(_lastIterationResult); } _result.IterationCount = _iterationCount; _result.Res = Math.Min(_func(segment.From), _func(segment.To)); return(_result); }
private void UpdateCheckDirty(FinalResult r) { if (r.FinalStatus != r.RunningStatus) { ++_nbFinalDifferFromRunning; } else { --_nbFinalDifferFromRunning; } Debug.Assert(_nbFinalDifferFromRunning >= 0, "There can't be less than zero differences.."); _runner.SetDirty(_nbFinalDifferFromRunning > 0); }
internal void SetRunningError(IExecutionPlanResult error) { Debug.Assert(error.Status != ExecutionPlanResultStatus.Success && error.Culprit != null, "An error is necessarily associated to a plugin."); FinalResult r = _final.GetOrSet(error.Culprit.PluginId, g => new FinalResult()); bool hasErrorAlready = r.RunningError != null; r.RunningError = error; if (!hasErrorAlready) { Update(error.Culprit.PluginId, r); } }
public PlotData fromBacklogReport(FinalResult FINAL, int stepBacklogTime, DateTime startDate) { var backlogTimePlot = new PlotData(); backlogTimePlot.DataName = "Перцентиль по backlogTime"; backlogTimePlot.Periods = new List <Period>(); for (DateTime date = startDate; date < DateTime.Today; date = date.AddMonths(1)) { if (date.AddMonths(stepBacklogTime) > DateTime.Today) { break; } else { var period = new Period(); period.items = new List <ResultItem>(); period.startDate = date; period.endDate = date.AddMonths(stepBacklogTime); List <ResultItem> backlogTimeList = new List <ResultItem>(); foreach (ResultItem i in FINAL.resultItems) { if (i.value[0].fields.ActivatedDate != null && DateTime.Parse(i.value[0].fields.ActivatedDate) < date.AddMonths(stepBacklogTime) && DateTime.Parse(i.value[0].fields.ActivatedDate) >= date) { //if (i.value[0].backlogTime != 0) //{ period.items.Add(i); // backlogTimeList.Add(i.value[0].backlogTime); //} } } period.items = period.items.OrderBy(o => o.value[0].backlogTime).ToList(); var percentil = Math.Round(period.items.Count * 0.8, 1); if (percentil != 0 && percentil > 1) { var date1 = date; var date2 = date.AddMonths(3); var percentilFraction = Math.Round(percentil - (int)percentil, 1); var TaskDeltaForPercentil = period.items[(int)percentil].value[0].backlogTime - period.items[(int)percentil - 1].value[0].backlogTime; var percentilResult = period.items[(int)percentil - 1].value[0].backlogTime + (TaskDeltaForPercentil * percentilFraction); //значение по перцентилю, которое, помимо целой части, учитывает дробную часть перцентиля period.percentilBacklogTime = (int)Math.Round(percentilResult); } backlogTimePlot.Periods.Add(period); } } return(backlogTimePlot); }
public ActionResult HotelsWebService() { // EXERCISE #2 CODE HERE //Rest of work done in above 3 methods, in XMLResult.cs File in Model, and in HotelWebService.cshtml in Views/Home int hotelId = 105304; FinalResult hotelResult = new FinalResult(); hotelResult = InvokeRequest(hotelId); ViewData["HotelResult"] = hotelResult; return(View()); }
public void DisplayFinalResult(FinalResult result, MedalRow.MedalType[] medalTypes) { var text = result.ToString().ToUpper(); transform.Find("FinalResult").GetComponent <Text>().text = text; var medalRows = transform.GetComponentsInChildren <MedalRow>(); var i = 0; foreach (var medalType in medalTypes) { medalRows[i++].SetMedalType(medalType); } }
void UpdateAll() { foreach (var e in _final) { FinalResult r = e.Value; if (e.Key is Guid) { Update((Guid)e.Key, r); } else { Update((string)e.Key, r); } } }
/// <summary> /// Initialize the internal count of differences and set RunningConfiguration.IsDirty accordingly. /// </summary> internal void Initialize() { Debug.Assert(_nbFinalDifferFromRunning == 0); foreach (var c in _runner.ConfigManager.SolvedPluginConfiguration) { FinalResult r = new FinalResult(); _final.Add(c.PluginId, r); Debug.Assert(r.FinalStatus == r.RunningStatus, "At creation time, they both are Optional."); if (r.UpdatePlugin(c.PluginId, _runnerDisabled, _runner.ConfigManager.SolvedPluginConfiguration, _layers, _runner.Discoverer)) { Debug.Assert(r.FinalStatus != r.RunningStatus, "If FinalStatus changed, then it necessarily differs from RunningStatus."); ++_nbFinalDifferFromRunning; } } _runner.SetDirty(_nbFinalDifferFromRunning > 0); }
public HttpResponseMessage Post([FromBody] ListsToCompare listsToCompare) { FinalResult ComparisonResult = new FinalResult(); try { ICommon common = new Common(); ComparisonResult = common.getCompareResult(listsToCompare); ComparisonResult.Message = "Result generated successfully"; } catch (Exception ex) { ComparisonResult.Message = "Could not generate result, exception occured " + ex.InnerException; } return(Request.CreateResponse <FinalResult>(HttpStatusCode.OK, ComparisonResult)); }
public List <FinalResult> GetResult(string randomNumber, string userInput) { char[] splitRandomNumber = randomNumber.ToCharArray(); char[] splitUserInput = userInput.ToCharArray(); List <FinalResult> results = new List <FinalResult>(); for (int index = 0; index < randomNumber.Length; index++) { FinalResult result = new FinalResult(); var isPlusMinus = false; if (splitRandomNumber[index] == splitUserInput[index]) { result.Index = index; result.Flag = splitRandomNumber[index] == splitUserInput[index]; result.Answer = "+"; results.Add(result); isPlusMinus = true; } else { for (int j = 0; j < 4; j++) { if (splitRandomNumber[index] == splitUserInput[j] && index != j) { result.Index = index; result.Flag = false; result.Answer = "-"; results.Add(result); isPlusMinus = true; break; } } } // if nothing is matched printing empty string. if (!isPlusMinus) { result.Index = index; result.Answer = " "; results.Add(result); } } return(results); }
//Calculates the Total value of all boxes /// <summary> /// Calculates the Total value of all boxes /// </summary> /// <returns> /// Total calculated value /// </returns> public string GetCheckoutValue() { decimal FinalResult; //this if else statment is to prevent bugs with the + and - for the total value if (decimal.Parse(Allbalance.Text) < 0) { FinalResult = decimal.Parse(Allbalance.Text) + decimal.Parse(CountedCash.Text); return(CheckOut.Text = FinalResult.ToString()); } else { FinalResult = decimal.Parse(Allbalance.Text) - decimal.Parse(CountedCash.Text); return(CheckOut.Text = FinalResult.ToString()); } }
public FinalizerEngine(string team1Name, string team2Name) { if (string.IsNullOrWhiteSpace(team1Name)) { Logger.Error("FinalizerEngine team 1 name invalid."); } if (string.IsNullOrWhiteSpace(team2Name)) { Logger.Error("FinalizerEngine team 2 name invalid."); } _finalResult = new FinalResult() { Team1 = team1Name, Team2 = team2Name }; }
public ViewResult FinalResults() { if (IsLogged()) { return(View("Redirect")); } if (Session["EventTypeSelected"] == null) { GetDataForIndex(); return(View("Index", fashionFlavorRepository.GetAll())); } IList <FashionFlavor> flavors = Session["FashionFlavorSelected"] as List <FashionFlavor>; IList <EventType> eventTypes = Session["EventTypeSelected"] as List <EventType>; FinalResult finalResult = new FinalResult(flavors, eventTypes); return(View(finalResult)); }
public override void OnEnterState(LogicManager logicManager) { base.OnEnterState(logicManager); m_FinalResultDisplay.gameObject.SetActive(true); string toPrint = logicManager.CurrentSessionInfo.ToString(); print(toPrint); float finalR = 0.0f; float finalG = 0.0f; float finalB = 0.0f; string finalResultName = ""; foreach (Ingredient i in logicManager.CurrentSessionInfo.IngredientsOfSession) { finalR += i.m_Color.r; finalG += i.m_Color.g; finalB += i.m_Color.b; finalResultName += i.m_Name.Substring(0, 3); } finalResultName += "-Cocktail"; finalR /= logicManager.CurrentSessionInfo.IngredientsOfSession.Length; finalG /= logicManager.CurrentSessionInfo.IngredientsOfSession.Length; finalB /= logicManager.CurrentSessionInfo.IngredientsOfSession.Length; FinalResult finalResult = new FinalResult(); finalResult.m_Color = new Color(finalR, finalG, finalB); finalResult.m_Name = finalResultName; finalResult.m_Foam = logicManager.CurrentSessionInfo.MotionOfSession.m_FinalDisplaySprite; finalResult.m_FoamColor = logicManager.CurrentSessionInfo.MotionOfSession.m_FoamColor; m_FinalResultDisplay.DisplayFinalResult(finalResult); // Example of how to start the coroutine to leave the state after a set amount of seconds. StartCoroutine(LeaveAfterDisplayingResult()); }
public PlotData formTaskReport(FinalResult FINAL, DateTime startDate) { //DateTime startDate = new DateTime(2018, 3, 1); int step = 1; var plot = new PlotData(); plot.DataName = "Сколько берется в работу"; plot.Periods = new List <Period>(); for (DateTime date = startDate; date < DateTime.Today; date = date.AddMonths(step)) { //создаём объект типа период, в который будем включать таски, попавшие в промежуток startDate/endDate var period = new Period(); period.items = new List <ResultItem>(); period.startDate = date; period.endDate = date.AddMonths(step); //Определяем сколько таск было создано/закрыто/взято в работу в текщий период foreach (ResultItem i in FINAL.resultItems) { if (i.value[0].fields.ActivatedDate != null && DateTime.Parse(i.value[0].fields.ActivatedDate) < date.AddMonths(step) && DateTime.Parse(i.value[0].fields.ActivatedDate) > date) { period.items.Add(i); period.activatedCount++; } if (i.value[0].fields.ClosedDate != null && DateTime.Parse(i.value[0].fields.ClosedDate) < date.AddMonths(step) && DateTime.Parse(i.value[0].fields.ClosedDate) > date) { period.items.Add(i); period.closedCount++; } if (DateTime.Parse(i.value[0].fields.CreatedDate) < date.AddMonths(step) && DateTime.Parse(i.value[0].fields.CreatedDate) > date) { period.items.Add(i); period.createdCount++; } } plot.Periods.Add(period); } return(plot); }
public ActionResult result() { if (Session["id"] == null) { return(RedirectToAction("Login", "IPTSELogin")); } FinalResult objResult = new FinalResult(); FinalResultBLL objGetResult = new FinalResultBLL(); objResult = objGetResult.GetFinalResult(Convert.ToInt32(Session["id"])); if (objResult != null) { ViewBag.TotalQuestion = objResult.TotalQuestion; ViewBag.MarksObtained = objResult.MarksObtained; ViewBag.MarksPercentage = objResult.MarksPercentage; ViewBag.TotalMarks = objResult.TotalMarks; ViewBag.msg = "You have successfully completed the exam. Please find the exam details below."; return(View("result")); } return(View()); }
public MatchController(HicoreSocket socket) { this._socket = socket; _socket.On(isMatchInProgressEvent, res => { OnIsMatchInProgressResult(new Result(res.Text)); }); _socket.On(joinToMatchEvent, res => { OnJoinToMatchResult(new Result(res.Text)); }); _socket.On(leaveMatchEvent, res => { OnLeaveMatch(new Result(res.Text)); }); _socket.On(endOfMatchEvent, res => { JSONNode jsonRes = JSON.Parse(res.Text); FinalResult result = new FinalResult(); result.Message = jsonRes["msg"].Value; result.Data = jsonRes["data"]; OnEnd(result); }); }
public FinalResult getCompareResult(ListsToCompare compareList) { FinalResult ComparisonResult = new FinalResult(); try { if (compareList != null && compareList.Current != null && compareList.Initial != null) { List <BaseList> initial = new List <BaseList>(); List <BaseList> current = new List <BaseList>(); initial = compareList.Initial; current = compareList.Current; //new items to show with the newList list object List <BaseList> newList = current.Where(n => !initial.Any(o => o.Key == n.Key)).ToList(); //updated items to show with the updatedList list object List <BaseList> updatedList = current.Where(u => initial.Any(o => o.Key == u.Key && o.Value != u.Value)).ToList(); //deleted items to show with the deletedList list object List <BaseList> deletedList = initial.Where(d => !current.Any(o => o.Key == d.Key)).ToList(); ComparisonResult.NewItems = newList; ComparisonResult.UpdatedItems = updatedList; ComparisonResult.DeletedItems = deletedList; ComparisonResult.Message = "Success"; } else { ComparisonResult.Message = "Please provide valid input.."; } } catch (Exception e) { ComparisonResult.Message = "Internal Error."; } return(ComparisonResult); //Request.CreateResponse<SortedCompareList>(HttpStatusCode.OK, ComparisonResult); }
private void AddData(FinalResult result) { const int precision = 10; int rowNum = 2; foreach (var iterationResult in result.Results) { var currentRow = _sheet.GetRow(rowNum); InsertCell(currentRow, _offset, Math.Round(iterationResult.LengthRatio, precision), _percentageCellStyle, CellType.Numeric); InsertCell(currentRow, _offset + 1, Math.Round(iterationResult.From, precision), _borderedCellStyle, CellType.Numeric); InsertCell(currentRow, _offset + 2, Math.Round(iterationResult.To, precision), _borderedCellStyle, CellType.Numeric); InsertCell(currentRow, _offset + 3, Math.Round(iterationResult.Res1, precision), _borderedCellStyle, CellType.Numeric); InsertCell(currentRow, _offset + 4, Math.Round(iterationResult.Res2, precision), _borderedCellStyle, CellType.Numeric); rowNum++; } }
public List <ResultItem> getItemInfo(ResultItem finalResult, Report result, FinalResult FINAL) { for (int i = 0; i < result.workItems.Count; i++) { string myParameters = "?ids=" + result.workItems[i].Id + "&" + "fields=" + "System.Id,System.CreatedDate,System.IterationPath,System.WorkItemType,System.Title,System.AssignedTo,System.State,System.AreaPath,System.Tags,Microsoft.VSTS.Common.ActivatedDate,Microsoft.VSTS.Common.ClosedDate&" + "api-version=" + "3.0"; string strReturn = null; try { HttpWebRequest WebReq = (HttpWebRequest)WebRequest.Create("https://tfs.tele2.ru/tfs/Main/_apis/wit/workitems" + myParameters); WebReq.Credentials = new NetworkCredential("service.crm.tfs", "$93aCZApFsW"); //Set method to post, otherwise postvars will not be used WebReq.Method = "GET"; WebReq.ContentType = "application/x-www-form-urlencoded"; //Get the response handle, we have no true response yet HttpWebResponse WebResp = (HttpWebResponse)WebReq.GetResponse(); string server = WebResp.Server; //read the response Stream WebResponse = WebResp.GetResponseStream(); StreamReader _response = new StreamReader(WebResponse); strReturn = _response.ReadToEnd(); strReturn = strReturn.Replace("System.", ""); strReturn = strReturn.Replace("Microsoft.VSTS.Common.", ""); finalResult = JsonConvert.DeserializeObject <ResultItem>(strReturn); } catch (Exception ex) { string MessageText = ex.Message; } FINAL.resultItems.Add(finalResult); } return(FINAL.resultItems); }
/// <summary> /// Computes the Results - orders by best lap time /// </summary> public void ComputeResults() { _logger.LogDebug("Computing results"); if (_result == null) { _logger.LogWarning("ComputeResults: results object is null, cannot computer"); StatusMessage = "Unable to compute results"; return; } //var racers = _result.LeaderBoardLines.OrderBy(t => t.Timing.BestLap).ToList(); var racers = _result.LeaderBoardLines; var racersLength = racers.Count; for (var i = 0; i < racersLength; i++) { var racer = racers[i]; var finalResult = new FinalResult { Position = i, Name = $"{racer.CurrentDriver.FirstName.Trim()} {racer.CurrentDriver.LastName.Trim()}", RaceNumber = racer.Car.RaceNumber, CarModel = GetCarModel(racer.Car.CarModel), LapCount = racer.Timing.LapCount, BestLap = TimeSpan.FromMilliseconds(racer.Timing.BestLap).ToString(), TotalTime = racer.Timing.TotalTime }; _logger.LogDebug($"ComputeResults: finalResult[{finalResult}]"); _finalResults.Add(finalResult); } StatusMessage = "Successfully ordered"; }
public bool SaveData(FinalResult final) { try { DateTime dt = DateTime.Now; IWorkbook workbook = null; string file = excelPath + "\\" + dt.ToString("yyyy-MM-dd") + ".xls"; if (!Directory.Exists(excelPath)) { Directory.CreateDirectory(excelPath); //使用Directory类的CreateDirectory方法创建文件夹 } if (!File.Exists(file)) { File.Copy(Application.StartupPath + "\\" + "DATA.xls", file); } string fileExt = Path.GetExtension(file).ToLower(); using (FileStream fs = File.Open(file, FileMode.OpenOrCreate, FileAccess.ReadWrite)) { if (fileExt == ".xlsx") { workbook = new XSSFWorkbook(fs); } else { workbook = new HSSFWorkbook(fs); } //fileExt == ".xls" ISheet sheet = workbook.GetSheet("Sheet1"); IRow row0 = sheet.GetRow(0); //第一行 int cellcount = row0.LastCellNum; //列数 int rowcount = sheet.LastRowNum; //行数 不包含标题行 IRow row = sheet.CreateRow(rowcount + 1); ICell cell0 = row.CreateCell(0); ICell cell1 = row.CreateCell(1); ICell cell2 = row.CreateCell(2); ICell cell3 = row.CreateCell(3); ICell cell4 = row.CreateCell(4); ICell cell5 = row.CreateCell(5); ICell cell6 = row.CreateCell(6); ICell cell7 = row.CreateCell(7); cell0.SetCellValue(final.CodeIndex); cell1.SetCellValue(final.TestMode); cell2.SetCellValue(final.TestStatus); cell3.SetCellValue(final.Alarm); cell4.SetCellValue(final.PressureValue + final.PressureUnit); cell5.SetCellValue(final.LeakValue + final.LeakUnit); cell6.SetCellValue(final.Result); cell7.SetCellValue(final.Product); } using (FileStream fs = File.OpenWrite(file)) { workbook.Write(fs);//向打开的这个xls文件中写入数据 } } catch (Exception ex) { return(false); } return(true); }
public PlotSet errorBercutWithOther(DateTime startDate, int stepBacklogTime, int stepLeadTime) { #region Запрос номеров таск из TFS, удовлетворяющих запросу var httpWebRequest = (HttpWebRequest)WebRequest.Create("https://tfs.tele2.ru/tfs/Main/Tele2/_apis/wit/wiql?api-version=3.0"); httpWebRequest.Method = "POST"; httpWebRequest.Credentials = new NetworkCredential("user", "password"); httpWebRequest.ContentType = "application/json; charset=utf-8; api-version=3.0"; using (var streamWriter = new StreamWriter(httpWebRequest.GetRequestStream())) { string ErrorBercutWithOther = "{" + "\"query\":" + "\"" + "select[System.Id], " + "[System.CreatedDate], " + "[Microsoft.VSTS.Common.ActivatedDate], " + "[Microsoft.VSTS.Common.ClosedDate], " + "[System.WorkItemType], " + "[System.Title], " + "[System.State], " + "[System.AreaPath], " + "[System.IterationPath], " + "[System.Tags] from WorkItems where " + "[System.TeamProject] = @project and " + "([System.WorkItemType] = 'Ошибка' and " + "[System.CreatedBy] in " + @"('Гордеев Александр Валериевич <T2RU\\a.gordeev>', " + @"'Муратов Михаил Александрович <T2RU\\mikhail.muratov>', " + @"'Юренков Станислав Сергеевич <T2RU\\supp.Dynamics21>', " + @"'Евланов Сергей Леонидович <T2RU\\sergey.evlanov>', " + @"'Семенов Антон Юрьевич <T2RU\\anton.y.semenov>', " + @"'Кораблёва Екатерина Викторовна <T2RU\\supp.Dynamics11>', " + @"'Иванов Арсений Дмитриевич <T2RU\\Supp.Dynamics02>', " + @"'Анисимов Максим Александрович <T2RU\\supp.Dynamics12>', " + @"'Фокин Андрей Геннадьевич <T2RU\\supp.Dynamics19>', " + @"'Свидэрский Николай Сергеевич <T2RU\\nikolay.svidersky>', " + @"'Панфилова Наталья Геннадьевна <T2RU\\natalya.panfilova>', " + @"'Смирнов Фёдор Леонидович <T2RU\\supp.Dynamics20>', " + @"'Большакова Мария Владимировна <T2RU\\supp.Dynamics17>', " + @"'Чубукина Татьяна Сергеевна <T2RU\\Supp.Dynamics10>', " + @"'Нижников Виталий Сергеевич <T2RU\\vitaly.nizhnikov>', " + @"'Недоступ Александр Николаевич <T2RU\\alexander.nedostup>', " + @"'Курилюк Антон Викторович <T2RU\\anton.kurilyuk>', " + @"'Бондарчук Евгений Маркович <T2RU\\Supp.Dynamics08>', " + @"'Чистяков Максим Сергеевич <T2RU\\supp.Dynamics18>', " + @"'Манукян Ашот Каренович <T2RU\\ashot.manukyan>', " + @"'Моисеева Ольга Алексеевна <T2RU\\supp.DSuite29>', " + @"'Струнников Артем Сергеевич <T2RU\\supp.bercut120>', " + @"'Калашников Дмитрий Юрьевич <T2RU\\dmitry.y.kalashnikov>', " + @"'Полях Виктор Васильевич <T2RU\\victor.polyakh>', " + @"'Глушков Сергей Иванович <T2RU\\Supp.Dynamics05>', " + @"'Остапенко Сергей Сергеевич <T2RU\\sergey.ostapenko>', " + @"'Жиряков Дмитрий Владимирович <T2RU\\supp.Dynamics15>', " + @"'Тришечкин Евгений Владимирович <T2RU\\Supp.Dynamics06>', " + @"'Хромина Ольга Анатольевна <T2RU\\olga.khromina>', " + @"'Арсеньева Юлия Андреевна <T2RU\\supp.Dynamics16>', " + @"'Артюков Иван Алексеевич <T2RU\\Supp.Dynamics03>', " + @"'Сибакова Евгения Александровна <T2RU\\evgenia.sibakova>', " + @"'Хрупин Дмитрий Владимирович <T2RU\\dmitry.khrupin>', " + @"'Сологуб Николай Сергеевич <T2RU\\Supp.Dynamics24>') and " + @"[System.AreaPath] in ('Tele2\\Партнеры\\Беркут\\Product testing') and " + "[System.Reason] <> 'Не является ошибкой' and " + "[System.Reason] <> 'Отклонена' and " + "not [System.Tags] contains 'Техническое' and " + "[System.Tags] contains 'Other' or " + "([System.WorkItemType] = 'Ошибка' and " + @"[System.AreaPath] = 'Tele2\\CRM\\CRM Team Bercut' and " + "[System.Reason] <> 'Отклонена' and " + "[System.Reason] <> 'Не является ошибкой' and " + "[System.Tags] contains 'Other' and " + "not [System.Tags] contains 'Техническое')) " + "order by[Microsoft.VSTS.Common.ClosedDate] " + "\"" + "}"; streamWriter.Write(ErrorBercutWithOther); streamWriter.Flush(); streamWriter.Close(); } var httpResponse = (HttpWebResponse)httpWebRequest.GetResponse(); dynamic resultOfQuery; using (var streamReader = new StreamReader(httpResponse.GetResponseStream())) { resultOfQuery = streamReader.ReadToEnd(); } Report result = JsonConvert.DeserializeObject <Report>(resultOfQuery); #endregion FinalResult FINAL = new FinalResult(); FINAL.resultItems = new List <ResultItem>(); ResultItem finalResult = new ResultItem(); ItemInfoHelper itemInfoHelper = new ItemInfoHelper(); FINAL.resultItems = itemInfoHelper.getItemInfo(finalResult, result, FINAL); //Считаем LeadTime и BackLogTime для каждой таски foreach (ResultItem i in FINAL.resultItems) { if (i.value[0].fields.ActivatedDate != null && i.value[0].fields.CreatedDate != null) { i.value[0].backlogTime = (int)(DateTime.Parse(i.value[0].fields.ActivatedDate) - DateTime.Parse(i.value[0].fields.CreatedDate)).TotalDays; } if (i.value[0].fields.ClosedDate != null && i.value[0].fields.ActivatedDate != null) { i.value[0].leadTime = (int)(DateTime.Parse(i.value[0].fields.ClosedDate) - DateTime.Parse(i.value[0].fields.ActivatedDate)).TotalDays; } } TaskReportHelper taskReportHelper = new TaskReportHelper(); BacklogReportHelper backlogReportHelper = new BacklogReportHelper(); LeadReportHelper leadReportHelper = new LeadReportHelper(); PlotSet plotResult = new PlotSet(); plotResult.PlotList = new List <PlotData>(); plotResult.PlotList.Add(taskReportHelper.formTaskReport(FINAL, startDate)); plotResult.PlotList.Add(backlogReportHelper.fromBacklogReport(FINAL, stepBacklogTime, startDate)); plotResult.PlotList.Add(leadReportHelper.formLeadReport(FINAL, stepLeadTime, startDate)); return(plotResult); }