public List <PersonModel> GetAllPersonsId() { DataTable dt = new DataTable(); using (OleDbCommand command = new OleDbCommand()) { dt = GetMultipleQuery(PersonStringsInner.GetAllPersonsId()); } List <PersonModel> arrPerson = new List <PersonModel>(); foreach (DataRow ms in dt.Rows) { arrPerson.Add(PersonModel.ToObject(ms)); } return(arrPerson); }
public PersonModel GetOnePersonById(string personId) { DataTable dt = new DataTable(); if (personId.Equals(string.Empty) || personId.Equals("")) { throw new ArgumentOutOfRangeException(); } PersonModel personModel = new PersonModel(); using (OleDbCommand command = new OleDbCommand()) { dt = GetMultipleQuery(PersonStringsInner.GetOnePersonById(personId)); } foreach (DataRow ms in dt.Rows) { personModel = PersonModel.ToObject(ms); } return(personModel); }