Advertisement
Guest User

Untitled

a guest
Jul 24th, 2014
208
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.70 KB | None | 0 0
  1. "name":"aaa_aaaurf","region":"Financial & Risk - ALL","checkins":[[1,"0"],[2,"0"],[3,"3"],[4,"0"],[5,"0"],[6,"0"],[7,"0"],[8,"0"],[9,"0"],[10,"0"],[11,"0"],[12,"2"]],"teamsize":[[1,"2"],[2,"2"],[3,"2"],[4,"2"],[5,"0"],[6,"0"],[7,"0"],[8,"0"],[9,"0"],[10,"0"],[11,"3"],[12,"3"]],"Checkintimes":[[1,"0"],[2,"0"],[3,"0"],[4,"0"],[5,"0"],[6,"0"],[7,"0"],[8,"0"],[9,"0"],[10,"0"],[11,"0"],[12,"62"]
  2.  
  3. string repository = null;
  4. string tempsbu;
  5. int index=0;
  6. string sbu=null;
  7. List<string> checkins = new List<string>();
  8. List<string> builds = new List<string>();
  9. List<string> teamsize = new List<string>();
  10. List<string> checkintimes = new List<string>();
  11. List<string> Consdata = new List<string>();
  12.  
  13. string CSVFilePathName = @"D:info.csv";
  14. string[] Lines = File.ReadAllLines(CSVFilePathName);
  15. string[] Fields;
  16. Fields = Lines[0].Split(new char[] { ',' });
  17. int Cols = Fields.GetLength(0);
  18. DataTable dt = new DataTable();
  19. //1st row must be column names; force lower case to ensure matching later on.
  20. for (int i = 0; i < Cols; i++)
  21. dt.Columns.Add(Fields[i].ToLower(), typeof(string));
  22. DataRow Row;
  23. for (int i = 1; i < Lines.GetLength(0); i++)
  24. {
  25. Fields = Lines[i].Split(new char[] { ',' });
  26. Row = dt.NewRow();
  27. for (int f = 0; f < Cols; f++)
  28. Row[f] = Fields[f];
  29. dt.Rows.Add(Row);
  30. }
  31.  
  32.  
  33. for (int row = 0; row < dt.Rows.Count; row++)
  34. {
  35. if (row==0)
  36. {
  37. repository = dt.Rows[row]["repository"].ToString();
  38.  
  39. }
  40.  
  41. if (dt.Rows[row]["repository"].ToString() != repository)
  42. {
  43. if ((row > 0) || (row == dt.Rows.Count))
  44. {
  45. index = 1;
  46. Consdata.Add("name:" + repository + "," + "region:" + sbu + "checkins:" + checkins.ToString() + "teamsize:" + teamsize.ToString() + "Checkintimes:" + checkintimes.ToString());
  47. repository = dt.Rows[row]["repository"].ToString();
  48. sbu = dt.Rows[row]["BusinessUnit"].ToString();
  49. checkins.Add("[" + index + "," + dt.Rows[row]["AvgCheckinCount"].ToString() + "]");
  50. checkintimes.Add("[" + index + "," + dt.Rows[row]["MeanBuildTimeHrs"].ToString() + "]");
  51. teamsize.Add("[" + index + "," + dt.Rows[row]["TeamSize"].ToString() + "]");
  52.  
  53.  
  54.  
  55. }
  56. }
  57. else
  58. {
  59. if (row == 0)
  60. {
  61. index = 1;
  62. }
  63. else
  64. {
  65. index = index + 1;
  66. }
  67. repository = dt.Rows[row]["repository"].ToString();
  68. sbu = dt.Rows[row]["BusinessUnit"].ToString();
  69. checkins.Add("[" + index + "," + dt.Rows[row]["AvgCheckinCount"].ToString() + "]");
  70. checkintimes.Add("[" + index + "," + dt.Rows[row]["MeanBuildTimeHrs"].ToString() + "]");
  71. teamsize.Add("[" + index + "," + dt.Rows[row]["TeamSize"].ToString() + "]");
  72. }
  73.  
  74. }
  75.  
  76.  
  77. My csv values are:
  78. repository,modmonth,month,year,MeanBuildTimeHrs,AvgCheckinCount,TeamSize,BusinessUnit
  79. aaa_aaaurf,1,6,2013,0,0,2,Financial & Risk - ALL
  80. aaa_aaaurf,2,7,2013,0,0,2,Financial & Risk - ALL
  81. aaa_aaaurf,3,8,2013,0,3,2,Financial & Risk - ALL
  82. aaa_aaaurf,4,9,2013,0,0,2,Financial & Risk - ALL
  83. aaa_aaaurf,5,10,2013,0,0,0,Financial & Risk - ALL
  84. aaa_aaaurf,6,11,2013,0,0,0,Financial & Risk - ALL
  85. aaa_aaaurf,7,12,2013,0,0,0,Financial & Risk - ALL
  86. aaa_aaaurf,8,1,2014,0,0,0,Financial & Risk - ALL
  87. aaa_aaaurf,9,2,2014,0,0,0,Financial & Risk - ALL
  88. aaa_aaaurf,10,3,2014,0,0,0,Financial & Risk - ALL
  89. aaa_aaaurf,11,4,2014,0,0,3,Financial & Risk - ALL
  90. aaa_aaaurf,12,5,2014,62,2,3,Financial & Risk - ALL
  91. aaa_ecso,1,6,2013,7,12,14,Financial & Risk - ALL
  92. aaa_ecso,2,7,2013,6,37,10,Financial & Risk - ALL
  93. aaa_ecso,3,8,2013,4,32,10,Financial & Risk - ALL
  94. aaa_ecso,4,9,2013,4,57,10,Financial & Risk - ALL
  95. aaa_ecso,5,10,2013,3,49,13,Financial & Risk - ALL
  96. aaa_ecso,6,11,2013,2,62,13,Financial & Risk - ALL
  97. aaa_ecso,7,12,2013,3,41,13,Financial & Risk - ALL
  98. aaa_ecso,8,1,2014,2,51,16,Financial & Risk - ALL
  99. aaa_ecso,9,2,2014,2,54,16,Financial & Risk - ALL
  100. aaa_ecso,10,3,2014,2,56,16,Financial & Risk - ALL
  101. aaa_ecso,11,4,2014,3,31,16,Financial & Risk - ALL
  102. aaa_ecso,12,5,2014,0,38,16,Financial & Risk - ALL
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement