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);
}
