public static SamplingModel GetSampleById(Guid id)
{
DataRow dr = SQLHelper.getDataRow(ConnectionString, "GetSamplesById", id);
SamplingModel sampleObj = new SamplingModel();
Common.DataRow2Object(dr, sampleObj);
return(sampleObj);
}
public static SamplingModel GetSampleBySampleCode(string sampleCode)
{
DataRow dr = SQLHelper.getDataRow(ConnectionString, "GetSamplesBySampleCode", sampleCode);
SamplingModel sampleObj = new SamplingModel();
Common.DataRow2Object(dr, sampleObj);
return(sampleObj);
}
public static List <SamplingModel> GetSamples(Guid warehouseId, string TrackNo, string SampleCode, int status)
{
List <SamplingModel> sampleList = new List <SamplingModel>();
DataTable dt = SQLHelper.getDataTable(ConnectionString, "GetSamples", warehouseId, SampleCode, status);
foreach (DataRow dr in dt.Rows)
{
SamplingModel o = new SamplingModel();
Common.DataRow2Object(dr, o);
sampleList.Add(o);
}
return(sampleList);
}