public void DeserializeProperties() { try { if (File.Exists(PropertyfileName) == false) { return; } else { using (Stream stream = File.Open(PropertyfileName, FileMode.Open)) { PropertyLog log = PropertyLog.Create; BinaryFormatter bin = new BinaryFormatter(); var profiles = (Dictionary <string, Property>)bin.Deserialize(stream); foreach (var x in profiles) { if (log.Contains(x.Key) == false) { log.Add(x.Value); } } } } } catch (IOException ex) { throw new Exception(ex.Message); } }
public string ReadPAFFileSingle(string fileName, string sheetName, PostalAdress poobj) { string ConsoleLog = null; string ConnectionString = GetConnectionString(fileName); using (OleDbConnection conn = new OleDbConnection(ConnectionString)) { conn.Open(); cmd.Connection = conn; //+"."+ sheetName + string query = "SELECT * FROM [" + Path.GetFileName(fileName) + "] WHERE = '" + poobj.PCD.ToUpper() + "'"; cmd = new OleDbCommand(query, conn); // cmd.Parameters.AddWithValue("@p1",Path.GetFileName(fileName)); // cmd.Parameters.AddWithValue("@p2", poobj.PCD.ToUpper()); var x = cmd.ExecuteReader(); while (x.Read()) { if (String.IsNullOrWhiteSpace(x[11].ToString()) == false) { Property p = new Property(); p.DateAdded = DateTime.Now; try { p.ORD = x[0].ToString(); ConsoleLog += "Added" + p.ORD + "\n"; } catch (Exception) { throw new Exception("Can not Find"); } try { p.ORC = x[1].ToString(); } catch (Exception) { throw new Exception("Can not Find"); } try { p.SBN = x[2].ToString(); } catch (Exception) { throw new Exception("Can not Find"); } try { p.BNA = x[3].ToString(); // ConsoleLog += "Added" + p.BNA + "\n"; } catch (Exception) { throw new Exception("Can not Find"); } try { p.POB = x[4].ToString(); } catch (Exception) { throw new Exception("Can not Find"); } try { p.NUM = x[5].ToString(); } catch (Exception) { throw new Exception("Can not Find"); } try { p.DST = x[6].ToString(); } catch (Exception) { throw new Exception("Can not Find"); } try { p.STM = x[7].ToString(); } catch (Exception) { throw new Exception("Can not Find"); } try { p.DDL = x[8].ToString(); } catch (Exception) { throw new Exception("Can not Find"); } try { p.DLO = x[9].ToString(); } catch (Exception) { throw new Exception("Can not Find"); } try { p.PTN = x[10].ToString(); } catch (Exception) { throw new Exception("Can not Find"); } try { p.PCD = x[11].ToString(); } catch (Exception) { throw new Exception("Can not Find"); } try { p.CTA = x[12].ToString(); } catch (Exception) { throw new Exception("Can not Find"); } try { p.CTP = x[13].ToString(); } catch (Exception) { throw new Exception("Can not Find"); } try { p.CTT = x[14].ToString(); } catch (Exception) { throw new Exception("Can not Find"); } try { p.SCD = x[15].ToString(); } catch (Exception) { throw new Exception("Can not Find"); } try { p.CAT = x[16].ToString(); // ConsoleLog += "Added" + p.CAT + "\n"; } catch (Exception) { throw new Exception("Can not Find"); } try { p.NDP = x[17].ToString(); } catch (Exception) { throw new Exception("Can not Find"); } try { p.DPX = x[18].ToString(); } catch (Exception) { throw new Exception("Can not Find"); } try { p.URN = x[19].ToString(); } catch (Exception) { throw new Exception("Can not Find"); } try { p.PID = poobj.PID; } catch (Exception) { throw new Exception("Can not Find"); } PropertiesObj.Add(p); PostalAdressObj.Add(p); //adressList.Add(p.PID, p); PostalAdressObj.adressList[p.PID].AddPropertyKey(p.PID); } } cmd = null; conn.Close(); } return(ConsoleLog); }
public void ReadPAFFile(string FileName, PostalAdress poobj) { string ConsoleLog = null; CsvFileReader handler = new CsvFileReader(FileName); while (handler != null) { CsvRow row = new CsvRow(); handler.ReadRow(row); if (row.Count == 0) { break; } if (row[11].Equals(poobj.PCD.ToUpper()) == false) { OnInformationDownload(new EventArguments() { Name = "Trace: ", Time = DateTime.Now, Details = "Searching " + poobj.PCD.ToUpper() + "==" + row[11].ToUpper() }); continue; } else { OnInformationDownload(new EventArguments() { Name = "Trace: ", Time = DateTime.Now, Details = "Found Property " + poobj.PCD }); if (String.IsNullOrWhiteSpace(row[11].ToString()) == false) { Property p = new Property(); p.DateAdded = DateTime.Now; try { p.ORD = row[0].ToString(); ConsoleLog += "Added" + p.ORD + "\n"; } catch (Exception) { throw new Exception("Can not Find"); } try { p.ORC = row[1].ToString(); } catch (Exception) { throw new Exception("Can not Find"); } try { p.SBN = row[2].ToString(); } catch (Exception) { throw new Exception("Can not Find"); } try { p.BNA = row[3].ToString(); // ConsoleLog += "Added" + p.BNA + "\n"; } catch (Exception) { throw new Exception("Can not Find"); } try { p.POB = row[4].ToString(); } catch (Exception) { throw new Exception("Can not Find"); } try { p.NUM = row[5].ToString(); } catch (Exception) { throw new Exception("Can not Find"); } try { p.DST = row[6].ToString(); } catch (Exception) { throw new Exception("Can not Find"); } try { p.STM = row[7].ToString(); } catch (Exception) { throw new Exception("Can not Find"); } try { p.DDL = row[8].ToString(); } catch (Exception) { throw new Exception("Can not Find"); } try { p.DLO = row[9].ToString(); } catch (Exception) { throw new Exception("Can not Find"); } try { p.PTN = row[10].ToString(); } catch (Exception) { throw new Exception("Can not Find"); } try { p.PCD = row[11].ToString(); } catch (Exception) { throw new Exception("Can not Find"); } try { p.CTA = row[12].ToString(); } catch (Exception) { throw new Exception("Can not Find"); } try { p.CTP = row[13].ToString(); } catch (Exception) { throw new Exception("Can not Find"); } try { p.CTT = row[14].ToString(); } catch (Exception) { throw new Exception("Can not Find"); } try { p.SCD = row[15].ToString(); } catch (Exception) { throw new Exception("Can not Find"); } try { p.CAT = row[16].ToString(); // ConsoleLog += "Added" + p.CAT + "\n"; } catch (Exception) { throw new Exception("Can not Find"); } try { p.NDP = row[17].ToString(); } catch (Exception) { throw new Exception("Can not Find"); } try { p.DPX = row[18].ToString(); } catch (Exception) { throw new Exception("Can not Find"); } try { p.URN = row[19].ToString(); } catch (Exception) { throw new Exception("Can not Find"); } try { p.PID = poobj.PID; } catch (Exception) { throw new Exception("Can not Find"); } p.SetAdressAutomatically(); log.Add(p); POlog.Add(p); //adressList.Add(p.PID, p); POlog.adressList[p.PID].AddPropertyKey(p.PCD + p.URN); } } } }