public override Patron read(int id) { Patron dto = null; if (id > 0) { MySQL_DBManager db = new MySQL_DBManager(DBCredentials_Factory.getCredentials(typeof(Patron))); string query = "SELECT `nombre` FROM `patron` WHERE `id` = @identifier"; Value values = new Value(); values.add("@identifier", id.ToString()); MySqlDataReader reader = db.ExceuteSQL(query, values); if (reader != null) { if (reader.Read()) { dto = new Patron(); dto.setid(id); if (!reader.IsDBNull(0)) { dto.setnombre(reader.GetString(0)); } } reader.Close(); } db.close(); } return(dto); }
public override List <Patron> readALL(Limiter limiter) { List <Patron> list = null; MySQL_DBManager db = new MySQL_DBManager(DBCredentials_Factory.getCredentials(typeof(Patron))); string query = "SELECT id FROM patron"; if (limiter != null) { query += " LIMIT " + limiter.ResultsOffeset + "," + limiter.ResultsCount + ";"; } else { query += ";"; } MySqlDataReader reader = db.ExceuteSQL(query); if (reader != null) { list = new List <Patron>(); while (reader.Read()) { Patron dto = read(reader.GetInt32(0)); if (dto != null) { list.Add(dto); } } reader.Close(); } db.close(); return(list); }
public override Tendencia read(int id) { Tendencia dto = null; if (id > 0) { MySQL_DBManager db = new MySQL_DBManager(DBCredentials_Factory.getCredentials(typeof(Tendencia))); string query = "SELECT `Categoria_id`, `Patron_id`, `medida` FROM `tendencia` WHERE `id` = @identifier"; Value values = new Value(); values.add("@identifier", id.ToString()); MySqlDataReader reader = db.ExceuteSQL(query, values); if (reader != null) { if (reader.Read()) { dto = new Tendencia(); dto.setid(id); if (!reader.IsDBNull(0)) { dto.setCategoria_id(reader.GetInt32(0)); } if (!reader.IsDBNull(1)) { dto.setPatron_id(reader.GetInt32(1)); } dto.setmedida(reader.GetInt32(2)); } reader.Close(); } db.close(); } return(dto); }
public override List <Tendencia> readALL(Patron patron) { List <Tendencia> list = null; if (patron.getid() > 0) { MySQL_DBManager db = new MySQL_DBManager(DBCredentials_Factory.getCredentials(typeof(Tendencia))); string query = "SELECT E2.id FROM tendencia E2 JOIN patron E1 ON E1.id = E2.Patron_id WHERE E1.id = @Identifier"; Value values = new Value(); values.add("@identifier", patron.getid().ToString()); MySqlDataReader reader = db.ExceuteSQL(query, values); if (reader != null) { list = new List <Tendencia>(); while (reader.Read()) { Tendencia dto = read(reader.GetInt32(0)); if (dto != null) { list.Add(dto); } } reader.Close(); } db.close(); } return(list); }
public override void delete(int id) { MySQL_DBManager db = new MySQL_DBManager(DBCredentials_Factory.getCredentials(typeof(Patron))); string query = "DELETE FROM `patron` WHERE `patron`.`id` = @identifier;"; Value values = new Value(); values.add("@identifier", id.ToString()); db.ExecSQL(query, values); }
public override bool update(Patron dto) { if (dto != null && dto.isValid() && dto.getid() > 0) { MySQL_DBManager db = new MySQL_DBManager(DBCredentials_Factory.getCredentials(typeof(Patron))); string query = "UPDATE `patron` SET `nombre` = @nombre WHERE `patron`.`id` = @identifier;"; Value values = new Value(); values.add("@nombre", dto.getnombre()); values.add("@identifier", dto.getid().ToString()); return(db.ExecSQL(query, values)); } return(false); }
public override bool update(Tendencia dto) { if (dto != null && dto.isValid() && dto.getid() > 0) { MySQL_DBManager db = new MySQL_DBManager(DBCredentials_Factory.getCredentials(typeof(Tendencia))); string query = "UPDATE `tendencia` SET `Categoria_id` = @Categoria_id, `Patron_id` = @Patron_id, `medida` = @medida WHERE `tendencia`.`id` = @identifier;"; Value values = new Value(); values.add("@Categoria_id", dto.getCategoria_id().ToString()); values.add("@Patron_id", dto.getPatron_id().ToString()); values.add("@medida", dto.getmedida().ToString()); values.add("@identifier", dto.getid().ToString()); return(db.ExecSQL(query, values)); } return(false); }
public void setKnowledge(Patron patron, Categoria cat) { if (patron != null && cat != null) { if (!String.IsNullOrEmpty(patron.getnombre()) && cat.getid() > 0) { MySQL_DBManager db = new MySQL_DBManager(DBCredentials_Factory.getCredentials(typeof(Tendencia))); string query = "CALL `setKnowledge`(@p0, @p1);"; Value values = new Value(); values.add("@p0", patron.getnombre()); values.add("@p1", cat.getid().ToString()); db.ExecSQL(query, values); } } }
//Methods public override bool create(Patron dto) { if (dto != null && dto.isValid()) { MySQL_DBManager db = new MySQL_DBManager(DBCredentials_Factory.getCredentials(typeof(Patron))); string query = "INSERT INTO `patron` ( `id`, `nombre`) VALUES ( NULL, @nombre);"; Value values = new Value(); values.add("@nombre", dto.getnombre()); if (db.ExecSQL(query, values)) { dto.setid((int)db.getLastInsertedID()); return(true); } } return(false); }
//Methods public override bool create(Tendencia dto) { if (dto != null && dto.isValid()) { MySQL_DBManager db = new MySQL_DBManager(DBCredentials_Factory.getCredentials(typeof(Tendencia))); string query = "INSERT INTO `tendencia` ( `id`, `Categoria_id`, `Patron_id`, `medida`) VALUES ( NULL, @Categoria_id, @Patron_id, @medida);"; Value values = new Value(); values.add("@Categoria_id", dto.getCategoria_id().ToString()); values.add("@Patron_id", dto.getPatron_id().ToString()); values.add("@medida", dto.getmedida().ToString()); if (db.ExecSQL(query, values)) { dto.setid((int)db.getLastInsertedID()); return(true); } } return(false); }
public override Patron read(string item) { Patron patron = null; MySQL_DBManager db = new MySQL_DBManager(DBCredentials_Factory.getCredentials(typeof(Patron))); string query = "SELECT patron.id FROM `patron` WHERE patron.nombre = @nombre"; Value values = new Value(); values.add("@nombre", item); MySqlDataReader reader = db.ExceuteSQL(query, values); if (reader != null) { if (reader.Read()) { patron = read(reader.GetInt32(0)); } reader.Close(); } db.close(); return(patron); }