//public List<countDate> getResult(string messageMOC, string messageMTC, string messageDropCalls) //{ // try // { // List<countDate> count = new List<countDate>(); // countDate cdLocal = new countDate(); // DataView view = new DataView(localDataTable); // DataTable distinctValue = view.ToTable(true, "time"); // DataRow[] timeRows = distinctValue.Select(); // foreach (DataRow r in timeRows) // { // cdLocal = new countDate(); // errorMessage = r[0].ToString(); // cdLocal.date = DateTime.Parse(r[0].ToString()); // DataRow[] dataRowsMOC = localDataTable.Select(string.Format("rrcMsgName = '{0}' AND time = '{1}'", messageMOC, r[0].ToString())); // DataRow[] dataRowsMTC = localDataTable.Select(string.Format("rrcMsgName = '{0}' AND time = '{1}'", messageMTC, r[0].ToString())); // DataRow[] dataRowsDropCalls = localDataTable.Select(string.Format("rrcMsgName = '{0}' AND time = '{1}'", messageDropCalls, r[0].ToString())); // cdLocal.countMOC = dataRowsMOC.Length; // cdLocal.countMTC = dataRowsMTC.Length; // cdLocal.countDropCalls = dataRowsDropCalls.Length; // count.Add(cdLocal); // } // return count; // } // catch(Exception ex) // { // errorMessage = ex.Message; // return null; // } //} #endregion public List <countDate> getResult(string messageMOC, string messageMTC, string messageDropCalls, string mainDir) { try { List <countDate> count = new List <countDate>(); countDate cdLocal = new countDate(); TracerDatabaseComClass traceDB = new TracerDatabaseComClass(mainDir); string[] timeRows = traceDB.ReturnAlldates().ToArray(); foreach (string r in timeRows) { cdLocal = new countDate(); cdLocal.date = DateTime.Parse(r); DataTable tableTemp = traceDB.queryByRrcMessageAndTime(messageMOC, DateTime.Parse(r)); cdLocal.countMOC = tableTemp.Rows.Count; tableTemp = traceDB.queryByRrcMessageAndTime(messageMTC, DateTime.Parse(r)); cdLocal.countMTC = tableTemp.Rows.Count; tableTemp = traceDB.queryByRrcMessageAndTime(messageDropCalls, DateTime.Parse(r)); cdLocal.countDropCalls = tableTemp.Rows.Count; count.Add(cdLocal); } return(count); } catch (Exception ex) { errorMessage = ex.Message; return(null); } }