public bool Reader(OperationType type, ref AddressBooks addressBooks)
{
LogDetails logDetails = new LogDetails();
IDataSourceOperation dataSourceOperation;
if (type == OperationType.Mock)
{
dataSourceOperation = new MockDataSourceOperation();
}
else
{
dataSourceOperation = new JsonOperation();
}
try
{
addressBooks = DictToListMapping.ListToDictionary(Reader(dataSourceOperation));
}
catch (Exception e)
{
logDetails.LogDebug("IO Error in Reading operation");
logDetails.LogError(e.Message);
return(false);
}
return(true);
}
/// <summary>
/// Read from CSV file to store in address books
/// </summary>
/// <param name="addressBooks"></param>
public static void ReadFromCsv(ref AddressBooks addressBooks)
{
DictToListMapping dictToListMapping = new DictToListMapping();
var lines = File.ReadAllLines(path);
var csv = from line in lines
select(line.Split('\n')).ToArray();
DictToListMapping dictToList = new DictToListMapping();
int index = 0;
foreach (var words in csv)
{
if (index == 0)
{
index++;
continue;
}
var values = words[0].Split(',');
dictToList.AddressBookName.Add(values[0]);
dictToList.ContactName.Add(values[1]);
dictToList.FirstName.Add(values[2]);
dictToList.LastName.Add(values[3]);
dictToList.City.Add(values[4]);
dictToList.State.Add(values[5]);
dictToList.ZipCode.Add(values[6]);
dictToList.PhoneNumber.Add(values[7]);
dictToList.Email.Add(values[8]);
}
addressBooks = DictToListMapping.ListToDictionary(dictToList);
}
public static void ReadFromSqlServer(ref AddressBooks addressBooks)
{
DictToListMapping dictToList = new DictToListMapping();
using (SqlConnection connection = new SqlConnection(path))
{
SqlCommand command = new SqlCommand("select * from AddressBook", connection);
connection.Open();
SqlDataReader dataReader = command.ExecuteReader();
while (dataReader.Read())
{
dictToList.AddressBookName.Add(dataReader["AddressBookName"].ToString());
dictToList.ContactName.Add(dataReader["ContactName"].ToString());
dictToList.FirstName.Add(dataReader["FirstName"].ToString());
dictToList.LastName.Add(dataReader["LastName"].ToString());
dictToList.City.Add(dataReader["City"].ToString());
dictToList.State.Add(dataReader["State"].ToString());
dictToList.ZipCode.Add(dataReader["Zip"].ToString());
dictToList.PhoneNumber.Add(dataReader["Phone"].ToString());
dictToList.Email.Add(dataReader["Email"].ToString());
dictToList.DateAdded.Add((DateTime)dataReader["DateAdded"]);
}
}
addressBooks = DictToListMapping.ListToDictionary(dictToList);
}
/// <summary>
/// Read from JSON file to store in address books
/// </summary>
/// <param name="addressBooks"></param>
public static void ReadFromJson(ref AddressBooks addressBooks)
{
DictToListMapping dictToList = new DictToListMapping();
string jsonData = File.ReadAllText(path);
dictToList = JsonConvert.DeserializeObject <DictToListMapping>(jsonData);
addressBooks = DictToListMapping.ListToDictionary(dictToList);
}