public DomainObject GetOneForID(DomainObject odo) { try { command.CommandText = $"SELECT * FROM {odo.TableName} WHERE {odo.ConditionID}"; reader = command.ExecuteReader(); DataTable tabela = new DataTable(); tabela.Load(reader); reader.Close(); if (tabela.Rows.Count == 0) { return(null); } else { return(odo.ReadRowOfTable(tabela.Rows[0])); } } catch (Exception) { reader.Close(); throw; } }
public List <DomainObject> GetForCondition(DomainObject odo) { List <DomainObject> lists = new List <DomainObject>(); try { command.CommandText = $"SELECT * FROM {odo.TableName} WHERE {odo.MainCondition}"; reader = command.ExecuteReader(); DataTable tabela = new DataTable(); tabela.Load(reader); reader.Close(); if (tabela.Rows.Count == 0) { return(null); } foreach (DataRow row in tabela.Rows) { lists.Add(odo.ReadRowOfTable(row)); } return(lists); } catch (Exception) { reader.Close(); throw; } }
public List <DomainObject> GetAll(DomainObject domainObject) { List <DomainObject> lists = new List <DomainObject>(); try { command.CommandText = $"SELECT * FROM {domainObject.TableName}"; reader = command.ExecuteReader(); DataTable table = new DataTable(); table.Load(reader); foreach (DataRow row in table.Rows) { lists.Add(domainObject.ReadRowOfTable(row)); } reader.Close(); return(lists); } catch (Exception) { reader.Close(); throw; } }