public void Eliminar(Movimiento mov)
{
try
{
sentencia = "Delete from movimientos Where idmovimiento = " + mov.idMovimiento.ToString();
conexion.Open();
comando = new SqlCommand(sentencia, conexion);
comando.CommandType = CommandType.Text;
comando.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (conexion != null)
{
conexion.Close();
}
conexion.Dispose();
}
}
public void Insertar(Movimiento mov)
{
try
{
sentencia = "insert into movimientos values ('" + mov.Concepto + "','" + mov.Tipo + "','" + mov.SubTipo + "','" + mov.Fecha + "'," + mov.Monto + ",'" + mov.Mes + "')";
conexion.Open();
comando = new SqlCommand(sentencia, conexion);
comando.CommandType = CommandType.Text;
comando.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (conexion != null)
{
conexion.Close();
}
conexion.Dispose();
}
}
public void Actualizar(Movimiento mov)
{
try
{
//sentencia = "Update Menu Set concepto ='" + mov.Concepto + "','" + mov.Tipo + "','" + mov.SubTipo + "','" + mov.Fecha + "'," + mov.Monto + ",'" + mov.Mes + "' Where nombreMenu =' " + NombreMenu + "'";
sentencia = "";
conexion.Open();
comando = new SqlCommand(sentencia, conexion);
comando.CommandType = CommandType.Text;
comando.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (conexion != null)
{
conexion.Close();
}
conexion.Dispose();
}
}
