public static AdsPerformance[] FetchPerformance(DataRow[] rows) { if (0 == rows.Length) { throw new Exception("These records you find do not exist!"); } AdsPerformance[] adPerformances = new AdsPerformance[rows.Length]; for (int i = 0; i < rows.Length; i++) { adPerformances[i].CampaignName = rows[i].Field<string>("CampaignName"); adPerformances[i].AdName = rows[i].Field<string>("AdName"); adPerformances[i].Impressions = rows[i].Field<string>("Impressions"); adPerformances[i].Reach = rows[i].Field<string>("Reach"); adPerformances[i].Freq = rows[i].Field<string>("Freq"); adPerformances[i].SocialReach = rows[i].Field<string>("SocialReach"); adPerformances[i].Connections = rows[i].Field<string>("Connections"); adPerformances[i].Clicks = rows[i].Field<string>("Clicks"); adPerformances[i].CTR = rows[i].Field<string>("CTR"); adPerformances[i].CPC = rows[i].Field<string>("CPC"); adPerformances[i].CPM = rows[i].Field<string>("CPM"); adPerformances[i].Spent = rows[i].Field<string>("Spent"); adPerformances[i].Conversions = rows[i].Field<string>("Conversions"); adPerformances[i].CPA = rows[i].Field<string>("CPA"); adPerformances[i].ConversionRate = rows[i].Field<string>("ConversionRate"); } return adPerformances; }
public static AdsPerformance[] Parse(List<WinRow> rows) { if (rows[0].Cells.Count != 27) { throw new Exception("The count of cell in keyword grid should be equal to 27!"); } int startIndex = 14; AdsPerformance[] adPerformances = new AdsPerformance[rows.Count]; for (int i = 0; i < rows.Count; i++) { startIndex = 14; adPerformances[i].CampaignName = GridViewUtilities.GetValueProperty(rows[i].Cells[2]); adPerformances[i].AdName = GridViewUtilities.GetValueProperty(rows[i].Cells[3]); adPerformances[i].Impressions = GridViewUtilities.GetValueProperty(rows[i].Cells[startIndex]); adPerformances[i].Reach = GridViewUtilities.GetValueProperty(rows[i].Cells[++startIndex]); adPerformances[i].Freq = GridViewUtilities.GetValueProperty(rows[i].Cells[++startIndex]); adPerformances[i].SocialReach = GridViewUtilities.GetValueProperty(rows[i].Cells[++startIndex]); adPerformances[i].Connections = GridViewUtilities.GetValueProperty(rows[i].Cells[++startIndex]); adPerformances[i].Clicks = GridViewUtilities.GetValueProperty(rows[i].Cells[++startIndex]); adPerformances[i].CTR = GridViewUtilities.GetValueProperty(rows[i].Cells[++startIndex]); adPerformances[i].CPC = GridViewUtilities.GetValueProperty(rows[i].Cells[++startIndex]); adPerformances[i].CPM = GridViewUtilities.GetValueProperty(rows[i].Cells[++startIndex]); adPerformances[i].Spent = GridViewUtilities.GetValueProperty(rows[i].Cells[++startIndex]); adPerformances[i].Conversions = GridViewUtilities.GetValueProperty(rows[i].Cells[++startIndex]); adPerformances[i].CPA = GridViewUtilities.GetValueProperty(rows[i].Cells[++startIndex]); adPerformances[i].ConversionRate = GridViewUtilities.GetValueProperty(rows[i].Cells[++startIndex]); } return adPerformances; }