public static void PopulateInCollectionFromExcel(string FileName, int TeamId)
{
//get the path of the file passed as parameter
string path = Path.GetFullPath(FileName);
automateData.Clear();
//Start reading the data and populating the in memory list
DataTable table = ReadDataFromExcel(FileName);
for (int row = 0; row < table.Rows.Count; row++)
{
try
{
var record = new AutomateData();
record.ProductArea = table.Rows[row][0].ToString();
if (record.ProductArea == "")
{
continue;
}
record.NoOfTFSTestcase = int.Parse(table.Rows[row][1].ToString());
record.NoOfAutomatedTestcases = int.Parse(table.Rows[row][2].ToString());
record.NoOfTestCasesDebugged = int.Parse(table.Rows[row][3].ToString());
record.TeamId = TeamId;
record.date = GetPreviousFriday(DateTime.Now).AddDays(7);
if (TeamId == 1)
{
record.ExpectedTestCases = int.Parse(table.Rows[row][4].ToString());
}
else
{
record.ExpectedTestCases = 0;
}
automateData.Add(record.ProductArea, record);
}
catch
{
Debug.WriteLine("DataRow Not in Correct Format");
}
}
}
public AutomationTeamModel(int TeamId)
{
var db = new AutomationDashboardEntities();
automateData = db.AutomateDatas.Where(e => e.TeamId == TeamId).First();
}