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); }