public static DataSet GetReportData(string session, string sample, string ClassValue)
{
EvolutionDBFacade.EvolutionDBFacade.DBFacade dBFacade = new EvolutionDBFacade.EvolutionDBFacade.DBFacade();
DataSet dr;
using (AbDALDataContext abDAL = new AbDALDataContext(dBFacade.GetConn()))
{
var conn = dBFacade.GetConn();
try
{
Dictionary <string, object> param = new Dictionary <string, object>();
param.Add("batchID", session);
param.Add("sampleID", sample);
dr = dBFacade.ExecuteProc("GetSampleForLoad", param);
}
finally
{
if (conn.State != ConnectionState.Closed)
{
conn.Close();
}
}
}
return(dr);
}
/// <summary>
/// search for run date between the to and from date parameters
/// </summary>
/// <param name="from"></param>
/// <param name="to"></param>
/// <returns></returns>
public static string SearchbyDate(DateTime fromdt, DateTime todt)
{
EvolutionDBFacade.EvolutionDBFacade.DBFacade dBFacade = new EvolutionDBFacade.EvolutionDBFacade.DBFacade();
string returnValue;
using (AbDALDataContext abDAL = new AbDALDataContext(dBFacade.GetConn()))
{
List <BatchResults> dr = (from item in abDAL.tbAntibodyMethods
where item.runDate >= fromdt &&
item.runDate < todt
select new BatchResults {
sessionid = item.sessionID,
sampleid = item.sampleID,
runDate = item.runDate
}).ToList();
returnValue = JsonConvert.SerializeObject(dr);
}
return(returnValue);
}
public static List <string> GetSortedAntigens(List <string> listofAntigens)
{
StringBuilder sb = new StringBuilder();
List <string> ret = new List <string>();
DataSet dr;
EvolutionDBFacade.EvolutionDBFacade.DBFacade dBFacade = new EvolutionDBFacade.EvolutionDBFacade.DBFacade();
foreach (string item in listofAntigens)
{
sb.Append($"'{item}',");
}
if (sb.ToString().Length > 0)
{
using (AbDALDataContext abDAL = new AbDALDataContext(dBFacade.GetConn()))
{
var conn = dBFacade.GetConn();
try
{
string query = $"Select AntigenID,AntigenName,AntigenSortOrder from tbAntigens where antigenName in ({sb.ToString().Remove(sb.ToString().Length - 1)}) order by AntigenSortOrder";
dr = dBFacade.ExecuteSQL(query);
}
finally
{
if (conn.State != ConnectionState.Closed)
{
conn.Close();
}
}
}
foreach (DataRow row in dr.Tables[0].Rows)
{
ret.Add(row["AntigenName"].ToString());
}
}
return(ret);
}
