public DataTable LogoCreate(ModeloLogotipo objCrear)
{
var mysql = new DBConnection.ConexionMysql();
DataTable dt = new DataTable();
query = String.Format("INSERT INTO dbsecretaria.sg_logotipo (logo, fkfadn) " +
"VALUES('{0}', '{1}');", objCrear.logo, objCrear.fkfadn);
mysql.AbrirConexion();
MySqlDataAdapter consulta = new MySqlDataAdapter(query, mysql.conectar);
consulta.Fill(dt);
mysql.CerrarConexion();
return(dt);
}
public Boolean UpdateLogotipo(ModeloLogotipo objEditar, int id)
{
var mysql = new DBConnection.ConexionMysql();
query = String.Format("SET SQL_SAFE_UPDATES=0; " +
"UPDATE dbsecretaria.sg_logotipo SET logo = '{0}', fkfadn = '{1}' WHERE idbrecha = '{2}';",
objEditar.logo, objEditar.fkfadn, id);
try
{
mysql.AbrirConexion();
MySqlCommand cmd = new MySqlCommand(query, mysql.conectar);
cmd.ExecuteNonQuery();
mysql.CerrarConexion();
return(true);
}
catch
{
return(false);
}
}
