private string GetValuesForCSVDataIntegrityAllFlags()
{
string delimiter = ",";
StringBuilder sb = new StringBuilder();
// If row is enabled, process it
foreach (DataGridViewRow item in dataGridView2.Rows)
{
if (Convert.ToBoolean(item.Cells[0].Value) == true) // if checkbox is enabled
{
if (item.Cells[8].Value == null) // Ignore if there is no data in rows
{
continue;
}
int valueID = Convert.ToInt32(item.Cells[1].Value); // Get id from row
List <FlagOccurrenceClass> flagList;
// Now find DataClass object binded with this valueID
//foreach (DataClass itemData in allData)
//{
// if (itemData == null)
// {
// continue;
// }
// if (itemData.cellID == valueID)
// {
// // DataClass object found, now get all flags and convert them in string (CSV) representation
// flagList = HelperGUIStats.GenerateReportForAllFlags(itemData);
// string res = HelperGUIStats.ConvertListToCSV(flagList, delimiter, itemData.cellID);
// sb.Append(res);
// }
//}
var tuple = GetInstanceFromAllDataByDeviceID(valueID);
if (tuple != null)
{
DataClass itemData = tuple.Item1;
// DataClass object found, now get all flags and convert them in string (CSV) representation
flagList = HelperGUIStats.GenerateReportForAllFlags(itemData);
string res = HelperGUIStats.ConvertListToCSV(flagList, delimiter, itemData.deviceID);
sb.Append(res);
}
}
}
if (sb.Length == 0)
{
throw new Exception("Couldn't get any data from Data Integrity");
}
sb.Remove(sb.Length - 2, 2); // Remove last new line
return(sb.ToString());
}
public FormGUIStats(DataClass item) : this()
{
int valueID = item.deviceID;
this.Text = "ID = " + valueID.ToString();
// Generate missing values report
int cnt = 0;
missingRows = HelperGUIStats.GenerateReport(item, ReportFlag.Missing);
FillRows(valueID, missingRows, ref cnt);
duplicateRows = HelperGUIStats.GenerateReport(item, ReportFlag.Duplicate);
FillRows(valueID, duplicateRows, ref cnt);
zeroRows = HelperGUIStats.GenerateReport(item, ReportFlag.Zero);
FillRows(valueID, zeroRows, ref cnt);
nullRows = HelperGUIStats.GenerateReport(item, ReportFlag.Null);
FillRows(valueID, nullRows, ref cnt);
repeatRows = HelperGUIStats.GenerateReport(item, ReportFlag.Repeat);
FillRows(valueID, repeatRows, ref cnt);
}
