public async Task <IActionResult> PutGeneResult(int id, GeneResult geneResult) { if (id != geneResult.Id) { return(BadRequest()); } _context.Entry(geneResult).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!GeneResultExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <ActionResult <GeneResult> > PostGeneResult(GeneResult geneResult) { _context.GeneResults.Add(geneResult); await _context.SaveChangesAsync(); return(CreatedAtAction("GetGeneResult", new { id = geneResult.Id }, geneResult)); }
private void renderGeneData(ExcelPackage package) { var allData = _context.GeneResults.ToList(); ExcelWorksheet workSheet = package.Workbook.Worksheets[1]; if (workSheet == null) return; //var workSheet = package.Workbook.Worksheets.First(); int totalRows = workSheet.Dimension.Rows; //var DataList = new List<Customers>(); for (int i = 2; i <= totalRows; i++) { { GeneResult geneResult = new GeneResult { GeneName = workSheet.Cells[i, 1].Value.ToString(), Result = Int32.Parse(workSheet.Cells[i, 2].Value.ToString()), Text = workSheet.Cells[i, 3].Value.ToString(), }; var entryToMod = allData.SingleOrDefault(i => i.GeneName == geneResult.GeneName && i.Result == geneResult.Result); if (entryToMod == null) { _context.GeneResults.Add(geneResult); } else { if (entryToMod.Text != geneResult.Text) { entryToMod.Text = geneResult.Text; _context.Entry(entryToMod).State = EntityState.Modified; } } } } _context.SaveChanges(); }
private void WriteMetadata(Excel.Worksheet worksheet, GeneResult result) { worksheet.Cells[1, 7] = "LogPValue"; worksheet.Cells[2, 7] = -Math.Log10(result.Estimate.PValue); worksheet.Cells[1, 8] = "FDR"; worksheet.Cells[2, 8] = result.FDR; worksheet.ListObjects.Add(Excel.XlListObjectSourceType.xlSrcRange, worksheet.Range["G1:H2"], Type.Missing, Excel.XlYesNoGuess.xlYes, Type.Missing); }
private void WriteData(Excel.Worksheet worksheet, GeneResult result) { var groupAEvents = result.Estimate.GroupAEvents; var groupBEvents = result.Estimate.GroupBEvents; int currentTime = Math.Min(groupAEvents[0].Time, groupBEvents[0].Time); worksheet.Cells[2, 1] = (currentTime - 1).ToString(); worksheet.Cells[2, 2] = "1"; worksheet.Cells[2, 3] = "1"; int iA = 0, iB = 0, currentRow = 3; while (iA < groupAEvents.Count && iB < groupBEvents.Count) { currentTime = Math.Min(groupAEvents[iA].Time, groupBEvents[iB].Time); int failingA = (groupAEvents[iA].Time == currentTime ? groupAEvents[iA].NumberFailing : 0); int failingB = (groupBEvents[iB].Time == currentTime ? groupBEvents[iB].NumberFailing : 0); if (failingA + failingB != 0) { worksheet.Cells[currentRow, 1] = currentTime.ToString(); worksheet.Cells[currentRow, 2] = worksheet.Cells[currentRow - 1, 2]; worksheet.Cells[currentRow, 3] = worksheet.Cells[currentRow - 1, 3]; currentRow++; worksheet.Cells[currentRow, 1] = currentTime.ToString(); worksheet.Cells[currentRow, 2] = failingA == 0 ? worksheet.Cells[currentRow - 1, 2] : groupAEvents[iA].SurvivalProbability; worksheet.Cells[currentRow, 3] = failingB == 0 ? worksheet.Cells[currentRow - 1, 3] : groupBEvents[iB].SurvivalProbability; currentRow++; } if (groupAEvents[iA].Time == currentTime) { iA++; } if (groupBEvents[iB].Time == currentTime) { iB++; } } while (iA < groupAEvents.Count) { currentTime = groupAEvents[iA].Time; int failingA = groupAEvents[iA].NumberFailing; if (failingA != 0) { worksheet.Cells[currentRow, 1] = currentTime.ToString(); worksheet.Cells[currentRow, 2] = worksheet.Cells[currentRow - 1, 2]; worksheet.Cells[currentRow, 3] = worksheet.Cells[currentRow - 1, 3]; currentRow++; worksheet.Cells[currentRow, 1] = currentTime.ToString(); worksheet.Cells[currentRow, 2] = groupAEvents[iA].SurvivalProbability; worksheet.Cells[currentRow, 3] = worksheet.Cells[currentRow - 1, 3]; currentRow++; } iA++; } while (iB < groupBEvents.Count) { currentTime = groupBEvents[iB].Time; int failingB = groupBEvents[iB].NumberFailing; if (failingB != 0) { worksheet.Cells[currentRow, 1] = currentTime.ToString(); worksheet.Cells[currentRow, 2] = worksheet.Cells[currentRow - 1, 2]; worksheet.Cells[currentRow, 3] = worksheet.Cells[currentRow - 1, 3]; currentRow++; worksheet.Cells[currentRow, 1] = currentTime.ToString(); worksheet.Cells[currentRow, 2] = worksheet.Cells[currentRow - 1, 2]; worksheet.Cells[currentRow, 3] = groupBEvents[iB].SurvivalProbability; currentRow++; } iB++; } worksheet.ListObjects.Add(Excel.XlListObjectSourceType.xlSrcRange, worksheet.UsedRange, Type.Missing, Excel.XlYesNoGuess.xlYes, Type.Missing); }