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