public bool checkIfIdExists(string personId) { DataTable dt = new DataTable(); if (personId.Equals(string.Empty) || personId.Equals("")) { throw new ArgumentOutOfRangeException(); } using (OleDbCommand command = new OleDbCommand()) { dt = GetMultipleQuery(PersonStringsInner.checkIfIdExists(personId)); } int num = 0; foreach (DataRow ms in dt.Rows) { num = int.Parse(ms[0].ToString()); } if (num == 0) { return(false); } else { return(true); } }
public int DeletePerson(string personId) { int i = 0; using (OleDbCommand command = new OleDbCommand()) { i = ExecuteNonQuery(PersonStringsInner.DeletePerson(personId)); } return(i); }
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); }