static void Main(string[] args) { #region StartApp PersonDirectory pDirectory = new PersonDirectory(); pDirectory.Start(); #endregion } //end main
public static PersonDirectory getPersons(string stringSql) { PersonDirectory personDirectory = new PersonDirectory(); string sql = stringSql; OleDbCommand command = new OleDbCommand(sql, connect); try { connect.Open(); OleDbDataReader rd = command.ExecuteReader(); while (rd.Read()) { personDirectory.Persons.Add(new Person() { Id = Convert.ToInt32(rd["id"]), Nome = rd["nome"].ToString(), Rg = rd["rg"].ToString(), Cpf = rd["cpf"].ToString(), Nasc = rd["nasc"].ToString().Replace("00:00:00", ""), Re = rd["re"].ToString(), End = rd["end"].ToString() }); } return(personDirectory); } catch (Exception e) { Console.WriteLine("Ocorreu o Seguinte erro ao tentar a consulta na base de dados:\n" + e.Message); return(personDirectory); } finally { connect.Close(); } }
public void PersonDirectoryTestJson() { List <Person> persons = new List <Person> { new Student("nabeel", "234342"), new Student("yin", "3423423"), new Faculty("andruid", "professor"), new Student("bill", "4234"), new Student("sashi", "545454"), new Student("jon", "53453453") }; PersonDirectory p = new PersonDirectory(persons); SimplTypesScope simplTypesScope = SimplTypesScope.Get("personDir", typeof(Person), typeof(Faculty), typeof(Student), typeof(PersonDirectory)); TestMethods.TestSimplObject(p, simplTypesScope, Format.Json); }