public string getNumber(SucursalEnt sucursal)
{
SqlConnection sqlConnection = new SqlConnection(ConexionDal.connectionString);
SqlCommand sqlCommand = sqlConnection.CreateCommand();
sqlCommand.CommandType = CommandType.Text;
sqlCommand.CommandText = "Select Numero From Sucursal Where Estado = 1 And Id = @Id";
sqlCommand.Parameters.AddWithValue("@Id", sucursal.ID);
sqlConnection.Open();
string number = Convert.ToString(sqlCommand.ExecuteScalar());
sqlConnection.Close();
return number;
}
public void update(SucursalEnt sucursal)
{
SqlConnection sqlConnection = new SqlConnection(ConexionDal.connectionString);
SqlCommand sqlCommand = sqlConnection.CreateCommand();
sqlCommand.CommandType = CommandType.Text;
sqlCommand.CommandText = "Update Sucursal Set Numero = @Numero, Direccion = @Direccion, Telefono = @Telefono, "
+ "Municipio = @Municipio Where Id = @Id";
sqlCommand.Parameters.AddWithValue("@Numero", sucursal.NUMERO);
sqlCommand.Parameters.AddWithValue("@Direccion", sucursal.DIRECCION);
if (sucursal.TELEFONO != "")
{
sqlCommand.Parameters.AddWithValue("@Telefono", sucursal.TELEFONO);
}
else
{
sqlCommand.Parameters.AddWithValue("@Telefono", DBNull.Value);
}
sqlCommand.Parameters.AddWithValue("@Municipio", sucursal.MUNICIPIO);
sqlCommand.Parameters.AddWithValue("@Id", sucursal.ID);
sqlConnection.Open();
sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
}
public void update(SucursalEnt sucursal)
{
objetoSucursal.update(sucursal);
}
public string getNumber(SucursalEnt sucursal)
{
return objetoSucursal.getNumber(sucursal);
}