static List <WorkitemFromExcel> GetWorkItems(System.IO.Compression.ZipArchive zipArchive = null)
{
AttatchmentAdder addAttachment = new AttatchmentAdder(URI, UserPAT);
List <WorkitemFromExcel> workitemlist = new List <WorkitemFromExcel>();
if (DT.Rows.Count > 0)
{
for (int i = 0; i < DT.Rows.Count; i++)
{
DataRow dr = DT.Rows[i];
string ID = dr["ID"].ToString();
if (!string.IsNullOrEmpty(ID))
{
try
{
WorkitemFromExcel item = new WorkitemFromExcel
{
Id = CreateWorkItem(dr)
};
if (zipArchive != null)
{
addAttachment.FindAttachments(Convert.ToInt32(dr["ID"].ToString()), item.Id, zipArchive);
}
dr["ID"] = item.Id.ToString();
/* item.WiState = dr["State"].ToString();
* item.AreaPath = dr["Area Path"].ToString();
* item.Itertation = dr["Iteration Path"].ToString();*/
OldTeamProject = dr["Team Project"].ToString();
int columnindex = 0;
foreach (var col in TitleColumns)
{
if (!string.IsNullOrEmpty(col))
{
if (!string.IsNullOrEmpty(dr[col].ToString()))
{
item.Title = dr[col].ToString();
if (i > 0 && columnindex > 0)
{
item.Parent = GetParentData(DT, i - 1, columnindex);
}
break;
}
}
columnindex++;
}
workitemlist.Add(item);
}
catch
{
return(null);
}
}
}
}
return(workitemlist);
}
public List <WorkitemFromExcel> GetWorkItems()
{
try
{
List <WorkitemFromExcel> workitemlist = new List <WorkitemFromExcel>();
if (DT.Rows.Count > 0)
{
for (int i = 0; i < DT.Rows.Count; i++)
{
DataRow dr = DT.Rows[i];
WorkitemFromExcel item = new WorkitemFromExcel();
if (DT.Rows[i] != null)
{
item.id = createWorkItem(dr);
//("WorkItemPublish Created= " + item.id);
dr["ID"] = item.id.ToString();
int columnindex = 0;
foreach (var col in TitleColumns)
{
if (!string.IsNullOrEmpty(col))
{
if (!string.IsNullOrEmpty(dr[col].ToString()))
{
item.tittle = dr[col].ToString();
if (i > 0 && columnindex > 0)
{
item.parent = getParentData(DT, i - 1, columnindex);
}
break;
}
}
columnindex++;
}
workitemlist.Add(item);
}
}
}
return(workitemlist);
}
catch (Exception E)
{
throw(E);
}
}
