public string ValidateEngineerList(string filepath) { string output = ""; try { if (File.Exists(filepath)) { DataFile fileData = new DataFile(); fileContent = df.readFile(filepath); int count; for (int i = 1; i < fileContent.Count; i++) { count = i + 1; string fileLine = fileContent[i].ToString(); string[] fLine = fileLine.Split(','); if (fLine.Length == 2) { string EngineerName = fLine[0].ToString(); string EngineerContact = fLine[1].ToString(); if (EngineerContact.Length.Equals(9)) { EngineerContact = "0" + EngineerContact; } data_table = data_file.EngineerNumberExists(EngineerContact); if (data_table.Rows.Count < 1) { if (EngineerName.Equals("")) { output = "The Engineer Name at Line " + count + " is Incorrect"; return(output); } else if (EngineerContact.Equals("")) { output = "The Engineer Contact can not be empty at Line " + count; return(output); } } else { output = "The Engineer Contact at Line " + count + " Already Exists"; return(output); } } else { output = "Invalid Number of Columns on line count All the file line Should have 2 Columns"; return(output); } } output = "NONE"; return(output); } else { output = "The File Name Does Not Exist"; return(output); } } catch (Exception ex) { throw ex; } }