//Static Methods public static DataSet ReportAssaysResult(AssayReportViewModel m) { DataSet ds = new DataSet("ReportResult"); using (new TransactionScope(TransactionScopeOption.Suppress)) { var d = new AssaysDataContext(); //////Get Curves var cmd = d.Connection.CreateCommand(); cmd.CommandText = "[dbo].[X_SP_GetAssays]"; cmd.CommandType = CommandType.StoredProcedure; var parm1 = cmd.CreateParameter(); parm1.ParameterName = "@assay_group_projectid"; parm1.DbType = DbType.Guid; parm1.Value = m.ProjectID; cmd.Parameters.Add(parm1); try { //Let's actually run the queries d.Connection.Open(); cmd.CommandTimeout = DBHelper.DefaultTimeout; var reader = cmd.ExecuteReader(); ds.Load(reader, LoadOption.OverwriteChanges, "t"); } finally { d.Connection.Close(); } return ds; } }
public IReport ReportAssays(AssayReportViewModel m) { return AllReports.CreateModel(m); }
public ActionResult ReportAssays(AssayReportViewModel m) { if (!ModelState.IsValid) return ReportAssays(); m.ReportID = (uint)AllReports.ReportType.AssayReport; m.ReportExecutedByUserName = Services.WorkContext.CurrentUser.UserName; IReport r = AssayService.ReportAssays(m); m.Report = r.Report; //m.ReportID = r.ReportID; m.ParametersView = r.ParametersView; m.ReportName = r.ReportName; m.SerializedChild = r.SerializedChild; m.FilterString = r.FilterString; return new XODB.Handlers.FileGeneratingResult(string.Format("{0}-{1}-{2}.csv", m.Project, m.ProjectID, DateHelper.NowInOnlineFormat).Trim(), "text/csv", stream => m.Report.ExportToCsv(stream)); }
public async Task<IReport> ReportAssaysAsync(AssayReportViewModel m) { return await Task<IReport>.Run(() => ReportAssays(m)); }
public ActionResult ReportAssays() { var model = new AssayReportViewModel { Report = AllReports.GetReport(AllReports.ReportType.AssayReport), Projects = ProjectService.GetProjectList() }; return View(model); }