GetKey5ForUD06

GetKey5ForUD06.cs

private static string GetKey5ForUD06(EpiDataView edvUD06, Ice.UI.App.UD06Entry.Transaction ud06Trans)
{
  // Get unique row count id for Key5
  int rowCount = edvUD06.dataView.Table.Rows.Count;
  int lineNum = rowCount;
  bool goodIndex = false;
  while ((goodIndex == false))
  {
    // Check to see if index exists
    DataRow[] matchingRows = edvUD06.dataView.Table.Select("Key5 = \'" + lineNum.ToString() + "\'");
    if ((matchingRows.Length > 0))
    {
      lineNum = (lineNum + 1);
    }
    else
    {
      goodIndex = true;
    }
  }
  var edvUD06Row = edvUD06.CurrentDataRow;
  var ud06Adapter = new UD06Adapter(ud06Trans);
  ud06Adapter.BOConnect();
  try
  {
    var ud06Exists = ud06Adapter.GetByID(edvUD06Row["Key1"], "", "", "", lineNum.ToString());
    if (ud06Exists)
    {
      goodIndex = false;
      var dsUD06 = ud06Adapter.GetData(edvUD06Row["Key1"], "", "", "", lineNum.ToString());
      while ((goodIndex == false))
      {
        // Check to see if index exists
        DataRow[] matchingRows = dsUD06.Tables[0].Select("Key5 = \'" + lineNum.ToString() + "\'");
        if ((matchingRows.Length > 0))
        {
          lineNum = (lineNum + 1);
        }
        else
        {
          goodIndex = true;
        }
      }
    }
  }
  catch (Exception) { }
  finally
  {
    ud06Adapter.Dispose();
  }
  return lineNum.ToString();
}