public Boolean P2Update(ModeloP2 o, int id, int estado)
{
var mysql = new DBConnection.ConexionMysql();
if (estado > 1)
{
query = String.Format("SET SQL_SAFE_UPDATES=0; " +
"UPDATE pat_p2 SET fkestado = '{0}' WHERE idp2 = '{1}'",
estado, id);
}
else
{
query = String.Format("SET SQL_SAFE_UPDATES=0; " +
"UPDATE pat_p2 SET fkprograma_ac = '{0}', col_uno = '{1}', col_dos = '{2}', " +
"col_tres = '{3}', col_cuatro = '{4}', col_cinco = '{5}' WHERE idp2 = '{6}'; ",
o.fkprograma, o.col_uno, o.col_dos, o.col_tres, o.col_cuatro, o.col_cinco, id);
}
try
{
mysql.AbrirConexion();
MySqlCommand cmd = new MySqlCommand(query, mysql.conectar);
cmd.ExecuteNonQuery();
mysql.CerrarConexion();
return(true);
}
catch
{
return(false);
}
}
public DataTable P2Create(ModeloP2 objCrear)
{
var mysql = new DBConnection.ConexionMysql();
DataTable dt = new DataTable();
query = String.Format("INSERT INTO pat_p2 (col_uno, col_dos, col_tres, col_cuatro, col_cinco, fkprograma_ac, fadn, anio, fkestado) " +
"VALUES ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}'); ",
objCrear.col_uno, objCrear.col_dos, objCrear.col_tres, objCrear.col_cuatro, objCrear.col_cinco, objCrear.fkprograma, objCrear.fadn, objCrear.ano, objCrear.fkestado);
mysql.AbrirConexion();
MySqlDataAdapter consulta = new MySqlDataAdapter(query, mysql.conectar);
consulta.Fill(dt);
mysql.CerrarConexion();
return(dt);
}
