public SubContractDTO GetSubContract(int id) { SubContractDTO subContract = null; String query = "SELECT SUBC.*, TIPC.sigla as tipoContrato FROM `addoncontratos`.`subContrato` SUBC " + "JOIN `addoncontratos`.`tipoContrato` TIPC ON SUBC.tipocontrato_id = TIPC.id WHERE SUBC.id = " + id; MySqlCommand command = new MySqlCommand(query, this.mySqlConnection); MySqlDataReader dataReader = command.ExecuteReader(); if (dataReader.Read()) { subContract = new SubContractDTO(); subContract.id = (int)dataReader["id"]; subContract.contrato_id = (int)dataReader["contrato_id"]; subContract.tipoContrato_id = (int)dataReader["tipoContrato_id"]; subContract.siglaTipo = (String)dataReader["tipoContrato"]; } dataReader.Close(); return subContract; }
public List<SubContractDTO> GetSubContracts(String filter) { List<SubContractDTO> subContractList = new List<SubContractDTO>(); if (!String.IsNullOrEmpty(filter)) filter = " WHERE " + filter; String query = "SELECT SUBC.*, TIPC.sigla as tipoContrato FROM `addoncontratos`.`subContrato` SUBC " + "JOIN `addoncontratos`.`tipoContrato` TIPC ON SUBC.tipocontrato_id = TIPC.id " + filter + ";"; MySqlCommand command = new MySqlCommand(query, this.mySqlConnection); MySqlDataReader dataReader = command.ExecuteReader(); while (dataReader.Read()) { SubContractDTO subContract = new SubContractDTO(); subContract.id = (int)dataReader["id"]; subContract.contrato_id = (int)dataReader["contrato_id"]; subContract.tipoContrato_id = (int)dataReader["tipoContrato_id"]; subContract.siglaTipo = (String)dataReader["tipoContrato"]; subContractList.Add(subContract); } dataReader.Close(); return subContractList; }