private IList <SiteInstrumentImportData> GetInDataRow(DataSet ds)
{
string regionName;
string testingArea;
string siteName;
string instrumentName;
int quantity;
int percentRun;
int rowno = 0;
bool haserror;
IList <ForlabSite> _referingSites = new List <ForlabSite>();
IList <ForlabSite> _validsites = new List <ForlabSite>();
IList <SiteInstrumentImportData> rdlist = new List <SiteInstrumentImportData>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
rowno++;
haserror = false;
regionName = Convert.ToString(dr[0]).Trim(); //region name
siteName = Convert.ToString(dr[1]).Trim();
testingArea = Convert.ToString(dr[2]).Trim();
instrumentName = Convert.ToString(dr[3]).Trim();
try
{
quantity = int.Parse(Convert.ToString(dr[4]));
}
catch
{ quantity = 1; }
try
{
percentRun = int.Parse(Convert.ToString(dr[5]));
}
catch { percentRun = 100; }
SiteInstrumentImportData rd = new SiteInstrumentImportData(rowno, regionName, siteName, testingArea, instrumentName, quantity, percentRun);
rd.HasError = haserror;
rdlist.Add(rd);
}
return(rdlist);
}
private IList<SiteInstrumentImportData> GetInDataRow(DataSet ds)
{
string regionName;
string testingArea;
string siteName;
string instrumentName;
int quantity;
int percentRun;
int rowno = 0;
bool haserror;
IList<ForlabSite> _referingSites = new List<ForlabSite>();
IList<ForlabSite> _validsites = new List<ForlabSite>();
IList<SiteInstrumentImportData> rdlist = new List<SiteInstrumentImportData>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
rowno++;
haserror = false;
regionName = Convert.ToString(dr[0]).Trim() ; //region name
siteName = Convert.ToString(dr[1]).Trim();
testingArea = Convert.ToString(dr[2]).Trim();
instrumentName = Convert.ToString(dr[3]).Trim();
try
{
quantity = int.Parse(Convert.ToString(dr[4]));
}
catch
{ quantity = 1; }
try
{
percentRun = int.Parse(Convert.ToString(dr[5]));
}
catch { percentRun = 100; }
SiteInstrumentImportData rd = new SiteInstrumentImportData(rowno, regionName, siteName, testingArea, instrumentName, quantity, percentRun);
rd.HasError = haserror;
rdlist.Add(rd);
}
return rdlist;
}
