public static EnumTypeFavoris Load(int id)
{
EnumTypeFavoris myItem = null;
StringBuilder mySql = new StringBuilder();
mySql.Append("SELECT ");
mySql.Append(GetSelectFields() + " ");
mySql.Append("FROM `EnumTypeFavoris` enumtypefavoris ");
mySql.Append("WHERE `id` = @id ");
using (MySqlConnection myConnection = new MySqlConnection(Param.MySQLConnectionString))
{
MySqlCommand myCommand = new MySqlCommand(mySql.ToString(), myConnection);
myCommand.CommandType = CommandType.Text;
myCommand.Parameters.AddWithValue("@id", id);
myConnection.Open();
using (MySqlDataReader myReader = myCommand.ExecuteReader())
{
if (myReader.HasRows)
{
myReader.Read();
myItem = LoadADO(myReader);
}
myReader.Close();
}
myConnection.Close();
}
return(myItem);
}
public static List <EnumTypeFavoris> FindAll()
{
EnumTypeFavoris myItem = null;
List <EnumTypeFavoris> listItem = new List <EnumTypeFavoris>();
StringBuilder mySql = new StringBuilder();
mySql.Append("SELECT ");
mySql.Append(GetSelectFields() + " ");
mySql.Append("FROM `EnumTypeFavoris` enumtypefavoris ");
mySql.Append("WHERE 1 ");
using (MySqlConnection myConnection = new MySqlConnection(Param.MySQLConnectionString))
{
MySqlCommand myCommand = new MySqlCommand(mySql.ToString(), myConnection);
myCommand.CommandType = CommandType.Text;
myConnection.Open();
using (MySqlDataReader myReader = myCommand.ExecuteReader())
{
if (myReader.HasRows)
{
while (myReader.Read())
{
myItem = LoadADO(myReader);
listItem.Add(myItem);
}
}
myReader.Close();
}
myConnection.Close();
}
return(listItem);
}
private static EnumTypeFavoris LoadADO(MySqlDataReader myReader)
{
EnumTypeFavoris myItem = new EnumTypeFavoris();
myItem.id = iZyMySQL.GetIntFromDBInt(myReader["enumtypefavoris_id"]);
myItem.libelle = iZyMySQL.GetStringFromDBString(myReader["enumtypefavoris_libelle"]);
return(myItem);
}
public static EnumTypeFavoris Update(EnumTypeFavoris myItem)
{
using (MySqlConnection myConnection = new MySqlConnection(Param.MySQLConnectionString))
{
StringBuilder mySql = new StringBuilder();
mySql.Append("UPDATE `EnumTypeFavoris` SET ");
mySql.Append("`libelle` = @libelle ");
mySql.Append("WHERE `id` = @id ");
MySqlCommand myCommand = new MySqlCommand(mySql.ToString(), myConnection);
myCommand.CommandType = CommandType.Text;
myCommand.Parameters.AddWithValue("@id", myItem.id);
myCommand.Parameters.AddWithValue("@libelle", myItem.libelle);
myConnection.Open();
myCommand.ExecuteNonQuery();
myConnection.Close();
}
return(myItem);
}
public static EnumTypeFavoris Insert(EnumTypeFavoris myItem)
{
using (MySqlConnection myConnection = new MySqlConnection(Param.MySQLConnectionString))
{
StringBuilder mySql = new StringBuilder();
mySql.Append("INSERT INTO `EnumTypeFavoris` ");
mySql.Append("(`libelle` )");
mySql.Append(" VALUES ");
mySql.Append("(@libelle );");
mySql.Append("SELECT LAST_INSERT_ID(); ");
MySqlCommand myCommand = new MySqlCommand(mySql.ToString(), myConnection);
myCommand.CommandType = CommandType.Text;
myCommand.Parameters.AddWithValue("@libelle", myItem.libelle);
myConnection.Open();
myItem.id = iZyMySQL.GetIntFromDBInt(myCommand.ExecuteScalar());
myConnection.Close();
}
return(myItem);
}
public static EnumTypeFavoris Insert(EnumTypeFavoris myItem)
{
using (MySqlConnection myConnection = new MySqlConnection(Param.MySQLConnectionString))
{
StringBuilder mySql = new StringBuilder();
mySql.Append("INSERT INTO `EnumTypeFavoris` ");
mySql.Append("(`libelle` )");
mySql.Append(" VALUES ");
mySql.Append("(@libelle );");
mySql.Append("SELECT LAST_INSERT_ID(); ");
MySqlCommand myCommand = new MySqlCommand(mySql.ToString(), myConnection);
myCommand.CommandType = CommandType.Text;
myCommand.Parameters.AddWithValue("@libelle", myItem.libelle);
myConnection.Open();
myItem.id = iZyMySQL.GetIntFromDBInt(myCommand.ExecuteScalar());
myConnection.Close();
}
return myItem;
}
private static EnumTypeFavoris LoadADO(MySqlDataReader myReader)
{
EnumTypeFavoris myItem = new EnumTypeFavoris();
myItem.id = iZyMySQL.GetIntFromDBInt(myReader["enumtypefavoris_id"]);
myItem.libelle = iZyMySQL.GetStringFromDBString(myReader["enumtypefavoris_libelle"]);
return myItem;
}
public static EnumTypeFavoris Update(EnumTypeFavoris myItem)
{
using (MySqlConnection myConnection = new MySqlConnection(Param.MySQLConnectionString))
{
StringBuilder mySql = new StringBuilder();
mySql.Append("UPDATE `EnumTypeFavoris` SET ");
mySql.Append("`libelle` = @libelle ");
mySql.Append("WHERE `id` = @id ");
MySqlCommand myCommand = new MySqlCommand(mySql.ToString(), myConnection);
myCommand.CommandType = CommandType.Text;
myCommand.Parameters.AddWithValue("@id", myItem.id);
myCommand.Parameters.AddWithValue("@libelle", myItem.libelle);
myConnection.Open();
myCommand.ExecuteNonQuery();
myConnection.Close();
}
return myItem;
}
