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); }