private IList <ImportTestData> GetDataRow(DataSet ds) { string testName; string groupName; string areaName; string aName = ""; string gName = ""; TestingArea testArea = null; TestingGroup testgroup = null; int rowno = 0; bool haserror; IList <ImportTestData> rdlist = new List <ImportTestData>(); foreach (DataRow dr in ds.Tables[0].Rows) { rowno++; haserror = false; testName = Convert.ToString(dr[0]).Trim(); areaName = Convert.ToString(dr[1]).Trim(); groupName = Convert.ToString(dr[2]).Trim(); if (String.IsNullOrEmpty(groupName)) { groupName = TestingGroup.GetDefaultGroupName; } ImportTestData rd = new ImportTestData(testName, groupName, areaName, rowno); if (aName != areaName) { if (!string.IsNullOrEmpty(areaName)) { testArea = DataRepository.GetTestingAreaByName(areaName); if (testArea == null) { testArea = new TestingArea(); testArea.AreaName = areaName; DataRepository.SaveOrUpdateTestingArea(testArea); } } else { testArea = null; } aName = areaName; } rd.TestArea = testArea; if (testArea != null) { if (gName != groupName) { testgroup = DataRepository.GetTestingGroupByName(testArea.Id, groupName); if (testgroup == null) { testgroup = new TestingGroup(); testgroup.GroupName = groupName; testgroup.TestingArea = testArea; DataRepository.SaveOrUpdateTestingGroup(testgroup); } gName = groupName; } rd.TestGroup = testgroup; if (!string.IsNullOrEmpty(testName)) { rd.IsExist = DataRepository.GetTestByNameAndTestArea(testName, testArea.Id) != null; } else { haserror = true; } } else { haserror = true; } rd.HasError = haserror; rdlist.Add(rd); } return(rdlist); }
private IList<ImportTestData> GetDataRow(DataSet ds) { string testName; string groupName; string areaName; string aName = ""; string gName = ""; TestingArea testArea = null; TestingGroup testgroup = null; int rowno = 0; bool haserror; IList<ImportTestData> rdlist = new List<ImportTestData>(); foreach (DataRow dr in ds.Tables[0].Rows) { rowno++; haserror=false; testName = Convert.ToString(dr[0]).Trim() ; areaName = Convert.ToString(dr[1]).Trim() ; groupName = Convert.ToString(dr[2]).Trim() ; if (String.IsNullOrEmpty(groupName)) groupName = TestingGroup.GetDefaultGroupName; ImportTestData rd = new ImportTestData(testName, groupName, areaName, rowno); if (aName != areaName) { if (!string.IsNullOrEmpty(areaName)) { testArea = DataRepository.GetTestingAreaByName(areaName); if (testArea == null) { testArea = new TestingArea(); testArea.AreaName = areaName; DataRepository.SaveOrUpdateTestingArea(testArea); } } else testArea = null; aName = areaName; } rd.TestArea = testArea; if (testArea != null) { if (gName != groupName) { testgroup = DataRepository.GetTestingGroupByName(testArea.Id, groupName); if (testgroup == null) { testgroup = new TestingGroup(); testgroup.GroupName = groupName; testgroup.TestingArea = testArea; DataRepository.SaveOrUpdateTestingGroup(testgroup); } gName = groupName; } rd.TestGroup = testgroup; if (!string.IsNullOrEmpty(testName)) rd.IsExist = DataRepository.GetTestByNameAndTestArea(testName,testArea.Id) != null; else haserror = true; } else haserror = true; rd.HasError = haserror; rdlist.Add(rd); } return rdlist; }