public void addNewValuetoCSV(AssetImport assetImportItem) { try { string ResourceDirectoryPath = Directory.GetParent(Directory.GetCurrentDirectory()) + @"/GeneralKnowledge.Test/Resources/AssetImport.csv"; StringBuilder NewRow = new StringBuilder(); var newLine = string.Format("{0},{1},{2},{3},{4},{5},{6},{7}", assetImportItem.assetId, assetImportItem.fileName, assetImportItem.mimeType, assetImportItem.createdBy, assetImportItem.email, assetImportItem.country, assetImportItem.description, Environment.NewLine); NewRow.Append(newLine); File.AppendAllText(ResourceDirectoryPath, NewRow.ToString()); } catch (Exception ex) { throw ex; } }
public void UpdateRecordInCSV(AssetImport assetImportItem) { try { string ResourceDirectoryPath = Directory.GetParent(Directory.GetCurrentDirectory()) + @"/GeneralKnowledge.Test/Resources/AssetImport.csv"; var lstAssetImport = File.ReadAllLines(ResourceDirectoryPath).ToList(); foreach (var rowitem in lstAssetImport) { List <string> colvalue = rowitem.Split(',').ToList <string>(); StringBuilder NewRow = new StringBuilder(); string line = string.Empty; foreach (var col in colvalue) { if (col.Equals(assetImportItem.assetId)) { line = string.Format("{0},{1},{2},{3},{4},{5},{6},{7}", assetImportItem.assetId, assetImportItem.fileName, assetImportItem.mimeType, assetImportItem.createdBy, assetImportItem.email, assetImportItem.country, assetImportItem.description, Environment.NewLine); } NewRow.Append(line); File.AppendAllText(ResourceDirectoryPath, NewRow.ToString()); } } } catch (Exception ex) { throw ex; } }